php loop to split list

[tytyguy]

Hello, when I return values from my database I am outputing them into a <li> tag but long list will make the page huge... I know I need to use a for loop to break up the <li> and put a </ul> in there somewhere but cant figure out how to do this... if someone could help, id be greatly appreciative. Hers the code....

<ul>
while ($data = mysql_fetch_array($query, MYSQL_ASSOC))
{
	$city= $data['city'];
	$citylower= strtolower($city);

	echo "<li><a href='rate-page.php?state=$state&city=$city'>$city</a></li>";
		
}


echo "</ul>";

[Shrapnel_N5]

No, you don't need for loop.
you need, probably, LIMIT sql operator and some paginating code, I guess

[tytyguy]

dont think so....

[imaginethis]

dont think so....

He's kinda right.

[hash]

probably wants say 100 cities in 5 floated lists of 20??
you could use array_chunk() or modulo, or just a plain old counter

[tytyguy]

can you explain more?

[Shrapnel_N5]

can you explain more?
give us an example of html that you want

[tytyguy]

Ok... I am outputting this right now....

<ul>
<li>kansas</li>
<li>nevada</li>
<li>nebraska</li>
<li>alaska</li>
<li>alabama</li>
<li>new york</li>
</ul>

(of course its 52 list items)

and I want...

<ul>
<li>alaska</li>
<li>alabama</li>
<li>new york</li>
</ul>

<ul>
<li>kansas</li>
<li>nevada</li>
<li>nebraska</li>
</ul>


after 5 li's I want to end the ul and start a new one, but keep running through the array so it splits 52 states from one ul into 10 uls

edit: and I dont want paging. this is just for a single div on my homepage, so pagination would not be applicable.

[Shrapnel_N5]

You said before that "long list will make the page huge".
So, you think that this parted list will make the page smaller?

[tytyguy]

Well I can float the uls left so I can have atleast 3-4 uls across the page. I woulndt image it would only be 2 rows by 4-5 columns.

..not very big. theres only 50 states.

[Shrapnel_N5]

You can make it as with pencils.
Count to 5 and then put "</ul><ul>" out.
Usually we count using a variable.

[tytyguy]

wow...thanks