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
can anyone help me out?
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]