JeevesBond — Thu, 11 Jan 2007 10:56:40 +0000

This is a little difficult to answer without knowing how the database is setup. Are the lots held in one table with the status in another?

To query the database you probably want to do something like:

<?php
$conn = mysql_connect(\"host\",\"username\",\"password\");

if (!$conn) {
   die(\"Could not connect to DB. Error: \" . mysql_error();
}

$db = mysql_select_db(\"databasename\"); 

$query = \"SELECT lotname, statusname 
   FROM lot
   INNER JOIN status ON lot.statusid = status.statusid\"; 
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) { 
   echo '<img src=\"' . $row[\"lotname\"] . $row[\"lotstatus\"] . '.gif\" width=\"50\" height=\"50\" alt=\"' . $row[\"lotname\"] . ' is ' . $row[\"lotstatus\"] . '\" />';
}
?>

Note: the 'host' in mysql_connect is usually localhost.

I can't really test this so you might find some problems, it does also require you to fill-in a few details, such as: the host, username/password, table names in the SQL etc.

Hopefully this will give you a start.

cyr0n_k0r — Thu, 11 Jan 2007 01:39:52 +0000

No, I have very little database coding experience. I had planned on just having sperate images for each lot status.

I could figure out that its just simple if then's.. problem is, I don't know how to query the database to check the status.

I was thinking something like this. I know its not pretty or neat.. but I need to get this done tonight.

If status of lot 1 = open
then display lot1open.gif

elseif status of lot 1 = reserved
then display lot1reserved.gif

else status of lot 1 = sold
then display lot1sold.gif

Then just do that for EACH lot.

andy206uk — Thu, 11 Jan 2007 01:33:56 +0000

It should be a case of simple conditionals... Firstly, ensure that your image has a transparent background. Your basic markup (when the image is white) would look like this:

<img src="blah.gif" with="50" height="50" style="background-color: white;" >'

So... assuming that you already have the status from the database and you have a choice of three values, you simply do the following:

<?php
if($status == 'sold') { 

  $color = 'red'; 

} elseif($status == 'reserved') { 
  
  $color = 'gray'; 

} else { 

  $color = 'white'; 

}
?>

Then modify your markup for the image to:

<img src="blah.gif" with="50" height="50" style="background-color: <?= $color ?>;" >'

(obviously, this is all assuming that you are looping through the database to pull out each image)