PHPBuilder - Display mysql restult as table

RSS Twitter

Display mysql restult as table

by: Tom Smith -- html, php, mysql, linux
May 7, 2002

Version: 1.0

Type: Full Script

Category: HTML

License: GNU General Public License

Description: Problem: Take a row from a table of images and display thumbnails x number across. Just change the value of $tds to change how many it shows across the row.

# make db connection 
$db = mysql_connect(localhost, user, pass);
mysql_select_db("database", $db);

# select whatever you want after the id and img fields
$sql = "select id, img from art ";
$res = mysql_query($sql, $db);

# count total rows
$tot = mysql_num_rows($res);

# change this to change how many tds are displayed before row ends
$tds = 4;

echo "<table border=1 width=100%>";
echo "<tr>";
for ($i = 1; $i <= $tot; $i++) {
	$row = mysql_fetch_row($res);
	$id = $row[0];
	$img = "<td align=center><a href=source/index.php?id=$id><img src=preview/$row[1]><br> $i / $tot</a></td>\n";
	echo "$img";
	if ($i % $tds == '0' && $i < $tot) {
		echo "</tr>\n<tr>\n";
echo "</tr></table>";

Comment and Contribute

Your comment has been submitted and is pending approval.

Tom Smith -- html, php, mysql, linux



(Maximum characters: 1200). You have characters left.