$sql = 'SELECT COUNT(`ip`) FROM `stats` WHERE `date`="'.$date.'"'; echo mysql_result(mysql_query($sql));