Stupid Query-thinking?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Thanks forr the answers, but i still have a problem
getting this to work:

My query is the following:
$result = mysql_query("SELECT,, COUNT( AS
'number_of_animals' FROM species s LEFT JOIN animals a ON GROUP BY ORDER BY ASC");

1st question: how do i display/get the number_of_animals,
2nd question: what does GROUP BY do?
3rd question: What happens if in both tables i have an id, so &
              How can i display both in the result, since echo
              doesn't work..

Hope it's all clear, and thanks in advance!!

Greetings and have a wonderful day!

Site Timeline