I keep getting Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in lines 17 and 21, they are marked below. I am drawing a blank, starting to doze off also :S, thunderbird has crappy default composition widths(anyone know how to change it?), so the formatting my be awry.
You don't have an error checking to test the result from mysql_query() to make sure that it succeeded.
Adding a test on the value of $result might prove instructive.
$sun_5a_n1 = "1"; $sun_5a_t1 = "2";
if($sun_5a_n1) {
$result = mysql_query("UPDATE sunday SET a5_n_1='$sun_5a_n1',a5_t_1='$sun_5a_t1'")
while($row = mysql_fetch_array($result)) {
(line 17)echo "Sunday @ 5am slot modified to Name: $sun_5a_n1, Time: $sun_5a_t1<br>";
break;
}
mysql_free_result($result);
(line 21)}
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
