THIS THREAD HAS BEEN UPDATED. SCRIPT HAS JUST BEEN CHANGED
Im trying to print several image url's and names from an sql database into 3 columns,
Aiming to get it to go
1,2,3
4,5,6
7,8,9
etc etc. but for some reason myne is going
1,2,3
3,4,6
6
Code:
<?php
include 'config.php';
mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());
$result = mysql_query("SELECT * FROM tracks ORDER BY id ASC");
$num = mysql_num_rows($result);
$arr = array();
while($row = mysql_fetch_array($result)) {
$arr[$row['id']] = $row;
}
echo '<div id="left_wrapper">';
for($i=1; $i<$num; $i+=2) {
$row = $arr[$i];
$id = $row['id'] + 1;
echo "<img src='Thumbnails/" . $id .".gif'></img><br />";
echo $row['name']. "<br />";
}
echo "</div>";
echo '<div id="middle_wrapper">';
for ($i=2; $i<$num; $i+=2) {
$row = $arr[$i];
$id = $row['id'] + 1;
echo "<img src='Thumbnails/" . $id .".gif'></img><br />";
echo $row['name']. "<br />";
}
echo "</div>";
echo '<div id="right_wrapper">';
for ($i=3; $i<$num; $i+=2) {
$row = $arr[$i];
$id = $row['id'] + 1;
echo "<img src='Thumbnails/" . $id .".gif'></img><br />";
echo $row['name']. "<br />";
}
echo "</div>";
?>
I NEED HALP