Move to next MySQL record

[I_Love_My_Vans]

Is there a way to move to the next record where stated in the PHP code?

while ($myrow = mysql_fetch_row($result)) {

echo("line 1");

// Move to next record

echo("line 2");

} 

Thanks, ILMV

[john tindell]

When you call mysql_fetch_row it autmatcially moves to the next record. Are you trying to do something specific.

[I_Love_My_Vans]

Yes i am loading pictures using a link in a MySQL database, the pictures are two to a row, so i need to bring the first down, then move a record and bring the second donwn.

If there isnt a way around it i will have to do it the hard way.

thanks :thup:

[john tindell]

Your putting the images in a table right?

Try

<table>
    <tr>
<?
$i = 1;
while ($myrow = mysql_fetch_row($result))
{
    print "<td>{$myrow['value']}</td>"
    
    if(($i % 2)==0)
    {
        print "</tr><tr>";
    }
    $i++
}
?>
    </tr>
</table>

[I_Love_My_Vans]

That was plan B

Thanks for your help (Y)