PHP: Warning: mysql_fetch_assoc() expects parameter 1 to be resource

Asked Mar 01 '14 at 13:41

Active Mar 01 '14 at 13:45

Viewed 23 times

Hi I am getting an error in the report

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/orangeco/public_html/service/store/allreports.php on line 161

Someone helped me to generate the report but when I copied this file and executed I am getting the above error.

Below is the line no 161

<?php while ($findreport = mysql_fetch_assoc($reportsq)) {
    $invoicesSql = "SELECT S.stock_title,II.cart_price,QL.laborprice,II.cart_type
                    FROM invoice_items II
                    LEFT JOIN quicklabor QL
                    ON II.labor_desc = QL.labordesc
                    LEFT JOIN stock S
                    ON II.cart_stock_id = S.stock_id
                    WHERE II.invoice_id = '".$findreport['invoice_id']."'";

    $invoicesq = @mysql_query($invoicesSql, $rs_connect);

    while ($findinvoiceport = mysql_fetch_assoc($invoicesq)) {
        $findreport['invoices'][] = $findinvoiceport;
    }   

?>

Please help me

edited Mar 01 '14 at 13:45

Sirko

69,531
19
142
174

asked Mar 01 '14 at 13:41

Sridhar

– Sridhar Mar 01 '14 at 13:44
$reportsq is not null ? – esdebon Mar 01 '14 at 13:45
You have called `mysql_fetch_assoc` twice, which one is causing the problem? – Tom Fenech Mar 01 '14 at 14:00
first one which line 161 – Sridhar Mar 01 '14 at 14:14
please show a few lines before in your code – Mikpa Mar 01 '14 at 15:53

PHP: Warning: mysql_fetch_assoc() expects parameter 1 to be resource

0 Answers0