please help with breaking a list

mcshen

i have a db table with 1000 entries.

i wanna select all of them and load it in a php page. I know how to do this.

but, i wanna put a banner after every 100 entries. how do i do that? please help. thanks

Jacker

check out this link: http://www.evolt.org/article/Multiple_Pages_With_PHP/17/19340/

this will show you how to split your results from a query
the gist of it is:

$results = mysql_query("SELECT * FROM your_table WHERE name LIKE '%". $query ."%' ORDER BY name ASC LIMIT $page, $limit");

where $page will equal how many pages and $limit is the number of results you want per page

eoghain

I'm assuming that you have a loop building your table:

$row = 0;

// begin looping through data
   $row++
      if ($row == 100) {
         $row = 0;
         // build banner row here
      }
   // build regular rows here
// end looping through data

mcshen

i don't want "next" or "prev". i want them in 1 page.

thanks for the info. i will take a look

Jacker

well the link is useful, it goes beyond what U'r asking for, but it will help you to understand the concept. In it it
echos links, but you can easily replace it by insert the banner after $limit has been reached

Mega

Originally posted by Jacker
well the link is useful, it goes beyond what U'r asking for, but it will help you to understand the concept. In it it
echos links, but you can easily replace it by insert the banner after $limit has been reached

nope he is right and you are wrong.

either you need to read the manual or need to reread his first post 🙂

egohain is correct but has been ignored 😕


$result = mysql_query( query );

$i = 0;

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

$i++;

echo $row['data'];

if( $i = 100 ){
echo 'banner stuff';
$i = 0;
}

}

is a longer explaination of what has been said.

🙂

eoghain

Thanks Mega.

I guess I'm just getting lazy in my old age.

Jacker

ok, I'm sorry , but I didn't read Egohain's reply first, so I did not refer to his code. I did not purposely discredit his post.

Mega

Originally posted by eoghain
Thanks Mega.

I guess I'm just getting lazy in my old age.

heh, i wuda thought sum1 wuda understood wot u meant, u cudnt have been any clearer

🙂

Jacker

Xcuze me, for posting after he has posted. Waddya want me to go back in time and refresh the page while I was posting. I'm sorry and Dat's it.

mcshen

thank you all!!
tha'ts what i need.

mcshen

thank you. it worked.