Code Help

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
daebat
Forum Commoner
Posts: 47
Joined: Mon May 11, 2009 10:16 am

Code Help

Post 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.
User avatar
AbraCadaver
DevNet Master
Posts: 2572
Joined: Mon Feb 24, 2003 10:12 am
Location: The Republic of Texas
Contact:

Re: Code Help

Post 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>";
}
mysql_function(): WARNING: This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQLextension should be used. See also MySQL: choosing an API guide and related FAQ for more information.
daebat
Forum Commoner
Posts: 47
Joined: Mon May 11, 2009 10:16 am

Re: Code Help

Post 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
Post Reply