Re: eof bof in php

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux