Count

Posted on 16th Feb 2014 07:03 pm by admin

Getting the same count everytime

Code:
$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.

Your Answer:

Login to answer

Other forums

whats wrong with my code please help!!!
this is the error


Warning: mysql_close(): supplied argument is not a valid MySQL-Link res

void* and sizeof()
Hi,

Using void* and sizeof is it possible to get the value of the object ?

I understan

Securing a user input - need some confirmation
Hello All,

I am in the process of recoding a large proportion of an e-commerce site, one of t

Email Script does not reach destination
Hey Guys look at this code snippet :
Code:
//read a line from the file

$myFile = "

Pagination
Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a quer

checkbox update
I am having a brain fart right now and i cant remember how to do this. if anyone could help that wou

Email logic not working
I would like to send an email using the php email() function then if it does execute i.e sends i wou

Cursor statement failed with errors
Following statement failed with the errors.

cursor proj_cursor1 is (select projectID from

tell csv import script to ignore blank rows?
Hi i have the below script but i get an error if a row is blank ie a return in the csv file at the e

Solution to the FindControl problem
I have seen may posts about having problems with the FindControl method. Most seem to come about bec