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

Will an XHTML DOCTYPE interfere with my PHP if I'm not experienced enough?
I've read this article here: http://friendlybit.com/html/why-xhtml-is-a-bad-idea/

In a nutshe

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi

PHP Programming error. Please help!
Hi there,

Am making a website for a friend and have encountered a problem that i need fixing

Undefined variable: adHTML
Hello:

While checking my site error logs, I've noticed one repetitive error that fills the lo

Reading waves
Hi,

I am trying to find a way of finding the highs and lows on a graph line, the line points

How to generate a text file using php...?
Hi,
Can anyone give me code to generate a text file using php


Thanks in advance

Is there a quick way to do this?
Hi all,

I need to create a mysql table from php that goes a little something like this

array empty
Hiya peeps,

Ok here is the codes.

order.php

Code:

Help with syntax
Hi all!

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

File upload issues
Hi Guys,

Can anyone see any issues with this code:
Code: $setImage= 'productimages/' . dat