Re: About Buggy SQL Query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



What is in $SD?

And are you using mysql_real_escape_string on all values?

On Mon, August 13, 2007 11:31 pm, Kelvin Park wrote:
> 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?
>


-- 
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux