Error

[carleihar]

I get this error:

 

An error occurred in script '/home/content/e/q/u/equianadmin/html/htdocs/pages/my_barn.php' on line 21: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given

 

for this line of code:

 

		$row = @mysqli_fetch_array ($r, MYSQLI_NUM);

 

I've also gotten this same error for this line of code:

 

	if (mysqli_num_rows($r) == 1) {

 

What am I doing wrong? Thanks so much!

 

[Garethp]

Well show us what $r is. Man, how can you expect us to help you if you don't give us the basics of what we need.

 

Basically, it wants $r = myqsli_query("Something"); but it's not

[carleihar]

First time:

 

$q = "SELECT COUNT(horse_name) FROM horses WHERE user_name = {$_SESSION['username']}";
	$r = @mysqli_query ($dbc, $q);
	$row = @mysqli_fetch_array ($r, MYSQLI_NUM);

 

Second time:

 

$hn = $_GET['hn'];

$q = "SELECT CONCAT('horse_name, 'user_name') AS info FROM horses WHERE horse_name = $hn";

$r = mysqli_query ($dbc, $q);

if (mysqli_num_rows($r) == 1) {

[mga_ka_php]

from

 

$q = "SELECT CONCAT('horse_name, 'user_name') AS info FROM horses WHERE horse_name = $hn";

 

to

 

$q = "SELECT CONCAT('horse_name, 'user_name') AS info FROM horses WHERE horse_name = '$hn'";

 

see the ' at $hn