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

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

Shuffle between users ??
I have multiple $users in table. I need to send them $message.

I need to send the next messag

Using unserialize()
Hi there.

I have some data in my database that is serialized.

e.g.

a:2:{i:0

Sort a two dimensional array.
Hi. I've set up a two dimensional array that reads as follows:

Code: $modifiedData = array(

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't work

Which par

php slowing my site?
Hi all,

I think that one of the reasons that my site doesn't work fast is that the code is ve

Display last record first.
I need some help how put the last record first and first record last.

Thanks

Code: &am

trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an arra

Set Categories
I am creating a submission form for somebody to come in and submit products. These products are sep