I'm currently working on having 'artist_id' counted once only
between two dates although they may have visited several
times over that period. The following code works very well
for counting the total number of visits. Any suggestions out there?
$sql = "SELECT * FROM artists_details LEFT JOIN attendance ON attendance.record_id AND attendance.visit_date >= '".$from_date."' AND attendance.visit_date <= '".$to_date."' WHERE attendance.artist_id=artists_details.artist_id"; echo $sql; $result6=mysql_query($sql); $num_rows_ind = mysql_num_rows($result6);