Code: Select all
<?php
$link = mysql_connect($DBHost, $DBUser, $DBPass);
mysql_select_db($DBName) or die("Could not connect!" . mysql_error());
$sql = "SELECT * FROM images WHERE tag = '0'";
$result = mysql_query($sql) or die("Error!");
while ($row = mysql_fetch_array($result))
{
if ($row == false) break;
$images[] = $row['image'];
}
for($x = 0, $y = count($images); $x < $y; $x++)
{
if($x % 6 == 0)
echo '<tr>';
echo '<td><A href="viewtopic.php?ID='.$images[$x].'"><img src="'.$images[$x].'" border=0 /></A></td> ';
if($x % 6 == 5)
echo '</tr>';
}
$y = ($y + 5) % 6;
if($y != 5)
echo '<td colspan=".($y+1)."> </td></tr>';
$sql = "SELECT * FROM images WHERE tag = '1' AND name = 'Contact'";
$result = mysql_query($sql) or die("Error!");
$row = mysql_fetch_assoc($result);
$image = $row['image'];
echo '<tr>';
echo '<td><A href="contact.php"><img src="'.$image.'" border=0 /></A></td> ';
echo '</tr>';
mysql_close($link);
?>Joe