Close Window

Mysql command in PHP syntax to update record

    $query = "UPDATE foodmenu
    SET foodseq   = '$sfoodseq[$ix]',
        foodhdr   = '$sfoodhdr[$ix]',
        foodprice = '$sfoodprice[$ix]',
        fooditem  = '$sfooditem[$ix]'

    WHERE id = $sid[$ix] LIMIT 1";

    $result=mysql_query($query) or
       die( "Unable to update foodmenu

             Record no: $sid[$ix]

             in amodfood.php!
" . mysql_error());

Close Window