Code: Select all
<?php
$con = mysql_connect("localhost","root","pw");
mysql_select_db('db',$con);
if (!$con) {
die('Could not connect: ' . mysql_error());
}
$query = "SELECT id,file_name,file_size,file_type,file_desc,prod_sale_price,prod_name FROM products GROUP BY prod_name ORDER BY id DESC";
$result = mysql_query ($query) or die(mysql_error());
if (mysql_num_rows($result) == 0) {
echo "<p>There currently are no products listed on the website.</p>";
} else {
$rows = mysql_num_rows($result);
$array = mysql_fetch_array($result);
if($array) {
$prod_name = $array['prod_name'];
$file_name = $array['file_name'];
}
$counter = 1;
$cols = 3;
echo ("<table>\n");
for($i = 0; $i < $rows/$cols; $i++) {
echo ("<tr>");
for($j=0; $j < $cols && $counter <= $rows ;$j++, $counter++) {
?>
<td><p><h2><?php echo $prod_name; ?></h2>
<br />
<p><img style="width: 305px; height: 174px; float:left; margin-right: 10px; border: 1px dashed #CCC;" src="images/<?php echo $file_name; ?>" />
<div class="clear"></div>
<div style="float:left; " ><a href="#"><img src="images/read_more.png" width="305" height="54"></a></div>
</p>
</div></td>
<?php
echo ("</tr>\n");
}
echo ("</table>\n");
}}
?>