At 09:52 06.11.2002, Steve Jackson said:
>function get_order_numbers()
>$conn = db_connect();
>$query = "select orders.orderid from orders, email where orders.orderid
>= email.orderid and email.checked='no'";
>$result = mysql_query($query) or die("Error: cannot select
>while( $row = mysql_fetch_array($result))
>       {
>       extract($row);
>       $orderid = $row;
>       $query2 = "SELECT * FROM orders WHERE orderid=\"$orderid\"";
>    $result2 = mysql_query($query2) or die("Error: cannot fetch
>    extract(mysql_fetch_array($result2));
>       }
>The SQL works Ok. At least I get no errors now.
>It's my PHP to display the SQL I think I get a result of 8 errors with
>the following message.
>Warning: Wrong datatype in call to extract() in
>/www/u1255/eadmin/eshop_fns.php on line 40.
>Where line 40 is:


maybe the second fetch doesn't return anything because the resultset is
empty? You should assign the second fetch to a variable and test it before
passing it to extract (as with the first fetch):

$row2 = mysql_fetch_array($result2);
if (is_array($row2)) {
        // ...

>What does extract do? I am under the assumption it extracts row
>information so why a datatype error?
>Any pointers?

--------------- [doc] ---------------
int extract ( array var_array [, int extract_type [, string prefix]])

This function is used to import variables from an array into the current
symbol table. It takes an associative array var_array and treats keys as
variable names and values as variable values. For each key/value pair it
will create a variable in the current symbol table, subject to extract_type
and prefix parameters. 
--------------- [/doc] --------------

May I suggest getting the "Camel Book", or at least consult the EXCELLENT
online PHP manual at If you read about
mysql_fetch_array you'll notice the additional optional parameter
"result_type". Since you're going to pass the resulting data to extract it
helps to specify MYSQL_ASSOC as result_type, this will omit the numerically
indexed data from the fetched array, which isn't used by extract() anyway.

   >O     Ernest E. Vogelsinger
   (\)    ICQ #13394035

Reply via email to