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

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

my two tables
table1 : col1 = topicid , col2 = topic

table2 : col1 = sentid, col2 = sentence

Cod

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t

Syntax error
hi im having a little trobble with this script
-------------------------------------------------

Class not found error
I am getting Class 'index' not found in Eval function:

//write config

$pat

data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t

Email Script does not reach destination
Hey Guys look at this code snippet :
Code:
//read a line from the file

$myFile = "

Help with ORDER BY
Hello. I would like to order by ascending States, then Cities, then Gyms in the following code, but

Is this Safe or Unsafe?
Hi i made a few pages with lots of peoples help now i just want to know if they are safe or not can