Skip to main content
S
sellador315
Inspiring
June 23, 2011
Answered

Display field differently depending on content. PHP MYSQL

  • June 23, 2011
  • 1 reply
  • 846 views

Hi all,

A little riddle that I am sure is easy but have no idea how to do;

I have a list of products in a table and one of the cells contains this <?php echo $row_rsLanterns['product_Stock']; ?>. product_Stock has is a set value of either inStock and OutOfStock. I would llike to be able to display something different for each thing. I.E if the field contains inStock I would like to print In Stock and if OutOfStock then it displays Out of Stock. And also changes the colour of each one.

Any ideas would be great.

Thank you

Tom

This topic has been closed for replies.
Correct answer

<?php if ($row_rsLanterns['product_Stock'] == "inStock") { ?>

in stock stuff here. Add html or whatever message you want to let people know that product is in stock.

<?php } ?>

<?php if ($row_rsLanterns['product_Stock'] == "OutOfStock") { ?>

out of stock stuff here

<?php } ?>

1 reply

A
Anonymous
Correct answer
June 23, 2011

<?php if ($row_rsLanterns['product_Stock'] == "inStock") { ?>

in stock stuff here. Add html or whatever message you want to let people know that product is in stock.

<?php } ?>

<?php if ($row_rsLanterns['product_Stock'] == "OutOfStock") { ?>

out of stock stuff here

<?php } ?>

S
sellador315Author
Inspiring
June 23, 2011

Excellent, I haven't tried it out but that looks like it'll work fine.

Thanks so much.

Tom

A
Anonymous
June 24, 2011

Hi Tom,

Assuming table column for product_Stock can not be null and has a value of either inStock or OutOfStock you could optimize the script with an else statement instead.

If row value equals inStock then show inStock content. Else, meaning anything other than the row equaling inStock, which in this case would mean the row is theoretically OutOfStock by means of process of elimination, show the OutOfStock content. See example:

<?php if ($row_rsLanterns['product_Stock'] == "inStock") { ?>

In stock stuff here

<?php } else { ?>

Out of stock stuff here

<?php } ?>

best,

Shocker

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices