error while executing mysqli fetch

Question

I've a php, which displays rows from a MySQL DB, sql query is like this

$cat = 'Available'
$sql = "SELECT title, location, date, matter, userName, emailId, phone FROM ad_usr WHERE type =".$cat;

query works fine in mysql.

but when try to execute following codes

$result = mysqli_query($link, $sql);
$row = mysqli_fetch_assoc($result);

gives an error like this

"mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given"

but when I use $cat serialNo instead of type and $cat as an integer then it works fine

We get hundreds of questions like this every day. You'll soon get half a dozen answers spotting the syntax error. Please don't just copy the correct code and go on—learn how to do error checking yourself. — Álvaro González
– Álvaro González, Commented Dec 17, 2013 at 11:50

Krish R · Accepted Answer · 2013-12-17 11:47:36Z

2

You have missed to close the "

 $sql = "SELECT title, location, date, matter, userName, emailId, phone FROM ad_usr WHERE type ='$cat'";

You can able to find these errors yourself, if you use editor like eclipse and etc

answered Dec 17, 2013 at 11:47

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

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

Comments

Mehdi · Accepted Answer · 2013-12-17 11:48:54Z

0

change to

$cat = "Available";
$sql = "SELECT title, location, date, matter, userName, emailId, phone FROM ad_usr WHERE type ='$cat'"

answered Dec 17, 2013 at 11:48

Mehdi

6595 silver badges18 bronze badges

Comments

Álvaro González · Accepted Answer · 2013-12-17 11:49:12Z

0

You don't need to guess. The Quick Start Guide has several usage examples. Please have a look at Executing statements; most examples listed there show how to do error checking.

answered Dec 17, 2013 at 11:49

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

Collectives™ on Stack Overflow

error while executing mysqli fetch

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related