Display by ID number
Posted: Mon Jan 11, 2010 9:59 am
I have data that is uploaded from a custom built back-end inserted with id numbers auto-incremented. The code below will successfully show one entry but how can I get it to display all entries in order (by id number)?
Code: Select all
<div id="content">
<?php
mysql_connect("localhost", "user", "pw") or die(mysql_error()) ;
mysql_select_db("db") or die(mysql_error()) ;
?>
<div>
<h1>Print Ads<hr /></h1><br />
<?php
$data = mysql_query("SELECT * FROM printads") or die(mysql_error());
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['title2'] . "</b></td></tr> ";
Echo "<tr><td colspan='2' style='text-align:center;'><a href='upload/2010printads/".$info['image'] ."'><img src='upload/2010printads/".$info['thumb'] . "' style='text-align:center;'></a></td></tr>";
Echo "<tr><td style='vertical-align: middle; text-align:center;font-size:x-small;'>Color Illustrator Vector EPS</td><td><a href='upload/2010printads/".$info['eps1'] . "'><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;'>Color Press Quality PDF</td><td><a href='upload/2010printads/".$info['pdf1'] . "'><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;'>B&W Illustrator Vector EPS</td><td><a href='upload/2010printads/".$info['eps2'] . "'><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;'>B&W Press Quality PDF</td><td><a href='upload/2010printads/".$info['pdf2'] . "'><img src='../associates/images/download.png' border='0' width='75'></a><br></td></tr>";
Echo "</table>";
Echo "</div>";
}
?>
</div>
</div>
</div>