Re: eof bof in php

Thanks guys .. I can get this part working great .. <?php if (0 == $totalRows_rsSearch) { echo "<h3>Sorry no products were found</h3>"; } else echo "<h3>Please click on a product for further information.</h3>" ?> But I want to add the following so that only the products table appears when product are present. I cannot seem to add this code into the above after the echo "<h3>Please click on a product for further information.</h3>". I can't get the syntax right ... I appreciate everyones help -- - Gary Maddock-Greene "Ashley Sheridan" <ash@ashleysheridan.co.uk> wrote in message news:1229878234.4229.12.camel@localhost.localdomain... > 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 >