mysql_fetch_array error - Not a valid MySQL result resource

Question

I am very new to PHP, trying to write a script which connects to a MySQL database and simply displays the contents in list format under each heading;

My table contains an ID (AutoIncrement), FName, SName & EAddress fields.

The database is called iphonehe_MGFSales and the username is iphonehe_MGFSale - I have added the user to the DB with full privileges.

I am trying to establish my connection to the DB using the mysql function with this code;

mysql_connect ("localhost", "iphonehe_MGFSale", "xxxxxxx") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("iphonehe_MGFSales");

The table I have created is called MGFSales DB. I am using this code to attempt to build the query;

$query = mysql_query("SELECT * FROM MGFSales_DB");

And finally I am trying to display the results using the following code;

while ($row = mysql_fetch_array ($query)) {
echo "<br /> ID: " .$row['ID']. "<br /> First Name: ".$row['FName']. "<br /> Last Name: ".$row['LName']. "<br /> Email: ".$row['EAddress']. "<br />";
}

I have named the file index.php and uploaded to my server, when running I get the following error 'Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/iphonehe/public_html/pauldmorris.co.uk/mgf/index.php on line 16'

Anyone point me in the right direction? Line 16 of my code seems pretty tight from what I can see, am i overlooking something? Thanks

It was going to suggest the examples in the PHP manual page but most of them fail to do proper error checking :( — Álvaro González
– Álvaro González, Commented Jul 26, 2011 at 12:23

Jason Aller · Accepted Answer · 2018-06-14 21:45:34Z

7

The error is in mysql_fetch_array line only, correcting this should be first step in troubleshooting.

change mysql_fetch_array to

mysqli_fetch_array

becuase the latest updates in mysql or php does not accept mysql but accepts only mysqli. Also change everywhere mysql to mysqli in your code.

edited Jun 14, 2018 at 21:45

Jason Aller

3,66028 gold badges43 silver badges40 bronze badges

answered May 10, 2018 at 18:34

lovenish

711 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:08:46Z

4

this is because of null resource found in $query.. you need to check this like below code

$query = mysql_query("SELECT * FROM MGFSales_DB"); or die("Error: ". mysql_error(). " with query ");

if(mysql_num_rows($query) > 0 ){
 while ($row = mysql_fetch_array ($query)) {
echo "<br /> ID: " .$row['ID']. "<br /> First Name: ".$row['FName']. "<br /> Last Name: ".$row['LName']. "<br /> Email: ".$row['EAddress']. "<br />";
 }
}

OR you can also refer this link

Try this may help you.

Thanks.

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Jul 26, 2011 at 12:18

Chandresh M

3,4932 gold badges27 silver badges48 bronze badges

1 Comment

Paul Morris Over a year ago

The error message now changes to Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/iphonehe/public_html/pauldmorris.co.uk/mgf/index.php on line 16

Mat · Accepted Answer · 2011-07-26 12:18:11Z

1

mysql_query returns false when it fails, which will produce the error you're getting during mysql_fetch_array.

Please add some error checking to your code, and print out/log the error messages - can't help any more than that without knowing what the source error is.

answered Jul 26, 2011 at 12:18

Mat

208k41 gold badges407 silver badges423 bronze badges

1 Comment

Paul Morris Over a year ago

Ok, thanks Mat. I guess I will now go and learn about error logging and how to do it ha

Scott C Wilson · Accepted Answer · 2011-07-26 12:19:17Z

1

Check the return code on mysql_select_db.

answered Jul 26, 2011 at 12:19

Scott C Wilson

19.7k11 gold badges64 silver badges88 bronze badges

Comments

Rukmi Patel · Accepted Answer · 2011-07-26 12:26:50Z

1

You should not apply mysql_fetch_array directly..

you should first check for data ..

if(mysql_num_row($query)>0){
   your code   
}
else{
   echo 'it brings no data....';
}

it checks if there is no data then it will execute else block other wise you will have smooth execution ...

answered Jul 26, 2011 at 12:26

Rukmi Patel

2,5619 gold badges29 silver badges42 bronze badges

1 Comment

Paul Morris Over a year ago

Altering my code to incorporate the above changes the error message to Fatal error: Call to undefined function mysql_num_row() in /home/iphonehe/public_html/pauldmorris.co.uk/mgf/index.php on line 16

Collectives™ on Stack Overflow

mysql_fetch_array error - Not a valid MySQL result resource

5 Answers 5

Comments

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related