[RESOLVED] Display Photos

[neroag]

Hi Guys, I have a small piece of code below that will search the database & display the results, the problem im having is i need the results to be displayed in the format of ... photo1 photo2 photo3 ...... instead of the format ...
photo1
photo2
photo3
...
can anyone help please

Thank you

require('config.php');
$name ="babyphotos";
mysql_connect($dhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM details WHERE maindir = '$name'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$name2=mysql_result($result,$i,"maindir");
$photoa=mysql_result($result,$i,"maincont");
$path2 ="$name/$photoa";
echo '<table cols="2" border="0" cellpadding="10" cellspacing="0" align="center" width="100%">';
print "<td><a href=\"$path" . $path2 . "\"><img src=\"$path" . $path2 . "\" width=129 height=160></td><tr>";
$i++;
}
echo "</table>";
echo "</tr></td>";
?>

[coreyp_1]

Change:

while ($i < $num) {
$name2=mysql_result($result,$i,"maindir");
$photoa=mysql_result($result,$i,"maincont");
$path2 ="$name/$photoa";
echo '<table cols="2" border="0" cellpadding="10" cellspacing="0" align="center" width="100%">';
print "<td><a href=\"$path" . $path2 . "\"><img src=\"$path" . $path2 . "\" width=129 height=160></td><tr>";
$i++;
}

to:

echo '<table cols="2" border="0" cellpadding="10" cellspacing="0" align="center" width="100%"><tr>';
while ($i < $num) {
  $name2=mysql_result($result,$i,"maindir");
  $photoa=mysql_result($result,$i,"maincont");
  $path2 ="$name/$photoa";
  print "<td><a href=\"$path" . $path2 . "\"><img src=\"$path" . $path2 . "\" width=129 height=160>";
  $i++;
}

[Rodney_H_]

EDIT: OOPS! Sorry, Corey. You must have posted while I was still trying to figure it out.

i came up with this, might work:

<?php
require('config.php');
$name ="babyphotos";
mysql_connect($dhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM details WHERE maindir = '$name'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
// set counter to zero
$i=0;
// begin table
echo '<table cols="2" border="0" cellpadding="10" cellspacing="0" align="center" width="100%">' . "\n";
while ($i < $num) {
$name2=mysql_result($result,$i,"maindir");
$photoa=mysql_result($result,$i,"maincont");
$path2 ="$name/$photoa";
// if $i is divisible by 3 then start new row
if ($i % 3 == 0){ 
echo '<tr>' . "\n";
}
echo '<td><a href="' . $path . $path2 . '"><img src="' . $path .  $path2 . '" width=129 height=160></td>' ."\n"; 
$i++;
// if $if is divisible by three end row
if ($i % 3 == 0){
	echo '</tr>' . "\n";
}
}
echo "</table>";
?>

[neroag]

Thanx Guys, It works a treat