[SOLVED] display a div only if a value in database is equal to 1

[jbrill]

Hey guys,

Im trying to get a div to to only display if the the row in the database called "stock" is equal  to "1"

if it is equal to "0

" then do not display the specific div.

 

Here is the code:

 

<?php
$query = "SELECT * FROM products WHERE cat = '" . $curcat . "'" . $sSubCatAndClause . " AND publish = 1 AND featured = 0";
$rs = mysql_query($query);

while($row2 = mysql_fetch_array($rs))
{

echo "<div id=\"product\">";

//below is the div/image i want to appear only if out of stock is equal to 1
echo "<div style=\"outofstock\"><img src=\"images/featured.png\"></div>";

echo "<div id=\"producttext\">";
echo 'text will go here';
echo "</div>";
echo "</div>";

	}
?>

 

Thanks in Advance!

[lemmin]

if ($row2['stock'] == 1)
    echo "<div style=\"outofstock\"><img src=\"images/featured.png\"></div>";

 

Is that what you mean?

[jbrill]

thank you for the quick response! it worked great!