...missing semicolon and some brackets.
<?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>";
}
?>
If there is more code you can show by perhaps pasting here:
http://pastebin.redlinktech.com
We can help with further syntax problems.
Anthony Gentile
On Sun, Dec 21, 2008 at 12:33 PM, Gary Maddock-Greene <
gmg@xxxxxxxxxxxxxxxxxxxx> wrote:
> 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
>
>
