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

PHP Script runs on CLI but not through web browser
I am running into an issue that I just can't seem to find the answer to. I have a Windows Server 200

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c

Help with syntax
Hi all!

The $bridge variable is not getting passed while it is contained in the line below:

undefined offset help
Hi All,

I kept getting undefined offset PHP notice for a simple for loop. For eg
$va = arr

understanding functions and classes
Code: [Select]
class person {
var $name = "Jimmy Goe";

function get_nam

Internal Server Error issues
This has been bothering me for weeks and I've been trying to solve it without asking for help, but e

Linking with Foreign Keys
I have been getting an erro when I try and link:

create table Faculty_Specialty (I_Name v

How to use Ajax to verify data on a DB ?
Hello everyone, well i want to know how to check a value if it exists or not on a Data base and capt

b+ tree
Hi
can every body help me about b+ tree ?(insert & delete)

help with image text
Hi ...

see i need the text of the name and number to start in the center and always be in the