Try replacing the following line... @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this query doesn't work!!!!
With... $query = "UPDATE d SET h='$h' WERE id='$id'"; $queryr = mysql_query($query) or die("The sql statement does not execute"); if(mysql_affected_rows() !== 1) { die("The sql statement is successfully run however either h did not change or there is an internal error. Try executing the sql from the command line to make sure it otherwise works."); } and see which is coming back. Larry S. Brown Dimension Networks, Inc. (727) 723-8388 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php