err forgot the closing > in <img src=\"products\"".
should look like <img src=\"products\">".
Anthony Gentile
Cell: 704.657.8550
Diese E-Mail ist vertraulich. Wenn Sie nicht der rechtmaessige Empfaenger
sind, duerfen Sie den Inhalt weder kopieren noch verbreiten oder benutzen.
Sollten Sie diese E-Mail versehentlich erhalten haben, senden Sie diese
bitte an uns zurueck und loeschen Sie sie anschliessend.
This email is confidential. If you are not the intended recipient, you must
not copy, disclose or use its contents. If you have received it in error,
please inform us immediately by return email and delete the document.
On Sun, Dec 21, 2008 at 1:21 PM, Anthony Gentile <asgentile@xxxxxxxxx>wrote:
> <?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
>>
>>
>
