[PHP-DB] order by a count of another table

[Noah Spitzer-Williams]

hey guys,

    i want to show a list of rows from a table sorted by the count of
another table. the first table has a username field and so does the other
table. so i want to sort the first table by how many rows that has the
username from the other table.

    so something like this although i know its not sql syntax:

    select * from table order by [count(*) from other_table where
username=table.username]

can anyone help me out?

thanks guys!



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]