you are missing the $ sign on your second mysql_query call

-----Original Message-----
From: Patrik Fomin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 4:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] 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

Reply via email to