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

Match stored value with the current value in a loop
Hello,

I have a MySQL db were I store articles in.

I have a form to fill these article

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

help with email script...
hey

I need help with my mail script

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

SQL Injection
In my attempts to protect my database from mySQL injection I have created another problem for myself

Batch update record with Pagination
Hoping someone can help me with this issue I'm having, im trying to batch update records from a resu

Show specific day of the week
I have been racking my brain trying to get this function to work properly and it is doing so for eve

problems with search form numerical "between" sending by php
I am trying to display the results of a search, on a sql database, on a web page. I set up html &quo

Paypal
Hi all,

I have an advanced basic knowledge of php

I want to try something new for a s

How do I get the row number from from an sql table query
Hi all

I have a table that I query and it returns a number of rows.
mysql_num_rows($query)

Take info from one coloum and move to another
Hi all,

I have this:
Code: [Select]$array = "SELECT stock_id FROM stocks WHERE stock_