Making a thumbnail table from MySQL query

[Hobgoblin]

Hi.

I have a small project I'm working on where I need to have a table 3 colums wide with a thumbnail and the name in each cell.

I can get this done with only one cell per <tr>, but this wastes a lot of page space. I've spent quite a bit of time figuring out loops, but nothing I've found seems to work properly.

As I have it right now, only the first record in the DB is showing up 44 times (which is the amount of total records).

Here's the script I'm using as of right now:

$sql = "SELECT * FROM stats ORDER by name DESC";

$sql_result = mysql_query($sql,$connection);

while ($row = mysql_fetch_array($sql_result)) {

$name  = $row["name"];
    $tn = row["tn"];
}

echo "<table>";

for ($x= 0; $x < mysql_num_rows($sql_result); $x++) {

$row = mysql_fetch_assoc($sql_result);

echo "\n\t<tr>";
echo "\n\t\t<td><img src=\"thumbs/{$tn}.jpg\"><br />$name</td>";
echo \n\t</tr>";

}

echo "</table>";

[bad76]

Hi,

you do this:

$sql = "SELECT * FROM stats ORDER by name DESC"; 
$sql_result = mysql_query($sql,$connection); // right, you make query.

while ($row = mysql_fetch_array($sql_result)) { // while there is
  $name=$row["name"];   // any value assign it
  $tn = row["tn"];            //to a variable.
} // at the end $name is the name in last row

echo "<table>"; 

for ($x= 0; $x < mysql_num_rows($sql_result); $x++) { //for 44 time

$row = mysql_fetch_assoc($sql_result); //read next row

echo "\n\t<tr>"; 
echo "\n\t\t<td><img src=\"thumbs/{$tn}.jpg\"><br />$name</td>";  // write $name -> that is always the same...
echo nt</tr>"; 

} 

echo "</table>";

You can repair deleting first loop. Use the while instead of for and write $row["name"] and $row["nt"] instead $name & $nt in loop...

see you

[Hobgoblin]

Thanks - Problem one is sorted out, but now I still need to know how to get three table cells per row.. 🙂

THanks!

[DeltaRho2K]

I think I have seen this on the boards before, and if I remember correctly, you have to do your query as usual.

Then do a quick little calculation to determine how many rows are needed for the 3 columns...

In this case, the 44 records would require 15 rows--- mysql_num_rows/#columns needed (or 44/3)

Then you would need to do 3 separate loops with the appropriate results, basing each starting record on the applicable value.

1st column would be 1-15
2nd column would be 16-30
3rd column would be 31-44

The query(s) get hairy if you want horizontal sorting, but I am pretty sure it could be done too...

Try searching the forum for thumbnail...

[Hobgoblin]

I almost got it from another thread I found on this board, but something odd is happening -- it's displaying three thumbnails on the first row, then just one on the next, then 3, then one, and so on...

I'm thinking one of the $i = 0; commands is inside the wrong set of braces. I've tried moving them around, but I haven't got any good results - some put the first three on the first row, then the rest on the second, and sometimes, each gets its own row.

I know this can be done without having to calcuate the total records (which would be a hassle because the amount of records updates quite often).

If anyone sees something in the wrong place.. please let me know- I'm close!

<?
echo "<table border=\"0\" cellpadding=\"10\" class=\"thumb\">\n";

$sql = "SELECT * FROM stats ORDER by name ASC";

$sql_result = mysql_query($sql,$connection)


if (mysql_num_rows($sql_result) > 0) {
$i = 0; 

while ($row = mysql_fetch_array($sql_result, 1)) {

if ($i == 0) {
  	echo "\n\t<tr>";
}

$i++;

if ($i == 4) {
	echo "\n\t</tr>"; 
	$i = 0;
}

echo "\n\t\t<td align=\"center\" valign=\"top\"><a href=\"models.php?query=portfolio&model=".$row["webname"]."\"><img src=\"models/thumbs/".$row["webname"].".jpg\" border=\"0\"/></a><br /><b><a href=\"models.php?query=portfolio&model=".$row["webname"]."\">".$row["name"]."</b></a><br />";

if($row["status"] == "U") {
	echo "<font color=\"#FF0000\"><b>Updated!</b></font>";
}

elseif($row["status"] == "N") {
	echo "<font color=\"#FF0000\"><b>New Model!</b></font>";
}

else {
	echo "";
}

echo "</td>";

}
$i++;
}

echo "\n</table>\n";

?>