[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

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',

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, pse.. can you paste

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 empty or

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 =

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: [PHP-DB] empty query

2003-01-26 Thread janet
In a message dated 1/25/2003 10:24:34 PM Pacific Standard Time, [EMAIL PROTECTED] writes: i have unsuccessfully tried for three days to write, re-write something that will insert data into my db and ashamedly have failed again. at one point i was able to echo values and see that they were

Re: [PHP-DB] empty query

2003-01-26 Thread Addison Ellis
thank you so much for responding... i added this: { echo $key, $valuebr; } underneath function storeForm($formdata,$ads) and it is now displaying this: year, 1971 make, chevy model, impala color, green mileage, condition, none price, other, Ad may not exceed 25 words. contact, [EMAIL PROTECTED]

Re: [PHP-DB] empty query

2003-01-26 Thread Jason Wong
On Sunday 26 January 2003 16:14, Addison Ellis wrote: Please do not top-post. i added this: { echo $key, $valuebr; } underneath function storeForm($formdata,$ads) and it is now displaying this: year, 1971 make, chevy model, impala color, green mileage, condition, none price, other,

Re: [PHP-DB] empty query

2003-01-26 Thread Addison Ellis
first, i must apologize as i am very new at this... and... i really appreciate your help. addison On Sunday 26 January 2003 16:14, Addison Ellis wrote: Please do not top-post. Sorry here... i added this: { echo $key, $valuebr; } underneath function storeForm($formdata,$ads) and it is

Re: [PHP-DB] empty query

2003-01-26 Thread Jason Wong
On Sunday 26 January 2003 18:59, Addison Ellis wrote: correct... i am able to echo values again. Hmm, okay :-) i had the following to carry forward cat and subcat values: ? session_start(); if (@$auth != yes) { header(Location: login.php); exit(); }

Re: [PHP-DB] empty query

2003-01-26 Thread Addison Ellis
whew! is there a tutorial you know of that might help me? in essence i have page 1 select category, page two select subcategory, page 3 fill out the form, click submit, data is entered into database, user is directed to a new page. i thought from this php 4.1 book that i was doing that. :-) i

[PHP-DB] empty query

2003-01-25 Thread Addison Ellis
hello, i have unsuccessfully tried for three days to write, re-write something that will insert data into my db and ashamedly have failed again. at one point i was able to echo values and see that they were in fact passing from my form. now i can't even get that. anyway, if you could take a

Re: [PHP-DB] empty query

2003-01-25 Thread Jason Wong
On Sunday 26 January 2003 14:31, Addison Ellis wrote: hello, i have unsuccessfully tried for three days to write, re-write something that will insert data into my db and ashamedly have failed again. at one point i was able to echo values and see that they were in fact passing from my