PHP Syntax Help on Mysql Select statement

[TheFilmGod]

<?php
// Yeseterday
$date = date("Y-m-d", strtotime("-1 days"));
$result = $mysqli->query("SELECT stats_session WHERE date = $date");
$activity[1] = $result->num_rows;
?>

 

when I echo $activity[1]; nothing happens. It should echo 117.

[genericnumber1]

try adding or die(mysql_error()); to the end of your query.

[Maq]

Echo $result->num_rows