Re: problem with mysql_query
| From: | Markus Lervik | Date: | Mon, 10 Jun 2002 10:44:51 +0000 |
| Subject: | Re: problem with mysql_query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19709@lists.php.net to get a copy of this message | ||
On Monday 10 Jun 2002 12:14 pm, Rene Schoenmakers wrote:
> Hi,
>
> I've a problem with the following script. Sometimes it does write the
> data into the database, sometimes it doesn't. When it doesn't $result is
> completely blank, otherwise it is 1. $sql always returns the propper
> values even though $result is blank. Can anybody tell me what I'm doing
> wrong?
> $result = mysql_query($sql);
Try changing this to (for example)
if(!$result = mysql_query($sql)) {
echo "MySQL error " . mysql_errno() . " - " . mysql_error();
die();
}
and see what you get. There's probably some problem with the database
connection.
Cheers,
Markus
--
Markus Lervik
Linux-administrator
Vaasa City Library - Regional Library, Finland
markus.lervik@vaasa.fi
+358-6-325 3589/+358-40-832 6709