when i perform query an mysql db, to insert a new record, the PHP says: Warning: Supplied argument is not a valid MySQL result resource in g:\wwwroot\phpusermanager-1.0\add_order.php on line 24
the snippet is as follows <? // connect to the database $conn = mysql_connect ($db_host, $db_user, $db_passwd); // select database mysql_select_db ($db_used, $conn); // SQL statement $query = "INSERT into order (Ctr_no, OID, Person_in_charge, Source, Destination, Status) VALUES ('$container_num', '$order', '$referrer', '$source', '$dest', '$status')"; mysql_query ($query, $conn); mysql_close($conn); ?> why the argument isn't valid? how to solve this problem? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php