efficient code help...

[Anon]

which statment would be more efficient:

while ($row = mysql_fetch_array($result)) {
extract($row);
}

while ($row = mysql_fetch_array ($result)) {
$variable = $row["variable"];
}

and also what is the efficient way to get just one variable from a mysql call?

[oeveren]

I'd say the first method is more efficient, because you only use one command to fetch all data.
With the second one, you can only get one variable per fetch. So, if you want to get more variables, you'd have to add lines in the second method:

$variable1 = $row["variable1"];
$variable2 = $row["variable2"];
$variable3 = $row["variable3"];

Get one variable from sql:

$query="select address from diary where (id='$id')";
$result=mysql_query($query);
$array=mysql_fetch_array($result);
$address=$array["address"];

thx,

Dik

[cordex]

Well, if he only needs one variable, then the second method is FAR more efficient. On my system, pulling from a mysql database, it takes 1/100th of the time to use $variable=$row["variable"].

[cordex]

I tried adding several more variables and there was no significant increase in time taken. Use the direct method.

[oeveren]

I agree, that's if you only want one variable.
However, There should be a break even point when you want to retrieve more information. I guess it's a matter of experimenting.

Dik