Re: eof bof in php

On Sun, 2008-12-21 at 11:39 -0500, Anthony Gentile wrote: > if (0 == $totalRows_rsSearch) { > echo "Sorry no products were found"; > } else > > Anthony Gentile > > > > On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene < > gmg@maddock-greene.co.uk> wrote: > > > I have tried that but to no avail :) > > > > <?php > > if ($totalRows_rsSearch=0) > > echo "Sorry no products were found"; > > else > > > > > > // All seems OK to here, then the syntax error unexpected T_VARIABLE > > appears > > > > > > echo <h3>Please click on a product for further information.</h3> > > > > <?php do { ?> > > <div class="productitem"><img src="products<?php echo > > $row_rsSearch['product_image']; ?>" /> > > <div class="text"> > > <h3><?php echo $row_rsSearch['product_name']; ?></h3> > > <p class="style1"><?php echo > > $row_rsSearch['product_subtitle']; > > ?></p> > > <a href="products<?php echo $row_rsSearch['product_url']; > > ?>">View Product</a> > > <div class="clear"></div> > > </div> <div class="clear"></div> > > <center> > > </center> > > </div> > > <?php } while ($row_rsSearch = mysql_fetch_assoc($rsSearch)); ?> > > > > -- > > - Gary Maddock-Greene > > "Ashley Sheridan" <ash@ashleysheridan.co.uk> wrote in message > > news:1229875150.4229.9.camel@localhost.localdomain... > > > > On Sun, 2008-12-21 at 15:40 +0000, Gary Maddock-Greene wrote: > >> > >>> Thanks Ashley ... I have been trying that but I think my syntax id shot!! > >>> > >>> <?php > >>> if ($totalRows_rsSearch="0") > >>> echo "Sorry no products were found"; > >>> else > >>> echo "<h3>Please click on a product for further > >>> information.</h3>" > >>> ?> > >>> <!-- Product block start search results --> > >>> <?php do { ?> > >>> <div class="productitem"><img src="products<?php > >>> echo > >>> $row_rsSearch['product_image']; ?>" /> > >>> <div class="text"> > >>> <h3><?php echo $row_rsSearch['product_name']; > >>> ?></h3> > >>> <p class="style1"><?php echo > >>> $row_rsSearch['product_subtitle']; > >>> ?></p> > >>> <a href="products<?php echo > >>> $row_rsSearch['product_url']; > >>> ?>">View Product</a> > >>> <div class="clear"></div> > >>> </div> <div class="clear"></div> > >>> <center> > >>> </center> > >>> </div> > >>> <?php } while ($row_rsSearch = mysql_fetch_assoc($rsSearch)); ?> > >>> > >>> -- > >>> - Gary Maddock-Greene > >>> "Ashley Sheridan" <ash@ashleysheridan.co.uk> wrote in message > >>> > >>> news:1229873521.4229.6.camel@localhost.localdomain... > >>> > On Sun, 2008-12-21 at 15:22 +0000, Gary Maddock-Greene wrote: > >>> >> Hi, I'm very new to php. Please can someone point me in the right > >>> >> direction? > >>> >> I want to display a message: 'No Products Found' if my search > >>> >> record > >>> >> set > >>> >> returns no value. > >>> >> > >>> >> I think I need to be looking at this section of my code ... > >>> >> > >>> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE product_name > >>> >> LIKE > >>> >> %s", GetSQLValueString("%" . $colname_rsSearch . > >>> >> "%", "text")); > >>> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or > >>> >> die(mysql_error()); > >>> >> $row_rsSearch = mysql_fetch_assoc($rsSearch); > >>> >> $totalRows_rsSearch = mysql_num_rows($rsSearch); > >>> >> ?> > >>> >> > >>> >> Thanks > >>> >> > >>> >> - Gary Maddock-Greene > >>> >> > >>> >> > >>> > Can you not just use the $totalRows_rsSearch value inside of an if > >>> > statement? > >>> > > >>> > > >>> > Ash > >>> > www.ashleysheridan.co.uk > >>> > > >>> > >>> > >>> It might be because you're comparing the total to a string rather than a > >> number if ($totalRows_rsSearch="0") > >> > >> If you remove the quote marks, it should work. > >> > >> > >> Ash > >> www.ashleysheridan.co.uk > >> > >> > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > D'oh, not sure how I missed that one too, the double ==. No wonder it wasn't working. Ash www.ashleysheridan.co.uk