Error Msg: Wrong data type when performing "extract()"
| From: | Shahmat Dahlan | Date: | Thu, 19 Apr 2001 02:40:56 +0000 |
| Subject: | Error Msg: Wrong data type when performing "extract()" | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8684@lists.php.net to get a copy of this message | ||
$sqlstmt ="SELECT stock_in.id, equip.equip_type, ";
$sqlstmt.="equip.brand, equip.model, ";
$sqlstmt.="vendor.name, stock_in.po_no, ";
$sqlstmt.="stock_in.vendor_sales_no, stock_in.cust_po_no, ";
$sqlstmt.="stock_in.serial, stock_in.warranty, stock_in.date_received,
";
$sqlstmt.="stock_in.remark, stock_in.timestamp ";
$sqlstmt.="FROM stock_in, equip, vendor ";
$sqlstmt.="WHERE equip.id=equip_id and vendor.id=vendor_id and
equip.id='$id' ";
$sqlstmt.="ORDER BY equip.id ASC";
# print $sqlstmt;
$result=mysql_query($sqlstmt);
# print $result;
$row=mysql_fetch_array($result)
extract($row);
If I do the above, I get the results below:
Warning: Wrong datatype in call to extract() in
E:\winnt\temp\stock_in.php on line 39
I've went through the query, and it seems alright. It worked previously,
now all of a sudden it doesn't work anymore.. Can anyone help me out.
Thanks in advance.
Shahmat