|
hey_pal -> PHP/MySQL UPDATE not working (10/23/2005 4:42:03)
|
OK, so I've really racked my brain on this one. I can't for the life of me to get my PHP UPDATE command working. It just doesn't update the database. INSERT and DELETE work just fine. Here are the relevant lines:
$update = "UPDATE schedule SET day='$day', time='$time', host1='$host1', host2='$host2', email1='$email1', email2='$email2', title='$title', desc='$desc' WHERE id='$id'";
$result = mysql_query($update);
I have it echo the $update string, and all the values are in there correctly. The day, time, and id columns are integer type, but removing the single-quotes didn't help. I've searched everywhere for clues to what could be going wrong, but I really have no idea. Any suggestions would be much appreciated!
|
|
|
|
