Breaking a wile loop in half

[metamlmini]

Hi guys,

 

So here is the deal.

 

We have a list of brands that excists in a database. There are also images associated with the names. But not all the brands have images. So in the script i read if the file excists.

 

Well this all works fine but it looks horrible. So i want to break the list in half (or limit it to 24). But i cant limit the sql query.

 

Is there a way to "limit" a while loop and let it resume on the same page, just to change the layout (multiple collumns)? (I hope i am clear on this... i confuse even myself)

 

$host = 'localhost';
$user = 'qwerty';
$pass = 'qwerty';
$db = 'qwerty';

$query = "SELECT * FROM ros_brands";

$result = mysql_query($query) or die(mysql_error());

$filename = "/resources/images/mm_files/" . $row['image_file_id'] . ".gif";

while($row = mysql_fetch_array($result)){

$filename = "/var/www/vhosts/test.nl/httpdocs/resources/images/mm_files/" . $row['image_file_id'] . ".gif";

if (file_exists($filename)) {
        echo    "<a href='#'><img src='/resources/images/mm_files/" . $row['image_file_id'] . ".gif' /><span>". $row['name'] ."</span></a>";

} else {
//    echo "The file $filename does not exist";
}

}

[spiderwell]

you could put a count variable into the loop and use that to trigger your break

[Maq]

You will need to use the  modulus operator.  Check out:

http://betaprogrammer.com/content/?p=336

[litebearer]

or implement pagination

[Maq]

or implement pagination

Right.  Depending on what you want to do, pagination might be a better option.  Here is a nice tutorial:

http://www.phpfreaks.com/tutorial/basic-pagination

[metamlmini]

Pagination is not an option because in that case you limit using mysql. Which will not work in my case.

 

This because not all the brands have a image (yet).