Another question, displaying data correctly

fuzic

I am constructing a database driven gallery for my site, and it pulls the image location and name for each image out of a database. I need it to place the name of each image under the thumbnail, and I tried using a table for each image with two rows (one for the image and one for the name) but apparently tables cant be placed side by side. Is there a way to make the php script produce only one table, and put 4 pictures per row, and determine the number of rows by dividing the total number of rows in the mysql table by 4 and rounding?

Tell me if any of that was unclear...

The current code I'm using is as follows;

$query = "SELECT FROM photographs ORDER BY number DESC";
$result = mysql_query($query);
$num = mysql_numrows($result);
$query2 = "SELECT FROM photographs LIMIT $val2, $val";
$result2 = mysql_query($query2);
$num2 = mysql_numrows($result2);
$i=0;
$totpage=round(($num/16)+0.5);
$curpage=round(($val/16)+.05);
while ($i < $num2) {
$location=mysql_fetch_assoc($result2);
$header=mysql_result($result2,$i,"header");
?>
<table cellpadding=2 border=o cellspacing=0><tr><td><img src=images/<?php
echo $location["location"];
?>></td></tr><tr><td><a class="general"><div align="center"><?php echo
$header; ?></div></a></td></tr></table> <?php
++$i;
}
?>

mystrymaster

use counts and that should give you a start - count the total number of records - try from there

AstroTeg

You have your first query with an "ORDER BY number DESC". If I'm looking at it correctly, you're using the first query to just get the total number of photos and thats it, right? If so, I'd drop the ORDER BY - you'll gain a little bit of performance since you're not asking your database to do some sorting that you won't take advantage of (maybe put the ORDER BY in your 2nd query).

As for the 1 table trick, yes, I'd recommend 1 table with 4 columns (or how ever many you decide).

There's a couple different ways to solve this problem.

You could put in a for() loop in the while loop. In the while loop and before the for() loop you create your row and after your for() loop you end your row. In the guts of the for() you put in the HTML/PHP to generate 1 photo. I don't highly recommend this approach because you have to manage what happens when you run out of records from your query.

You can do the above trick with a counter. If counter is 0, then dump out the start of the row. When its 4, dump out the end of the row and reset the counter.

If you're uber-smooth, you might try using the modulus operator '%'. This would eliminate the need to reset the counter.