Need Help for Looping

[shanee]

hello....

i am newbie to php and have problem this is a loop for my wallpaper thumbs

 

<?php

$sql = "select wallpaperid from wallpaper";

$result = mysql_query($sql ,$db);

if ($myrow = mysql_fetch_array($result)) {

do {

printf("<td><a href='%s'><img src='images/sample/%s.jpg' border='0'></td>", $myrow["wallpaperid"], $myrow["wallpaperid"]);

 

} while ($myrow = mysql_fetch_array($result));

 

}

?>

 

if i have 6 pictures in database it will show like this

 

Image1.gif

Image2.gif

Image3.gif

Image4.gif

Image5.gif

Image6.gif

 

but i want it show the result like this in table

 

Image1.gif Image2.gif Image3.gif Image4.gif

Image5.gif Image6.gif

 

thanks

[chigley]

<?php

$sql = "select wallpaperid from wallpaper";
$result = mysql_query($sql ,$db);

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

printf("<td><a href='%s'><img src='images/sample/%s.jpg' border='0'></td>", $myrow["wallpaperid"], $myrow["wallpaperid"]);

}

?>

 

Try that

[shanee]

it works fine, but not fit with my needs

 

actually i want to get below result

 

image1  image2

image3  image4

image5  image6

image7  image8

 

[flappy_warbucks]

<?php

$sql = "select wallpaperid from wallpaper";
$result = mysql_query($sql ,$db);
$x=0;

while ($myrow = mysql_fetch_assoc($result)) 
{
    if ($x == 2)
    {
        $x=0;
        echo "<tr>\n";
    }
    else if ($x < 2)
    {
        printf("<td><a href='%s'><img src='images/sample/%s.jpg' border='0'></td>", $myrow["wallpaperid"], $myrow["wallpaperid"]);
        $x++;
    }

}

?>

 

that should do it.

[shanee]

i have check it but it gives me following result

 

image1 image2

image3 image4

 

 

means it cant show more than 4 results but the mysql row contain upto 10 entries i also tries

 

$sql = "select wallpaperid from wallpaper order by wallpaperid desc limit 0,15";

 

but getting same result

[Barand]

See

 

http://www.phpfreaks.com/forums/index.php/topic,139336.msg591593.html#msg591593

 

just define NUMCOLS as 2