|
|
Posted by ste on 04/29/06 04:12
Hi there,
I'm trying to query a MySQL database (containing image data) and to output
the results in a HTML table of 3 columns wide (and however many rows it
takes) in order to create a basic thumbnail gallery.
I can query and output the data as a single column table, but I'm having
problems filling up a 3 column table (with different images, looping
continuously until the end).
I would appreciate it if someone could take a look at the code below and
point me in the right direction or suggest any extra lines of code which
would finish the job?
The code below puts an image on each row, instead of filling up 3 columns on
each row with a different image.
I open this gallery by going to
mywebsite.com/gallery.php?imagetype=landscape (i.e. to access the landscape
gallery).
Thank you for any help,
Ste
<?php
include("my_db_login.inc");
$connection = mysql_connect($host,$user,$password) or die ("couldn't connect
to server");
$db = mysql_select_db($database,$connection) or die ("Couldn't select
database");
$title = "Gallery";
$query = "SELECT * FROM mydatabase WHERE imagetype =
\"{$_GET['imagetype']}\"";
$result = mysql_query($query) or die ("Couldn't execute query.");
echo "<h2>$title</h2>";
echo "<table>";
echo "<tbody>";
while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<tr>";
echo "<td><img src=\"$imagelocation\" />\n
</td>\n";
}
echo "</tr>";
echo "</table>\n";
?>
Navigation:
[Reply to this message]
|