Try this 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>"; } echo $display_srch_rows; } }
the problem is, you were overwriting your results each time you went into the loop therefor always ending up with the last returned result set. if you use " .= " instead of " = " you will concat the results, therefor making one long string. then echo/print the $display_srch_rows variable. Jim Lucas ----- 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