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

Pls help with PHP
Pls can anyone direct me on how to create a user account for a customer. For example i want know if

PHP switch function help
Hi, I am trying to create a search function for a directory website. On the search function on html

Get last modified date of web page
Hai All,

In php how can i get last modified date of a give web page . I have tried to g

Check Date/Time in PHP
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h

why is it over writing
Code: $filepaths[] = $_FILES['new_image'];
foreach ($filepaths as $filepath)
{
$imagename =

Material Issuing for receiving batch
Dear All experts in MM/ PP,

Material issuing from main stores to factory is currently usi

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

Concatenate two strings ???
I have string one $string1 and another $string2.

How to concatenate (add) both of them $str

noob cURL help
I have a pretty basic form that I need to cURL post to a file in my includes folder (includes/login.

elseif help!
OK so I'm new to the site, as well as PHP altogether (Trying my hand at managing an online RPG) and