Re: First record not diplaying

Ash ... this is the full code block ... I am really new to php so I appreciate your tip <?php // Good to go 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']."\">

      <div class=\"text\">
        <h3>". $row_rsSearch['product_name']."</h3>
          <p class=\"style1\">". $row_rsSearch['product_subtitle'] ."

</p>

          <a href=\"products". $row_rsSearch['product_url']."\">View

Product</a>

        <div class=\"clear\"></div>
        </div> <div class=\"clear\"></div>
     <center>
        </center>
      </div>";

} } ?> -- - Gary Maddock-Greene "Ashley Sheridan" <ash@ashleysheridan.co.uk> wrote in message news:1229955502.3530.3.camel@localhost.localdomain... > 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 >