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

$get problem
Hi Guys ...

can you please tell me what i am doing wrong here
Code: <?php

How could I do this?
Ive got a simple lottery game, and am using an sql database to keep track of the numbers bought. But

returning data from an ssh2_exec()
here's what i got.


$conn = ssh2_connect($this->_host);
ssh2_auth_password($c

CHMOD script
Hi,

I need a script to read all files in a folder and set to 777.

Can anyone help out

script and html conflict in trying to create a header.
I have an error is occurring because of an html webpage with a "php require" at the top of

Hyperlink is adding an extra gap to variable
Hi, here's my problem..

I have a php generated page with a hyperlink which opens in a new win

UTL File problem
Hi
I have a file in certain path with the following permissions (The file is a dummy file witho

Mysterious Timeouts
I've deployed a few simple AJAX-enabled web page to a local server that is accessed through the Inte

Inserting a variable in a link
I have this code that I want to insert for my own variable but I have no idea how. This is what I wa

getting weird error..
okay, I'm getting an error on this particular function, something about the syntax in the mysql LIMI