Re: eof bof in php

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

 



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