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 <
> [email protected]> 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" <[email protected]> wrote in message
> > news:[email protected]...
> >
> > 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" <[email protected]> wrote in message
> >>> news:[email protected]...
> >>> > 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
