[SOLVED] Count

[DrTrans]

Getting the same count everytime

 

$visitquery = mysql_query("SELECT COUNT(*) FROM visitors WHERE ownerkey = '$uuid' & region = '$selected' AND `date` < DATE_ADD(CURDATE(), INTERVAL +7 DAY)", $connect);
$row9 = mysql_fetch_array($visitquery); 
$visitoramount = $row9[0];
 print "[$visitoramount] visits in the last 7 days!";

If $selected = "Blah" it gives the count as " 8"

if $selected = "Dumb" it gives the count as "8" ... Al though there is no "Dumb" in the db.

 

Sorry if my explaining is off. Just dont know another way to explain it easier.

[DavidAM]

I don't think you can use the '&' in a WHERE clause, change that to AND:

$visitquery = mysql_query("SELECT COUNT(*) FROM visitors WHERE ownerkey = '$uuid' AND region = '$selected' AND `date` < DATE_ADD(CURDATE(), INTERVAL +7 DAY)", $connect);

 

By the way, shouldn't that be "date > CURDATE - 7" ?  I mean if you are looking for the number of visits in the past seven days.  Your query specifies all dates less than NEXT WEEK; that would probably be all of them.

[DrTrans]

Gives result of "0" all across . And also did that -7 days.

 

 

[DavidAM]

Check the values of $uuid and $selected before the query is executed.

 

Check your database using those values and look at the dates (select *).

 

Is there actually data there that should be counted?