On Sun, 2008-12-21 at 16:22 +0000, Gary Maddock-Greene 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
> >
>
>
Just spotted that you've omitted the semicolon from the second echo
statement as well.
Ash
www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
