1 reply to this topic

[techker]

hey guy im trying to extract from my database the number of clients loggin in on the date selected.

$q3 = "SELECT COUNT(*) AS Number FROM `scan_stats` WHERE 'login_date' = $date_issued";

$res3 = mysql_query($q3);

$row3 = mysql_fetch_assoc($res3)




<?php echo $row3['Number'] ?>

scan_stats table
`id` `member_id` `login_date` `time`

[Orjan]

yes? seems correct for me? except for the apostrophes around login_date, use `, not ' for table and column names as you do at scan_stats