You're right, no row was returned by the query when i did tried to fetch it. So
I suppose the next viable thing to do is to figure what went wrong with the
query.
Thanks
CC Zona wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] ("Shahmat Dahlan") wrote:
Hmmm not sure -
You could try to strip out much of the sql by simply using:
$sqlstmt ="SELECT * 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);
#
$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,
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] ("Shahmat Dahlan") wrote:
$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