Categories: MySQL

mysql_fetch_array() expects parameter 1 to be resource, boolean given

Share

Trying to select data from a MySQL table, but getting the error messages:

mysql_fetch_array() expects parameter 1 to be resource, boolean given?

– This may happen for various reasons like both the mysql_* and the mysqli extension will return false from their query functions.

– Using a die() you can get a little to much.

– Use mysql_error() which reports any errors that MySQL encountered while performing the query.

– If you have a syntax error in your query you can check with tools like phpMyAdmin.

– A missing quote around the mysql query or a value can cause a failure.

– Do not mix mysqli_* and mysql_* functions.

– Make sure you are escaping your all values.

Recent Posts

Overview of Reputation, Services, and Features of IplWin

IplWin stands as a reliable and enthralling platform for Indian punters, offering a captivating blend…

1 day ago

Blogging Brilliance: Driving Traffic and Engagement with Quality Content

Introduction In today's online age, consumers are constantly bombarded with information. They crave valuable content…

2 days ago

How Assisted Living Gives Seniors More Freedom

In today’s rapidly aging society, finding a living situation that provides older adults with both…

2 days ago

Should you go for a Refurbished Mac?

If you wish to purchase a Mac, then it is strongly suggested to consider purchasing…

2 days ago

How Many Types of Bits are Used in Drilling Operations?

Oil drilling is a complex process that involves several components, including the drilling bit. The…

3 days ago

Best Watches to Match Your Business Look

Watches can be more than a fashion. They can be a symbol, especially in the…

3 days ago