RE: [PHP-DB] A while loop prob ?
| From: | Rick Emery | Date: | Wed, 13 Feb 2002 19:53:57 +0000 |
| Subject: | RE: [PHP-DB] A while loop prob ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16923@lists.php.net to get a copy of this message | ||
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:dave@davecarrera.com]
Sent: Wednesday, February 13, 2002 1:40 PM
To: php List
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