[SOLVED] count question

[Darkmatter5]

I have this query

$query=mysql_query("SELECT COUNT(member_id)
  FROM $dbnameprim.$pagedb
  WHERE mem_username='$username'
  OR mem_email='$email'
  ") or die(mysql_error());

 

Now how can I use this query to get the value of this query into a variable named $count?  BTW if I manually substitute the variables in the query, the query gives me the result I expect.

[rhodesa]

$result=mysql_query("SELECT COUNT(member_id)
  FROM $dbnameprim.$pagedb
  WHERE mem_username='$username'
  OR mem_email='$email'
  ") or die(mysql_error());
list($count) = mysql_fetch_array($result);
echo $count;