[RESOLVED] extract () error

goclimb

I am getting the following error when I load my web page :

Warning: Wrong parameter count for extract() in /home/mfleming/outdoor-resources.com/html/map_test.php on line 8

Here is the code that is in question:

<?php
$HTTP_GET_VARS['ID'];
$db = mysql_connect("xxx", "xxx", "xxx");
mysql_select_db("database",$db);
$result = mysql_query("SELECT Longitude, Latitude, SiteName, Address, City, State, Zip FROM rv WHERE ID = '$ID'",$db);
$affiliate_result = mysql_query("SELECT URL, SiteName, Description FROM affiliates WHERE Category = 'rv' ORDER BY SiteName", $db);
$myrow = mysql_fetch_array($result);
extract($myrow, $Longitude, $Latitude, $SiteName, $Address, $City, $State, $Zip);
?>

I don't understand what the error message is saying. I have 7 variables that I'm pulling from the database, and 7 variables that I'm trying to extract. Does anybody have an idea what I did wrong?

Thanks!

Mark

drew010

i think you misunderstand extract. if you pass it an array, it will extract the variable from it into the global scope.
i.e.
extract($POST);
will turn variables like $POST['name'] and $_POST['email'] into just $name and $email.
if you wanted to do that with the array you get from mysql you can use
extract($myrow)

goclimb

Yep, it appears you are correct. I did misunderstand the use of extract. I've changed the code simply to :

extract($myrow);

and it's doing what I need.

This was the original example I tried when attempting to understand extract:

$myrow = mysql_fetch_array($result);
extract($myrow, $Longitude, $Latitude);
echo "$Longitude";
echo "$Latitude";

That work, so I just extended it to the other variables. But, I think I better understand it now (or, it's at least doing what I want it to do).

Thanks!

Mark

drew010

ah yeah, if you check out the extract prototype
int extract ( array var_array [, int extract_type [, string prefix]] )
basically what happened when you passed the 2 extra variables is they were empty so it had the same effect as calling the function with just the first argument.