Code Help
Posted: Tue Jan 12, 2010 12:32 pm
Here is the original file:
I need for this specific line to only show up if the database field is set to '1' (default is '0'):
Thank you in advance.
Code: Select all
<?php
$data = mysql_query("SELECT * FROM postcards ORDER BY id DESC ") or die(mysql_error());
//Puts it into an array
while($info = mysql_fetch_array( $data ))
{
//Outputs the image and other data
Echo "<div style='float:left;'>";
Echo "<table width='225'>";
Echo "<tr><td colspan='2' style='text-align:center;text-transform:uppercase;'><b> ".$info['title'] . "</b></td></tr> ";
Echo "<tr><td colspan='2' style='text-align:center;'><b> ".$info['description'] . "</b></td></tr> ";
Echo "<tr><td colspan='2' style='text-align:center;'><a href='upload/postcards/".$info['image'] ."'><img src='upload/postcards/".$info['thumb'] . "' style='text-align:center;'></a></td></tr>";
Echo "<tr><td style='vertical-align: middle; text-align:center;font-size:x-small;'>Order Now</td><td><a href='upload/postcards/".$info['order'] . "'><img src='../associates/images/download.png' border='0' width='75'></a><br></td></tr>";
Echo "<tr><td style='vertical-align: middle; text-align:center;font-size:x-small;'>ZIP</td><td><a href='upload/postcards/".$info['zip'] . "'><img src='../associates/images/download.png' border='0' width='75'></a><br></td></tr>";
Echo "<tr><td style='vertical-align: middle; text-align:center;font-size:x-small;'>SIT</td><td><a href='upload/postcards/".$info['sit'] . "'><img src='../associates/images/download.png' border='0' width='75'></a><br></td></tr>";
Echo "<tr><td style='vertical-align: middle; text-align:center;font-size:x-small;'>PDF</td><td><a href='upload/postcards/".$info['pdf'] . "'><img src='../associates/images/download.png' border='0' width='75'></a><br></td></tr>";
Echo "</table>";
Echo "</div>";
}
?>Code: Select all
Echo "<tr><td style='vertical-align: middle; text-align:center;font-size:x-small;'>Order Now</td><td><a href='upload/postcards/".$info['order'] . "'><img src='../associates/images/download.png' border='0' width='75'></a><br></td></tr>";