PHP Forum

**digitalfusion** · 11-03-2007, 07:40 AM

Hi,

I'm creating a script which allows users to login and view and manage online gallery's of photos for storage etc... but i need to know how to display the results of the gallery image query in a table of 3 coloumns by however many rows how is it possible to do that so it knows how many rows to put in and where it needs to start a new row.

i was thinking along the lines of mysql_num_rows to get the number of records there is in the database under the galleryid and then divide it by three to get the number of rows required but how would i translate the number of rows to get it to display this.

Regards,
Martin

**maxxximus** · 11-03-2007, 09:28 AM

You really need to steer clear of using tables if possible.
I would display it as a unordered list <ul> and use css to style it similar to a table.

Below is a rough and ready bit of code that will display your photos as a 3 column grid 650px wide and will display as many photos as the recordset contains using the do while loop. Adjust to your own needs.

Code:

// establish a connection 
// query your database

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style type="text/css">
ul {
list-style:none;
width: 650px;
}

li{float:left;
border:1px solid black;
}

li img {
width:180px;
height:135px;
padding:10px;

}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body><ul><?php do {?>

<li><img src="<?php echo $row['imageURL'] ;

?>" /></li>

<?php }
while($row = mysql_fetch_assoc($result));?></ul>
</body>

</html>
<?php
mysql_free_result($result);
?>

**digitalfusion** · 11-04-2007, 07:22 PM

Quote:

Originally Posted by maxxximus

You really need to steer clear of using tables if possible.
I would display it as a unordered list <ul> and use css to style it similar to a table.

Below is a rough and ready bit of code that will display your photos as a 3 column grid 650px wide and will display as many photos as the recordset contains using the do while loop. Adjust to your own needs.

Code:

// establish a connection 
// query your database
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style type="text/css">
ul {
list-style:none;
width: 650px;
}
 
li{float:left;
border:1px solid black;
}
 
li img {
width:180px;
height:135px;
padding:10px;
 
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
 
<body><ul><?php do {?>
 
<li><img src="<?php echo $row['imageURL'] ;
 
?>" /></li>
 
<?php }
while($row = mysql_fetch_assoc($result));?></ul>
</body>
 
</html>
<?php
mysql_free_result($result);
?>

Thanks for your help i tried your solution and it works well thank you very much!

Regards,
Martin