Re: eof bof in php

"Gary Maddock-Greene" <gmg@xxxxxxxxxxxxxxxxxxxx> · Sun, 21 Dec 2008 20:17:32 -0000

I guess you are right about mixing php with html. Actually the suggestion 
you gave breaks my search function. If I now search for a product called 
'type 22'  the space and first digit 2 breaks the serach. Also the \" in the 
htnl / php is causing a break in the image path urls ... so back to the 
drawing board for me :)

--
- Gary Maddock-Greene
""Gary Maddock-Greene"" <gmg@xxxxxxxxxxxxxxxxxxxx> wrote in message 
news:B4.82.23981.DEE8E494@xxxxxxxxxxxxxxx
thanks for the advice re html and php mashup!! I will research to find the 
way to do it outside the php.

- Gary Maddock-Greene

""Anthony Gentile"" <asgentile@xxxxxxxxx> wrote in message 
news:2ce4207d0812211021g215d5346wb0afcedf039ef22d@xxxxxxxxxxxxxxxxx
<?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>";
while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){
    echo "<div class=\"productitem\"><img src=\"products\"".
$row_rsSearch['product_image']."
      <div class=\"text\">
        <h3>". $row_rsSearch['product_name']."</h3>
          <p class=\"style1\">". $row_rsSearch['product_subtitle'] ."
</p>
          <a href=\"products\"". $row_rsSearch['product_url']."View
Product</a>
        <div class=\"clear\"></div>
        </div> <div class=\"clear\"></div>
     <center>
        </center>
      </div>";
}

}
?>

is probably going to give you the result you want. However you should 
know
it is bad practice to mix PHP and HTML as horridly as I just showed you. 
AKA
you don't want your PHP writing your HTML.

Anthony Gentile

On Sun, Dec 21, 2008 at 1:07 PM, Gary Maddock-Greene <
gmg@xxxxxxxxxxxxxxxxxxxx> wrote:

I've corrected those errors thanks but how do I insert this code as the
else statement?

<?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
""Anthony Gentile"" <asgentile@xxxxxxxxx> wrote in message
news:2ce4207d0812210959k3491690ctbc4f0dbf971ac920@xxxxxxxxxxxxxxxxx

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

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php