Re: [PHP] About Buggy SQL Query

2007-08-15 Thread Chris
Kelvin Park wrote: Chris wrote: 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

Re: [PHP] About Buggy SQL Query

2007-08-15 Thread Kelvin Park
Chris wrote: 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 = $whatev

Re: [PHP] About Buggy SQL Query

2007-08-14 Thread Richard Lynch
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 inf

Re: [PHP] About Buggy SQL Query

2007-08-14 Thread Kelvin Park
Chris wrote: 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 = $whatev

Re: [PHP] About Buggy SQL Query

2007-08-13 Thread Chris
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;

[PHP] About Buggy SQL Query

2007-08-13 Thread Kelvin Park
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 s