Easy query question

[Jakobi]

Hello,

I am new to this but here is the question.

I have this query that counts rows in my database.

SELECT Count() FROM `files` WHERE `added`=current_date

Which works.

Now what is the standard php code that would display that?

Thanks.

[Kalyse]

This is possibly the longest way of doing it, but its the simplest way to follow

$query = "SELECT Count(*) as `count` FROM `files` WHERE `added`=current_date";
$result = mysql_query($query);
$row = mysql_fetch__row($result);
$count = $row['count'];
echo $count;