[RESOLVED] Help with image layout

[ali_p]

Hello,

I'm have image names stored in a databse and what i am trying to achieve is a better way of laying these out on my page. The code i am using to lay out two rows of 4 images is this

$sql = mysql_query("SELECT * 
					FROM images 
					WHERE property_code='$property_code'") 
or die (mysql_error()); 

echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"10\">\n"; 


// Set initial value to zero 
$cntrow = 0; 

while ($row = mysql_fetch_array($sql)) { 

$image_id=$row['image_id'];
$property_code=$row['property_code'];
$image_name=$row['image_name'];

// Determine value of $cntrow and print new row 
if ($cntrow == 0) { echo "<tr>"; } if ($cntrow == 4) { echo "<tr>"; } if ($cntrow == 8) { echo "<tr>"; } 
if ($cntrow == 2) { echo "<tr>"; } if ($cntrow == 4) { echo "<tr>"; } 
// Print thumbnail 
echo "<td><img src=\"photo_uploads/$image_name\" width=\"50\" height=\"50\" border=\"0\"</td>\n"; 

// Adds 1 to $cntrow variable 
$cntrow = $cntrow + 1; 
} 

echo "</table>\n";

And i'm trying to modify it so that i have 1 large image in the top row and 4 smaller ones in the second row, but i keep ending up with duplicate images, does anyone know of a better way that i can manipulate how my images are displayed please.
Much appreciated.

[Najjar]

What is the image you need to be on the top?
Is it the first image of each 4?

[ali_p]

Hi

Yes the large image on the top is the first.

[ali_p]

I think i have sorted this , i put an if statement within my output to determine which image goes 1st and the positioning of the other images.

heres the new code.

$sql = mysql_query("SELECT * 
					FROM images 
					WHERE property_code='$property_code'
					ORDER BY position ASC") 
or die (mysql_error()); 

echo "<table border=\"0\" cellspacing=\"2\" cellpadding=\"5\">\n"; 


// Set initial value to zero 
$cntrow = 0; 

while ($row = mysql_fetch_array($sql)) { 

$image_id=$row['image_id'];
$property_code=$row['property_code'];
$image_name=$row['image_name'];
$position=$row['position'];

if ($position ==1){
echo "<tr><td colspan=\"4\"></td><img src=\"photo_uploads/$image_name\" width=\"260\" height=\"170\" border=\"0\"</td></tr>";
}

if ($position > 1){
// Determine value of $cntrow and print new row 
if ($cntrow == 0) { echo "<tr>"; }
// Print thumbnail 

echo "<td><img src=\"photo_uploads/$image_name\" width=\"50\" height=\"50\" border=\"0\"</td>\n"; 

// Adds 1 to $cntrow variable 
$cntrow = $cntrow + 1; 
} 
}

echo "</table>\n";

Thanks and resolved

[Najjar]

Great, just close the <tr> from

if ($cntrow == 0) { echo "<tr>"; }

After you use:

echo "<td><img src=\"photo_uploads/$image_name\" width=\"50\" height=\"50\" border=\"0\"</td>\n";

Add this:

if ($cntrow == 0) { echo "</tr>"; }