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 two things
Not sure why you are hitting the Error. Maybe its my inexperience.
HTH
-w
--
William Fong - [EMAIL PROTECTED]
Phone: 626.968.6424 x210 | Fax: 626.968.6877
Wireless #: 805.490.7732 | Wireless E-mail: [EMAIL PROTECTED]
----- Original Message -----
From: "Dave Carrera" <[EMAIL PROTECTED]>
To: "php List" <[EMAIL PROTECTED]>
Sent: Wednesday, February 13, 2002 11:40 AM
Subject: [PHP-DB] A while loop prob ?
: Hi All
:
: What have I done wrong here.
:
: 3 yes 3 hours I have been plaing with this loop.
:
: All it shows is the last record in my db.
:
: It should show and record containing any string in the search.
:
: Error works
:
: Please help I beg you.......
:
: As always thank you for any help
:
: Dave C
:
: --------- My Code Starts Here ------------
:
: if ($submit){
: if($search == ""){
: $error1 = "<font color=red>No Records found. Please use at least
: 1 character in search box</font>";
: }
: else
: {
: $srchsql = "select * from $tbn where name like \"%$search%\" ";
: $srchresult = mysql_query($srchsql, $con);
: $name =$srchrow['name'];
: $details =$srchrow['details'];
: $price =$srchrow['price'];
: $imgloc =$srchrow['imgloc'];
: while (list($name, $details, $price, $imgloc)
: =mysql_fetch_array($srchresult)){
:
: $display_srch_rows =
: "<tr><td>$imgloc</td><td>$name</td><td>$details</td><td>$price</td></tr>
: ";
: }
: }
: }
:
: Dave Carrera
: Website Designer
: http://www.davecarrera.com
:
:
:
:
: --
: PHP Database Mailing List (http://www.php.net/)
: To unsubscribe, visit: http://www.php.net/unsub.php
:
:
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
