Re: [PHP-DB] Empty query result

2004-07-26 Thread Philip Thompson
Thanks all! I will try some of the suggestions that you guys gave. I appreciate it. ~Philip On Jul 26, 2004, at 12:52 PM, Pablo M. Rivas wrote: Hello Philip, read: http://www.php.net/manual/en/function.mysql-result.php when you do $queryResult = mysql_result($queryResult,0) you

Re[2]: [PHP-DB] Empty query result

2004-07-26 Thread Pablo M. Rivas
Hello Philip, read: http://www.php.net/manual/en/function.mysql-result.php when you do $queryResult = mysql_result($queryResult,0) you get the error... so, you can do something like this: function getMysqlSelectResultForUsername($identifier, $userName, $link) {

Re: [PHP-DB] Empty query result

2004-07-26 Thread Jason Wong
On Tuesday 27 July 2004 00:57, Philip Thompson wrote: > Here's my function: > > function getMysqlSelectResultForUsername($identifier, $userName, $link) > { > $queryResult = mysql_query("select $identifier from theTable where > username = '$userName'", $link); > > if (!($queryResult = mys

Re: [PHP-DB] Empty query result

2004-07-26 Thread Pablo M. Rivas
Hello Philip, pse.. can you paste the error information? There is no known "empty set" problem. -- Best regards, Pablo PT> Hi all. PT> I am querying a database of single information multiple times using a PT> simple 'select' statement. However, whenever the data in the DB is PT> empt

Re: [PHP-DB] Empty query result

2004-07-26 Thread bbonkosk
Why not...?? if (!($queryResult = mysql_result($queryResult, 0))) { return 0; } - Original Message - From: Philip Thompson <[EMAIL PROTECTED]> Date: Monday, July 26, 2004 12:57 pm Subject: Re: [PHP-DB] Empty query result > Pablo, > > > Hello Philip, > &g

Re: [PHP-DB] Empty query result

2004-07-26 Thread Philip Thompson
Pablo, Hello Philip, pse.. can you paste the error information? There is no known "empty set" problem. Here's my function: function getMysqlSelectResultForUsername($identifier, $userName, $link) { $queryResult = mysql_query("select $identifier from theTable where username = '$userName'

[PHP-DB] Empty query result

2004-07-26 Thread Philip Thompson
Hi all. I am querying a database of single information multiple times using a simple 'select' statement. However, whenever the data in the DB is empty or is 0 (zero), then it throws an error. However, I don't want it to throw an error, I just want it to move on to the next query. This is being