Page 1 of 1

Code Help

Posted: Tue Jan 12, 2010 12:32 pm
by daebat
Here is the original file:

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>";
 
 
}
?>
I need for this specific line to only show up if the database field is set to '1' (default is '0'):

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>";
Thank you in advance.

Re: Code Help

Posted: Tue Jan 12, 2010 12:37 pm
by AbraCadaver
You didn't say which field, and this is very basic. Have you read up on PHP or programming?

Code: Select all

if($info['whatever'] == 1) {
    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>";
}

Re: Code Help

Posted: Tue Jan 12, 2010 1:38 pm
by daebat
Thanks. Sorry I'm really new to php and in a hurry to finish this project. I understand the logic just don't know the code specifics. Hopefully someday I'll be able to give back by answering some questions on this forum :D