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

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. :

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
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, $value"; } underneath function storeForm($formdata,$ads) and it is n

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, $value"; > } > underneath function storeForm($formdata,$ads) and it is now displaying > this: year, 1971 > make, chevy > model, impala > color, green > mileage, > condition, none > price,

Re: [PHP-DB] empty query

2003-01-26 Thread Addison Ellis
thank you so much for responding... i added this: { echo "$key, $value"; } 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] nex

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-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 m