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
