A while loop prob ?
| From: | Dave Carrera | Date: | Wed, 13 Feb 2002 19:40:05 +0000 |
| Subject: | A while loop prob ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16920@lists.php.net to get a copy of this message | ||
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