View Single Post
Old 06-13-2008, 05:06 AM   #4 (permalink)
dschreck
The Contributor
 
dschreck's Avatar
 
Join Date: Nov 2007
Location: California
Posts: 82
Thanks: 0
dschreck is on a distinguished road
Default

Quote:
Originally Posted by xenon View Post
Plus, if you need to nest mysql_fetch_assoc functions, then you'll also need separate database connections ;)
He won't need to declare another mysql_connect(). MySQL will handle this by itself. While true, it does create another thread, it does not require to mysql_connect() again. Nesting does not truly have any adverse effects.
While it may be recommended that he does a JOIN instead of one query and another, or at least attempt a sub query, I wouldn't say using nested mysql_fetch_assoc() need any type of warning.

Just my 2 cents though :P
__________________
Where I Ramble: http://www.iwilldomybest.com/
What I do: Zynga Game Network
Senior Software Engineer at CityVille
dschreck is offline  
Reply With Quote