Which method is better?

[envexlabs]

Hey,

 

Just a quick question that occured today.

 

Which method is better to grab rows from a mysql database, or are they exactly the same?

 

method 1:

 

$query = mysql_query(SOME QUERY);

$result = mysql_fetch_assoc($query);

 

method 2:

 

$result = mysql_fetch_assoc(mysql_query(SOME QUERY));

[DarkWater]

Well, the first one creates an extra variable, but in reality, they're pretty much the same.  The real best method would be a DBAL. =P

[BlueSkyIS]

my preferred method so i know when my SQL is wrong:

 

$query = mysql_query(SOME QUERY) or die(mysql_error()." in SOME QUERY");
$result = mysql_fetch_assoc($query);

 

otherwise, you're left guessing.

[envexlabs]

thanks!

[PFMaBiSmAd]

The first method permits error checking, error reporting, error logging, and error recovery, so that it could be used in a real life application. The second method does not, and would earn a C- in a programming class.