Warning: mysql_fetch_array() expects parameter

[Bhima]

I have problem at

 

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\big\operator\pemesanan.php on line 53

 

<?php

$qdatapesan = mysql_query("SELECT member.id_member,member.nama_depan,pemesanan.nama_menu,pemesanan.tanggal,pemesanan.jam,pemesanan.harga FROM menu, pemesanan, member WHERE menu.id_menu = pemesanan.id_menu AND member.id_member = pemesanan.id_member ORDER BY pemesanan.jam");

while($datapesan=mysql_fetch_array($qdatapesan))

{//print_r ($datapesan);

 ?>

 

where the error ? please help

[SurvivorZ]

Hi.

 

mysql_ functions are deprecated and will be removed relatively soon.  Convert to PDO instead:

 

$pdo = new PDO("mysql:host=localhost;dbname=$dabaseName", $dbUsername, $dbPassword);

$sql = <<<SQL
SELECT member.id_member, member.nama_depan, pemesanan.nama_menu, 
    pemesanan.tanggal, pemesanan.jam, pemesanan.harga 
FROM menu, pemesanan, member 
WHERE menu.id_menu = pemesanan.id_menu 
    AND member.id_member = pemesanan.id_member 
ORDER BY pemesanan.jam
SQL;

$stmt = $pdo->prepare($sql);
$stmt->execute();

while($datapesan = $stmt->fetch())
{
    print_r ($datapesan);
}
 

Edited March 30, 2013 by SurvivorZ