@
mysql_connect($hostname,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM Pizza";
$result=mysql_query($query);
//$num=mysql_numrows($result);
$IndexVal=$_POST['IndexVal'];
//int($IndexVal);
$NamePizza=$_POST['NamePizza'];
$Discription=$_POST['Discription'];
$MPRICE=$_POST['MPRICE'];
$LPRICE=$_POST['LPRICE'];
$XLPRICE=$_POST['XLPRICE'];
$query = "UPDATE Pizza SET Name='$NamePizza',Discription='$Discription',MPrice='$MPRICE',LPrice='$LPRICE',XLPrice='$XLPRICE' WHERE ID='$IndexVal'";
//$query = "UPDATE Pizza VALUES ('$NamePizza','$Discription','$MPRICE','$LPRICE','$XLPRICE' WHERE id='$IndexVal')";
mysql_query($query);