[RESOLVED] Quick question about mysql_fetch_array

[dabdura]

Hello to most helpful forum ever 🙂

I've got a simple question:
what's the difference(if any) between

$sql = mysql_query("SELECT you_ff FROM finished WHERE '$off_id'=camp_ff AND '$ip'=user_ip");
$result = mysql_fetch_array($get_auth);

and

$result = mysql_fetch_array(mysql_query("SELECT you_ff FROM finished WHERE '$off_id'=camp_ff AND '$ip'=user_ip"));

is there any performance difference or anything, second one works for me fine and I don't see the reason why anyone would want to use first example.

[dabdura]

$sql = mysql_query("SELECT you_ff FROM finished WHERE '$off_id'=camp_ff AND '$ip'=user_ip");
$result = mysql_fetch_array($get_auth);

and

$result = mysql_fetch_array(mysql_query("SELECT you_ff FROM finished WHERE '$off_id'=camp_ff AND '$ip'=user_ip"));

[zypher11]

They both do the same thing, however the second one that you prefer is considered bad practice. Because its less descriptive, more jumbled. You want to define things separately so that it looks more clean and organized.

[dabdura]

thanks for the answer

if thats the only problem with it i'm gonna keep my preferred one, because my code has to do a lot of mysql_query and setting variable for each fetch looks more disorganised to me.

regards