Because you forgot a $ before $sql in the second? Regards, Matthew Moldvan System Administrator Trilogy International, Inc. -----Original Message----- From: Patrik Fomin [mailto:pafo@pafo.net] Sent: Tuesday, July 22, 2003 4:41 PM To: php-db@lists.php.net Subject: silly problem $sql = "UPDATE dagensfraga SET nej = '$nej' WHERE id = '$iid' AND aktuellfraga = '1'"; mysql_query($sql); $sql = "INSERT INTO dagensfragaip (aid, ip) VALUES('$iid', '$REMOTE_ADDR')"; mysql_query(sql); when i run this only the first line is recorded into the databse?, when i run the second line in a mysql_prompt it adds just fine, so why dosent it add when the script runs? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
