how to solve "mysql_fetch_array() " error

Question

my project partner give me his php project folder to run on my laptop , i am using netbeans and xampp as a cross-platform web server but when i run index.php file ,it will show me this Warning.

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\vekariya\index.php on line 5

so how to solve it .

you have problem in your query or somehow mysql_query() is not returning resource. Check your query and variables. might be missing something. — Gaurav Rai, Feb 22 '17 at 06:42
How can you solve a programming question without the code ?! — user3526204, Feb 22 '17 at 06:43
Try adding an error catch like $db->query(".......") or die("Query Error : ".$db->error); This will tell you why your mysql_fetch_array() (ACtually you should be using Mysqli / PDO) is not working — user3526204, Feb 22 '17 at 06:45

Kishan Oza · Answer 1 · 2017-02-22T07:00:04.400

0

Write this at the first line of your index.php

<?php
error_reporting(E_ERROR | E_PARSE); 
?>

It is warning not error :)

edited Feb 22 '17 at 07:00

answered Feb 22 '17 at 06:47

Kishan Oza

1,665
1
13
38

score 0 · Answer 2 · answered Feb 22 '17 at 07:50

I think there is a problem with your SQL statement, because when there is an error there the statement variable will return a false.

Do you imported the database in phpMyAdmin? Try the SQL statement in the phpMyAdmin SQL console and look, what error you got.

score -1 · Answer 3 · answered Feb 22 '17 at 06:46

Try adding an error catch like

$db->query(".......") or die("Query Error : ".$db->error);

or

mysql_query("....") or die("Query Error : ".mysql_error()); // Since you are using mysql_query)

This will tell you why your mysql_fetch_array() (Actually you should be using Mysqli / PDO) is not working

how to solve "mysql_fetch_array() " error

3 Answers3