mysql_db_query Vs. mysql_query

daarius

why would someone use mysql_db_query() instead of mysql_query() ? and vice versa.

i just want to know the differences. i know that mysql_db_query will make an extra mysql_select_db() before the query is made, which obviously will result in a bit slower than mysql_query() .. but then again the speed difference is i guess not noticeable.

but anyway, what is the real difference apart from the above reason?

thanks,
Daarius...

brandonschnell

i use mysql_db_query because i don't have to guess what the current open database is.

my headers set the database $db, then:

$results = mysql_db_query($db,"SQL QUERY");

to me, any speed hit is worth not having to worry about switching databases and forgetting to switch back.

daarius

ok, so that means using the mysql_db_query() is more sensible ONLY if you are using several databases in your system. or is it not? 🙂

else mysql_query() is fine if only 1 database is under use.... right?

brandonschnell

mysql_query() is fine if only 1 database is under use ... tho ask me again after you have to add support to access a couple different databases( mysql db & a production db & a test db wouldn't be uncommon) =)