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@xxxxxxxxxxxxxxxxxxxx> wrote in message news:1229878234.4229.12.camel@xxxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxx> wrote in message > news:1229875150.4229.9.camel@xxxxxxxxxxxxxxxxxxxxxxxx > > 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@xxxxxxxxxxxxxxxxxxxx> wrote in message >>> news:1229873521.4229.6.camel@xxxxxxxxxxxxxxxxxxxxxxxx >>> > 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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
