i think this question would be better posed on a mysql/php forum, but to be honest, i'd be more concerned about the web servers capabilities than the database opening multiple recordsets simultaneously. in other words, i doubt you should have any trouble.
and as always for optimal database performance it's always good knowing how to get the most out of your database (ie, using indexes on your tables, stored procedures, well formed sql joins, etc.)