About Buggy SQL Query
| From: | Kelvin Park | Date: | Tue, 14 Aug 2007 04:31:39 +0000 |
| Subject: | About Buggy SQL Query | ||
| Groups: | php.general php.general | ||
| Request: | Send a blank email to php-general+get-260799@lists.php.net to get a copy of this message | ||
mySQL database becomes inaccessible after a buggy sql string gets queried.
The SQL server runs fine, however it seems like just the database is being
looped infinitely so to say.
Here is an example:
(PHP)
$sql = "SELECT * FROM DB_TABLE WHERE PR_NUMBER = $whatever, DFLJJ =
$SD;LOOE"; (<-- invalid sql query string)
mysql_query($sql);
When this query string is queried during the (webpage) loading process, the
webpage just gets timed out without any error nor warning messages.
Does anyone know if there is a certain way to prevent mysql database from
stalling due to buggy sql strings?