asp classic - Problems with returning a row in MySQL, ASP -

i'm making switch asp/access asp/mysql

i'm working default tables in mysql.

i'm trying write query counts records , allow me list contents @ same time.

"select * world.city order name asc" 

i trying combine select count () as, full list.

i can achieve them seperate queries, not together. i've tried:

"select name, select count(*) itotal world.city order name asc" 

but returns 1 row.

try this:

  select name, count(*) itotal     world.city group name order name asc;