MySQL query print help

[Hikaru12]

$result = mysql_query("SELECT Count(*) FROM myanimes WHERE Status='To Watch'");	while($row = mysql_fetch_array($result))	{	 echo "$row[Status]";  	}	

The above works fine in a SQL statement issued directly but when I try to print it it does not work claiming an "Undefined Index". Is it possibly because it's out of range?

 

Status is set as a VARCHAR field in the database. I've also tried mysql_fetch_row because it only returns back a single row but I get the same error.

 

If I try to print it directly it claims an array to string error which makes sense since PHP understands tables as associative arrays. 

 

NOTE: Yes, I am aware of the SQL injection. This is a low stakes program that will be loaded on a Raspberry Pi and will get updated in the future.

[mantylt]

@Hikaru12 follow your own topics.

I might be wrong, but you are selecting count(*) which is one result, integer, you don't need cycle for that.

$result = mysql_query("SELECT Count(*) FROM myanimes WHERE Status='To Watch'");$row = mysql_fetch_array($result);    echo $row[0];    

[Hikaru12]

Thanks for the help. I should have known to use the index since it's a single value in an "array"

[Guest]

Thanks for the help. I should have known to use the index since it's a single value in an "array"

 

If you want to use the column name, you must fetch with "mysql_fetch_assoc" and use quotes for the index, e.g. $result['Status'].