[PHP-DB] How I can use multiple results in MySQL

[Yevgeny Dyatlov]

Hello,
I'm cann't using query to MySQL like this:

SELECT name FROM cia WHERE region =
(SELECT region FROM table WHERE name = 'Brazil');

And

SELECT name FROM table WHERE count =
(SELECT max(count) FROM table);

I want to select COLUMN_NAME in TABLE where ID is max,
how I can do it?

-- 
Best regards,
 Yevgeny                          mailto:[EMAIL PROTECTED]



-- 
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]