Re: A while loop prob ?
| From: | Jim Lucas [php] | Date: | Thu, 14 Feb 2002 18:43:47 +0000 |
| Subject: | Re: A while loop prob ? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16955@lists.php.net to get a copy of this message | ||
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" <dave@davecarrera.com>
To: "php List" <php-db@lists.php.net>
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
>
>