yeah ofcourse, sometimes u can go blind stairing at the code and still not see it :D thanks "Edward Peloke" <epeloke@echoman.com> skrev i meddelandet NFBBIIKNALMFFNANEKEFAEPPEGAA.epeloke@echoman.com">news:NFBBIIKNALMFFNANEKEFAEPPEGAA.epeloke@echoman.com... > you are missing the $ sign on your second mysql_query call > > -----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
