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
>
>
