$thisday = date("Y-m-d"); $result = mysql_query("SELECT sum(clicks) as dog FROM table1 WHERE date = '$thisday' "); $row = mysql_fetch_assoc($result);
echo $row['dog'];