mysqli_fetch_array keep getting error

Question

$q = intval($_GET['q']);

$con = mysqli_connect('localhost','root','','my_db');
  if (mysqli_connect_errno()) {
  echo "Fail to connect :".mysqli_connect_error();
  }

mysqli_select_db($con,"my_db");
$sql="SELECT * FROM ajax WHERE id = '".$q."'";
$result = mysqli_query($con,$sql);

echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Age</th>
<th>Hometown</th>
<th>Job</th>
</tr>";

while($row = mysqli_fetch_array($result)) {
  echo "<tr>";
  echo "<td>" . $row('Firstname') . "</td>";
  echo "<td>" . $row('Lastname') . "</td>";
  echo "<td>" . $row('AGE') . "</td>";
  echo "<td>" . $row('Hometown') . "</td>";
  echo "<td>" . $row('Job') . "</td>";
  echo "</tr>";
  echo "</table>";
}
mysqli_close($con);

I keep getting this error :Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\abc\getuser.php on line 22

I apologize in advance if there is already an answer to this simple problem, I am new at coding and I have spent quite some time reading other similar questions but still couldn't solve this problem. Thx in advance.

possible duplicate of mysql_fetch_array() expects parameter 1 to be resource (or mysqli_result), boolean given — Marcin Orlowski
– Marcin Orlowski, Commented Sep 2, 2014 at 9:51
i think your query is not runnig properly. what is yout id column data type in database? so the $result varaible will always intialized to 0 — Aksh
– Aksh, Commented Sep 2, 2014 at 9:53

GHugo · Accepted Answer · 2014-09-02 09:51:44Z

2

As specified, the argument $result is boolean, not a mysqli_result. In case of error in your SQL request, the function mysqli_query returns false.

You should see why their is a problem with your request by calling mysqli_error just after your mysqli_query if $result is false.

answered Sep 2, 2014 at 9:51

GHugo

2,70417 silver badges16 bronze badges

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

1 Comment

Vantablack Over a year ago

Thank you very much, called mysqli_error and it return "Unknown column 'id' in 'where clause'", turns out there's no column 'id', my column is 'pid'. Solved. Thx.

mircea · Accepted Answer · 2014-09-02 22:25:42Z

0

you could try

$sql=mysqli_query("SELECT * FROM ajax WHERE id = '".$q."' ");

echo "<table border='1'>
.......

while($row = mysqli_fetch_array($sql)) {

answered Sep 2, 2014 at 22:25

mircea

55 bronze badges

Collectives™ on Stack Overflow

mysqli_fetch_array keep getting error

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related