Here is my code. echo '<p>item updated successfully!</p>'; is triggered but db is not changed. $_POST verriables are successfully passed to the PHP verriables.
if (isset($_POST['change'])): //if updates have been entered and need to be $date=$_POST['date']; $maincourse=$_POST['maincourse']; $veggie=$_POST['veggie']; $veggie2=$_POST['veggie2']; $fruit=$_POST['fruit']; $dessert=$_POST['dessert']; $drink=$_POST['drink']; $bread=$_POST['bread']; $fromwhere=$_POST['fromwhere']; $xdate=$_POST['xdate']; $zdate=$_POST['zdate'];
$ok1 = @mysql_query("UPDATE $fromwhere SET day='$day', maincourse='$maincourse',
Got the Date working. I changed the structure for display when quering to read something like Tue, Oct. 8. When I copied and pasted the sql query (hey it was a long query and I'm to lazy to retype it) I had to delete that