How can I change this output...

[jaroon]

Hello all of you! I am trying to change the output on this to show multiple rows of images placed horizontally.

Currently the output is in 1 row placed vertically, showing up to 30 images (which can be ugly layout wise...)

What I would like to do is 1 row horizontally for for each 6 images, yet I am logically challenged to write / modify this code to do that.

If this is something that will take time and effort, feel free to solicit me for this modification: [e-mail]

Here is the current layout:
http://72.29.75.135/~crosstow/carview.php?view=30

Here is the code that displays the output:

//print out the listing itself
Print "<table border=0 cellspacing=0 cellpadding=0 width=\"100%\">";
Print "<tr><td><font face=\"arial,ms sans serif\" size=3><b>Listing : $a_row[title] </b></font></td></tr>";
Print "</table><p>";
Print "<table border=0 cellspacing=0 cellpadding=2><tr><td rowspan=20 valign=top align=center width=165><font size=2 face=\"Arial,Helvetica,Geneva,Swiss,SunSans-Regular\">";

					//is there an image?
					//select images connected to a given listing
					$count = 0;
					$query = "SELECT * FROM tbl_Files WHERE prop_num =  $a_row[id]";
					$result = mysql_query("$query",$link);
					while ($image_row =mysql_fetch_array ($result) )
						{

						echo "<B>";
						echo stripslashes($image_row[description]) . "<BR>\n";
						echo "</b><table border=0 cellspacing=0 cellpadding=0 width=100><tr><td align=center><a href=\"./image.php?Id=$image_row[id_files]\" target=\"_new\"><img src='image.php?Id=$image_row[id_files]' border=0  height=75 alt='Click to Enlarge'></a></td></tr></table>";
						echo "<P> \n";
						$count++;


						}
					print "</font>";

					if ($count == 0)
 					 	{
 					 	print "<table border=0 cellspacing=0 cellpadding=0 width=100><tr><td align=center><img src=\"./images/nophoto.gif\" border=0  height=75></a></td></tr></table>";
 					 	}  

					elseif ($count == 1)
						{
						print "<font face=\"arial\" size=1><b>Click photo to enlarge</b></font><br><br><p>";
						}
					else

						{
						print "<font face=\"arial\" size=1><b>Click photos to enlarge</b></font><br><br><p>";
						}


					Print "</td>

[bpat1434]

I have a solution for you, and it's going to take me a bit to type, so just bear with me.....

Problem
You want to display the images horizontally not vertically.

Current Problem
The loop creates a new table (it seems) for each image

The Solution
Use a for() loop to create rows, not the entire table.

<?php
/*
** Do whatever you want above here.
** But to show 6 images in a table,
** all together and horizontal, use the
** code below.  You can mod it as you
** need, but it gets you what you want.
*/
$count = 0;
$query = "SELECT * FROM tbl_Files WHERE prop_num = $a_row[id]";
$result = mysql_query("$query",$link);

echo "<table width=\"100%\">\n<tr>\n";
while ($image_row =mysql_fetch_array ($result) ){
    echo "<td>";
    echo "<a href=\"./image.php?Id=$image_row[id_files]\"><img src='image.php?Id=$image_row[id_files]' border=0 height=75 alt='Click to Enlarge'></a>";
    echo "</td>\n";
   $count ++;

if($count %6 == 0){
    echo "</tr>\n\n<tr>";
}
}
echo "</tr>\n</table>";
?>

I don't know what your code is doing, but here are some tips to help you:

Use indentation (so much easier on the eyes)
Think constructively as to what it is you want to have it look like
Test, Test, and Test more
Google your thoughts for help
Test Test Test.

And, please in the future, use the php tags.  I love them as they help so much.


[-PHP-]<?php
// Put your code here
?>[-/PHP-]
Remove the hyphens from the [BBCode] tags.

But that will display a page that shows 6 images side by side and wraps at the 6th image.

In case you're wondering about the if($count%6 == 0) line:

If the value of $count divided by 6 is 0 (no remainder) then it will end the row and start a new one.

Hope that helps.

~Brett