Re: [PHP-DB] A while loop prob ?

2002-02-14 Thread Jim Lucas [php]
Try this if ($submit) { if($search == "") { $error1 = "No Records found. Please use at least 1 character in search box"; } else { $srchsql = "select * from $tbn where name like \"%$search%\" "; $srchresult = mysql_query($srchsql, $con); $name =$srchrow[

Re: [PHP-DB] A while loop prob ?

2002-02-13 Thread William Fong
Heh, with the help from Mr. Emery, I see the/a part of the problem now. You have to fetch the results before you can extract the data into variables. After you do the query, you must run a/the mysql_fetch_array. HTH -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.

RE: [PHP-DB] A while loop prob ?

2002-02-13 Thread Rick Emery
Need to show us more code. For instance: where is $srchrow set? Next, change: if ($submit){ to: if (ISSET($submit)) { Why are you over-writing $name, $details, $price, $imgloc with list() before you even use them? -Original Message- From: Dave Carrera [mailto:[EMAIL PROTECTED]] Sent:

Re: [PHP-DB] A while loop prob ?

2002-02-13 Thread William Fong
You forgot the: - My Code Ends Here ... Jokes aside, and with some level of assumption, use: if ( isset($submit) ){ Your while() should be: while (list($name, $details, $price, $imgloc)==mysql_fetch_array($srchresult)){ = - is to set a variable == - is to compare