Query Result

[Nokiaringtone.org]

Newbie question:

I have to query my database for a list of pictures + their respective title. These pictures and descriptions should be listed on my index-page. I currently have a table with 4 columns per row, so 4 results per row. This is something I should get:

<tr><td>Pic1</td><td>Pic2</td><td>Pic3</td><td>Pic4</td></tr>
<tr><td>Pic5</td><td>Pic6</td><td>Pic7</td><td>Pic8</td></tr>

This is probably very easy, but I have no idea how to do this.

[swdev]

It is relatively easy, but where does the title go?

[Nokiaringtone.org]

I didn't implement the title in the question because I would be able to figure that out myself once I found out how the other thing was done. The title can easily be put in the same <td> as the picture, so that would not cause any extra problems

[lilleman]

Hi,

Here is some pseudo code that might be helpful.

<?php

// fetch the images from the database

$query = 'SELECT name, title FROM images';
$result = mysql_query($query) or die(mysql_error());

// display the images

$counter = 0;

while(( $image = mysql_fetch_assoc($result) ) && ( $counter++ >= 0 ))
{
  // the start of a new row?
  
  if( $counter % 4 == 0 )
    echo '<tr>';
  
  // display the current image
  
  echo '<td><img src="', $image['name'], '" alt="" title="', $image['title'], '" /></td>';
  
  // end of the row?
  
  if( $counter % 4 == 3 )
    echo '</tr>';
}

// fill the empty cells

if( $counter % 4 != 3 )
{
  do { echo '<td></td>'; }
  while( $counter++ % 4 != 3 );
  
  echo '</tr>';
}

?>

Yours, Erik.