Hello

I'm just in the process of making a website for a guy selling art. The artworks etc are stored in a database and I'm using PHP/mySQL to access and show the results.

Normally, I'd just show the results vertically down the page, however, he would like the results to be 3 per line.

for example

PHP Code:

+-----------------+-----------------------+--------------+
|                          |                              |                       |
|          entry 1   |          entry 2       |     entry 3     |
|                          |                              |                       |
|                          |                              |                       |
+------------------+---------------------+------------- --+ 


and then to go down the page like that, that is, 6 entries would be displayed in 2 rows of 3 entries as above

Does anyone have any helpful pointers for this? Some code would be helpful, to demonstrate. Otherwise, some keywords to search Google with.

Thanks in advance, all help is much appreciated
hamish

The mod operator will be helpful here.
Say you wanted to output this as a table, you would write code a bit like this:

PHP Code:


$result=mysql_query("query here to get the pictures");

echo "<table><tr>";

$i = 1;
while($row = mysql_fetch_array($result)) {
  echo "<td>";
  echo"<img src='".$row['theimage']."' alt= etc...";
  echo "</td>";
  if(($i % 3) == 0) echo "</tr><tr>";
  $i++;
}

echo "</tr></table>"; 


The % operator is the mod or remainder operator, and returns the remainder of dividing one number by another - so 1 % 3 is 1 since 1 / 3 is 0 remainder 1.
38 % 3 = 2 since 38/3 = 12 remainder 2. This allows you to express the "start a new row every 3 pictures", since starting from 0 we have:
0%3=0
1%3=1
2%3=2
3%3=0 (3/3 = 1 rem 0)
4%3=1
etc...

zero comes around every 3, so we increment $i in the loop and when i%3==0 we print "</tr><tr>" to start a new row.

Thank you!

thank looks just like what I need!!!

I'll spend tomorrow doing htat, and get back to you. Thanks so much.

hamish