[mysql help]

i was wondering if there was a query that i could put in to sort thing first by name then by number.

 

Example

George 21

Jim 18

Bob 21

Bill 16

George 12

 

and have this result

 

Bill 16

Bob 21

George 12

George 21

Jim 18

[mysql and php help]

when i use that i get the table rows then the table heading after that

even thought i have the code in html for the table header way before the pagination code

[mysql and php help]

i was wonder how i could show things in a table but only so many at a time

i have <100 things in a database but i need to put them with no more than 40 on a page. could some one tell me how to do that, please.

thanks