Ouput more that one image on a line? Easy?

[darthmahon]

Hey,

Ok I'm setting up an image library and I need to ask something regarding the output of images.

At the moment I am using this:

<?

// generate and execute query

$query = "SELECT * FROM IMAGES";
$result = mysql_query($query) or die ("Error in query: $query. " .

mysql_error());

// if records present

if (mysql_num_rows($result) > 0)

{
    // repeat rows

while($row = mysql_fetch_assoc($result))

{
?>
<img src="<? echo £row->url; ?>">
<?

} // end repeat

}

else

{

echo "Nothing found";

}

?>

Now, I would like to ouput more than one Image per line, but I'm not quite sure how to do this. Ideally, I would like three images per line, they are all 100*100 pixels so they will fit easily, just not sure how to tell PHP to do this??

Cheers,
Chris

[sidney]

  for($i=1;$i<25;$i++)
	{
	echo"<img src=\"\" alt=\"\" width=\"100\" hieght=\"100\" />";
	if($i%3==0) // if remainder of $i divided by3 = 0
		{
		echo"<br>";
		}
	}

?>

[darthmahon]

Thanks for your reply.

Ok tried to put that code between my while statement, ended up with hundreds of images? Where exactly is this code meant to fit?

Cheers,
Chris

[sidney]

 <?

// generate and execute query

$query = "SELECT * FROM IMAGES";
$result = mysql_query($query) or die ("Error in query: $query. " .

mysql_error());

// if records present

if (mysql_num_rows($result) > 0)

{
    // repeat rows
   $i=1;
    while($row = mysql_fetch_assoc($result))

{
?>
<img src="<? echo £row->url; ?>">
<?
	if($i%3==0)
		{ 
   		echo"<br>"; 
    	}
		$i++; 
    	} // end repeat

}

else

{

echo "Nothing found";

}

?>

 

[darthmahon]

Perfect! Many thanks Sid 😃

[darthmahon]

Looks like it's not quite working as I first thought. Trying to get the images to repeat, but I also need some text next to them. Currently using the following:

<?

// repeat rows

$i=1;

while($row = mysql_fetch_assoc($result))

{

?>
<table width="150" border="0" cellpadding="0" cellspacing="0" class="NewsText">
	<br>
	<tr> 
		<td width="150" align="center"><p><a href="image-edit.php?id=<? echo $row['imageid']; ?>"><img src="<? echo $row['location']; ?>" border="0"></a><br>
		<?php echo $row['title']; ?><br>
		<a href="image-edit.php?id=<? echo $row['imageid']; ?>"><img src="../images/edit.gif" width="70" height="13" vspace="5" border="0" align="texttop"></a> 
		<br>
		Delete? <? echo '<input type="checkbox" name="records_id[]" value="'.$row['imageid'].'">'; ?> 
		</p>
		</td>
	</tr>
	<br>
</table> 
<? 
	if($i%3==0)

{ 

echo"<br>"; 

}

$i++; 

} // end repeat

?>

Seems to put each image on a different line, not the same line? Any ideas?

Thanks for your help so far,
Chris

[sidney]

 <table width="150" border="0" cellpadding="0" cellspacing="0" class="NewsText">
	<br>
	<tr> 

<?php
$i=1;
// repeat rows
while($row = mysql_fetch_assoc($result))

{

?>

	<td width="150" align="center"><p><a href="image-edit.php?id=<? echo $row['imageid']; ?>"><img src="<? echo $row['location']; ?>" border="0"></a><br>
	<?php echo $row['title']; ?><br>
	<a href="image-edit.php?id=<? echo $row['imageid']; ?>"><img src="../images/edit.gif" width="70" height="13" vspace="5" border="0" align="texttop"></a> 
	<br>
	Delete? <? echo '<input type="checkbox" name="records_id[]" value="'.$row['imageid'].'">'; ?> 
	</p>
	</td>
<? 
if($i%3==0)

{ 

echo"</tr><tr>"; 

}

$i++; 

} // end repeat

?>
</table>  

[darthmahon]

Doesnt seem to work m8??

<?

// include db data
include("access/data.inc.php");

mysql_connect ($SQLhost, $SQLuser, $SQLpass);
mysql_select_db ($SQLdb);

// generate and execute query

$query = "SELECT * FROM IMAGES";
$result = mysql_query($query) or die ("Error in query: $query. " .

mysql_error());

// if records present

if (mysql_num_rows($result) > 0)

{

?>
<table width="150" border="0" cellpadding="0" cellspacing="0" class="NewsText">
    <br>
    <tr>

<?php
$i=1;
// repeat rows
while($row = mysql_fetch_assoc($result))

{

?>

    <td width="150" align="center"><p><a href="image-edit.php?id=<? echo $row['imageid']; ?>"><img src="<? echo $row['location']; ?>" border="0"></a><br>
    <?php echo $row['title']; ?><br>
    <a href="image-edit.php?id=<? echo $row['imageid']; ?>"><img src="../images/edit.gif" width="70" height="13" vspace="5" border="0" align="texttop"></a>
    <br>
    Delete? <? echo '<input type="checkbox" name="records_id[]" value="'.$row['imageid'].'">'; ?> 
    </p>
    </td>
</tr>
<br>

<? 
    if($i%3==0)

{ 

echo"<tr></tr>"; 

}

$i++; 

} // end repeat

?>
</table>
<?
}

else

{

echo "Nothing found";

}

?>

[sidney]

edited my previeous code example took out the offending </td> and <br>

try it now

[darthmahon]

Excellent 🙂 Many thanks good sir! 😃