Month()

PHP
1

Hi again!
Im having trouble with month wise record from database.

I wasent sure how to get the date of the record , so i added a column in my table like:

Field:date
Type: timestamp
Attributes:ON UPDATE CURRENT_TIMESTAMP
Default:CURRENT_TIMESTAMP

My query is :
$month=mysql_query(“SELECT COUNT(*) FROM client WHERE MONTH(date) = MONTH(CURDATE())”);

I get output “Resource id #6” when i try to print $month.
Is anything going wrong with my query or table field??
Please help me.

2 
<?php

$query="SELECT COUNT(*) AS the_count FROM client WHERE MONTH(date) = MONTH(CURDATE())"

$result=mysql_query($query);

$row = mysql_fetch_array($result, MYSQL_BOTH);

$the_count=$row['the_count'];

?>

mysql_query returns an id for a result set if the query went ok, mysql_fetch_array then returns a row in a result set (where a result set has multiple rows, they can be grabbed in turn using a while loop.