Bhima Posted March 30, 2013 Share Posted March 30, 2013 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 Link to comment https://forums.phpfreaks.com/topic/276320-warning-mysql_fetch_array-expects-parameter/ Share on other sites More sharing options...
SurvivorZ Posted March 30, 2013 Share Posted March 30, 2013 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); } Link to comment https://forums.phpfreaks.com/topic/276320-warning-mysql_fetch_array-expects-parameter/#findComment-1421942 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.