How do I count non-null variables in php database?(SQL)
This is my existing code and database in the picture:
$jack5 = mysql_fetch_array(mysql_query("SELECT * FROM z3 WHERE ID='$users_Names' AND Score IS NOT NULL "));
echo $jack5;
when I echo the result, I get:
Notice: Array to string conversion etc... error
I'm new to this so any help is appreciated! z3 is my table name Score is my column name