Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in

Question

I always get this error when i run my code

0:
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\fyp\admin_vieworders_details.php on line 12
Query Failed!You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Here is my database

table order_detail{Order_Detail_ID(PK), Order_Quantity, Sub_Total}

table order{Order_ID, Order_Date, Order_Time, Delivery_Charge, Delivery_Name}

Here is my code

$orderid =@$_GET["id"];  
$detail = "SELECT 
                order.*,
                order_detail.Order_Quantity,
                order_detail.Sub_Total
            FROM `order` AS a, `order_detail` AS b
            WHERE order_detail.Order_ID = `order`.Order_ID AND order_detail.Order_Detail_ID=$orderid";

$result = mysql_query($detail);
$row = mysql_fetch_assoc($result);

        if($result === FALSE)
    {
            die("Query Failed!".mysql_error().$result);
    }

**Warning:** `mysql_*` functions are deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the [MySQLi](http://www.php.net/manual/en/book.mysqli.php) or [PDO_MySQL](http://www.php.net/manual/en/ref.pdo-mysql.php) extension should be used. — Fabien TheSolution, Aug 31 '13 at 17:15
have you tried echo `$orderid` before this query if it contain value ? — echo_Me, Aug 31 '13 at 17:17
@Jess Tan: Seriously, please take a look to the right column that is labeled **Related**. We know everybodies problem is special but this one is just a common mistake. — hakre, Aug 31 '13 at 17:18
I see this type of question all the time, you should read [common database debugging for PHP and MySQL](http://jason.pureconcepts.net/2013/04/common-debugging-php-mysql/). — Jason McCreary, Aug 31 '13 at 17:22

score 1 · Answer 1 · answered Aug 31 '13 at 17:18

Check mysql_error() before calling mysql_fetch_assoc(). Your query failed and the query function returned false.

$result = mysql_query($detail);
if (!$result) {
    die("Error: ".mysql_error()); // Note: raw database errors are useless for users
                                  // better log the error an create a "nice" error page
}
$row = mysql_fetch_assoc($result);

Or such might get you started.

Fabien TheSolution · Answer 2 · 2013-08-31T17:37:01.890

You seem to have an error in your query :

Try :

$detail = "SELECT 
                a.*,
                b.Order_Quantity,
                b.Sub_Total
            FROM `order` AS a, `order_detail` AS b
            WHERE b.Order_Detail_ID = a.Order_ID AND
                  b.Order_Detail_ID=$orderid";

instead of

$detail = "SELECT 
                order.*,
                order_detail.Order_Quantity,
                order_detail.Sub_Total
            FROM `order` AS a, `order_detail` AS b
            WHERE order_detail.Order_ID = `order`.Order_ID AND
                   order_detail.Order_Detail_ID=$orderid";

And also...

$orderid =$_GET["orderid"];

instead of

$orderid =@$_GET["id"];

score 0 · Answer 3 · answered Aug 31 '13 at 17:22

0

change this

 $orderid =@$_GET["id"];

to

 $orderid =$_GET['id'];

answered Aug 31 '13 at 17:22

echo_Me

36,552
5
55
77

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in

3 Answers3