I'm assuming that you already have it setup to display all the rows from your table using:
Code: Select all
while($rowdata = mysql_fetch_array($query)) { //do stuff }Code: Select all
$query = mysql_query("SELECT product, new, price FROM tbl_name")
Now, in the while loop you have to tell it to do something extra if $rowdata['new'] == yes. That something extra could be:
Code: Select all
echo "<img src='new.jpg' />";Play around with it, make some mistakes, learn.