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

Email to a friend script problems
I have this send-to-a-friend script with 2 issues:


1) When you open the form popup on a p

insert Multiple rows into the table from that table data
Hi All,

I have a requirement like to insert mulitple rows into the table from that

Quick variable question
hey guys/gals,
im trying to write a php script and it works fine as i have it, but i need to set

Loops and Classes
I am making a template system and everything seems to be going well up until I have to loop in a var

Javascript form submit and radio buttons?
When this form is submitted, it is automatically resubmitted using JS.

All my fields are carr

IP Logger for Voting Script
Can anybody help me place an IP logger into my voting script?
I know that maybe it is not as secu

simple php table loop
Hi all,

I've the following code

<?php // Create category options

Sql and php order list script problems
Hi im having a few problems with trying to get the coding right on a orders list ive done (or trying

php web service error
hey guys,
I'm working on a project requires the use of web services. I've been trying a few tutor

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s