Re: First record not diplaying
| From: | Ashley Sheridan | Date: | Mon, 22 Dec 2008 14:18:22 +0000 |
| Subject: | Re: First record not diplaying | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-284955@lists.php.net to get a copy of this message | ||
On Mon, 2008-12-22 at 14:02 +0000, Gary Maddock-Greene wrote:
> Hi, I seem to have a bug in my code but can't see why. My first record does
> not display when I run a search. Can anyone spot what I have done wrong?
> Thanks
>
> if (0 == $totalRows_rsSearch) {
> echo "<h3>Sorry no products were found</h3>";
> } else {
> echo "<h3>Please click on a product for further information.</h3>";
> while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){
> echo "<div class=\"productitem\"><img src=\"products".
> $row_rsSearch['product_image']."\">
>
> - Gary Maddock-Greene
>
>
You seem to be missing quite a lot of code from your example, namely the
ending quotation mark, ending semicolon, the ending brace to the while
loop, the closing </div> tag inside the loop...
Also (and I know the speed junkies will want to shoot me now!) you could
shorten the echo inside the while loop to:
echo "<div class=\"productitem\"><img src=
\"products{$row_rsSearch['product_image']}\">";
Ash
www.ashleysheridan.co.uk