database results?

[sachinphp]

I have images in my database named image1, image 2 etc. how do I retrieve them using a "for" loop?

When I try "$result[image.$i]" it keeps throwing up an error.

Thanks

[lara8]

Example using a mysql database

// Get all the images out of the database
$result = mysql_query ("SELECT * FROM tablewithimages")
or die ("Invalid query.");

// Determine the number of images that have been retrieved
$num_rows = mysql_num_rows($result);

// Start for-loop
for ($i=0; $i==$num_rows; $i++)
{
// Read next row from $result
$row = mysql_fetch_array($result);
// Retrieve image stored in this $row
$image = $row[ image ];
}

Hope this is what you mean.

[Anon]

$num_rows = mysql_num_rows($result);

// Start for-loop
for ($i=0; $i==$num_rows; $i++)
should be
<b>for($i=0; $i<$num_rows; $i++)</b>
{
// Read next row from $result
$row = mysql_fetch_array($result);
// Retrieve image stored in this $row
$image = $row[ image ];
}
<b>Easiest way to do it is this</b>
while($row=mysql_fetch_array($result)
{
$image=$row[image];
}
mysql_fetch_array() function fetches next element and stores it in $row variable, until there is nothing more to fetch, so it's not needed to use mysql_num_rows in this case.

Di