Counting records by a unique field

[jesushax]

hi below is my code

 

<?php
$notes = mysql_query("SELECT COUNT(*) FROM tblCompanyNotes WHERE UserID='".$ID."' ") or die (mysql_error());
$files = mysql_query("SELECT COUNT(*) FROM tblCompanyFiles WHERE UserID='".$ID."' ") or die (mysql_error());

$CNotes = mysql_fetch_array($notes);
$CFiles = mysql_fetch_array($files);

echo 'You have a total of '.$CNotes.' notes<br />';
echo 'You have a total of '.$CFiles.' files available for download<br />';
?>

 

and it outputs this

 

You have a total of Array notes

You have a total of Array files available for download

 

whats wrong here, can anyone tell me?

 

Cheers

 

 

[cytech]

Maybe:

 

SELECT COUNT(*) as total

 

Then CNotes['total']

[jesushax]

now i have

<?php
$notes = mysql_query("SELECT COUNT(*) as total FROM tblCompanyNotes WHERE UserID='".$ID."' ") or die (mysql_error());
$files = mysql_query("SELECT COUNT(*) FROM tblCompanyFiles WHERE UserID='".$ID."' ") or die (mysql_error());

$CNotes['total'];

$CFiles = mysql_fetch_array($files);
$CNotes = mysql_fetch_array($notes);
echo 'You have a total of '.$CNotes.' notes<br />';
echo 'You have a total of '.$CFiles.' files available for download<br />';

echo $notes;
?>

 

and still, same result

[trq]

$CNotes is an array (hence the name of the function mysql_fetch_array).

 

echo 'You have a total of '.$CNotes['total'].' notes<br />';

[jesushax]

ahh right i see.

 

Thanks!