session_start();
if(!isset($_SESSION['udesig']) || $_SESSION['udesig']!="admin")
header("Location:loginmain.php");
include "head.inc";
if(isset($_GET[id]) && $_GET[id]!="")
{
include "common.php";
dbconnect();
$sql_getvals = "select * from items_of_interest where rec_id=".$_GET[id];
$rows = mysql_fetch_row(mysql_query($sql_getvals));
if(!isset($_GET["Submit"]))
{
?>
| ::. ADMINISTRATOR>>MAIN>>UPDATE SPARE PART |
|
}
else
{
$sql_del = "delete from items_of_interest where rec_id=".$_GET['id'];
mysql_query($sql_del);
//copy($carpicture,"images/".$img_id);
if($car_picture!="")
{
$img_loc = "images/".$car_picture;
}
else
$img_loc = "null";
$car_seqno = $_GET["car_seqno"];
$car_make = $_GET["car_make"];
$car_model = $_GET["car_model"];
$car_year = $_GET["car_year"];
$car_notes = $_GET["car_notes"];
$sql = "INSERT INTO `items_of_interest` ( `rec_Id` , `seqno` , `make` , `model` , `year` , `notes` , `picture_Link` )
VALUES ('',$car_seqno,'$car_make','$car_model','$car_year','$car_notes','$img_loc')";
$result = @mysql_query($sql);
if($result)
{
mysql_close();
print_msg("Spare Part details updated !!","admin_main.php");
}
else
{
print_msg("Process failed !!".mysql_error(),"admin_main.php");
}
}
}
else
{
include "common.php";
dbconnect();
if(!$_GET["sort"])
$sql = "select * from items_of_interest order by make ASC";
else
{
$sql = "select * from items_of_interest where seqno = ".$_GET['sort']." order by make ASC";
$sql2 = "select * from items_of_interest where seqno != ".$_GET['sort']." order by seqno,make ASC";
}
$seqsql = "select distinct seqno from items_of_interest order by seqno ASC";
$seqresult = mysql_query($seqsql);
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
if(isset($sql2))
{
$result2 = mysql_query($sql2);
$numrows = $numrows+mysql_num_rows($result2);
}
?>
| ::. ADMINISTRATOR>>MAIN>>SPARE PART VIEW(UPDATE) |
if($numrows<1)
{
?>
| No records available !! |
exit;
}
else
{
?>
while($row=mysql_fetch_row($result))
{
if(strtolower($row[6])=="null")
{
$picpath = "images/empty.gif";
$pic = " ";
}
else
{
$picpath = $row[6];
$pic = " ";
}
?>
|
=$row[1]?>
|
=$row[2]?>
|
=$row[3]?>
|
=$row[4]?>
|
=$row[5]?>
|
=$pic?>
|
}
}
if(isset($result2))
{
while($row2=mysql_fetch_row($result2))
{
if(strtolower($row2[6])=="null")
{
$picpath = "images/empty.gif";
$pic = " ";
}
else
{
$picpath = $row2[6];
$pic = " ";
}
?>
|
=$row2[1]?>
|
=$row2[2]?>
|
=$row2[3]?>
|
=$row2[4]?>
|
=$row2[5]?>
|
=$pic?>
|
}
}
?>
|
}
include "foot.inc";
?>