RE: [PHP-DB] silly problem
| From: | Hutchins, Richard | Date: | Tue, 22 Jul 2003 19:34:50 +0000 |
| Subject: | RE: [PHP-DB] silly problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29408@lists.php.net to get a copy of this message | ||
Typo in your second query call. Should be:
mysql_query($sql);
Rich
> -----Original Message-----
> From: Patrik Fomin [mailto:pafo@pafo.net]
> Sent: Tuesday, July 22, 2003 4:41 PM
> To: php-db@lists.php.net
> 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
>