Re: eof bof in php

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@ashleysheridan.co.uk> wrote in message news:1229875150.4229.9.camel@localhost.localdomain... > 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@ashleysheridan.co.uk> wrote in message >> news:1229873521.4229.6.camel@localhost.localdomain... >> > 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 >