MySQL + PHP query with date causing issues

Question

I use this code, which should return me total amount (sum) of clients registrered/joined in last 7 days (sun-sat).

  require '../dbconnect.php';

  $result = full_query ('SELECT COUNT(*) FROM tblclients WHERE date between \'' . date ('Y-m-d', mktime (0, 0, 0, date ('m'), date ('d') - 7, date ('Y'))) . '%\' AND \'' . date ('Y-m-d') . '%\'');
  $data = mysql_fetch_array ($result);
  echo $data;

For some reasson, I get no results. Please help.

Why do you have the %'s?

jValdron
– jValdron

2011-12-22 16:43:28 +00:00
Commented Dec 22, 2011 at 16:43 — jValdron
– jValdron, Commented Dec 22, 2011 at 16:43

Ben D · Accepted Answer · 2011-12-22 16:46:09Z

1

For one, you're trying to echo an array. Try print_r($data)

answered Dec 22, 2011 at 16:46

Ben D

14.6k3 gold badges47 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user894932 · Accepted Answer · 2011-12-22 16:46:13Z

1

familarize yourself with the

       now()

function in mysql

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_now

answered Dec 22, 2011 at 16:46

user894932

Collectives™ on Stack Overflow

MySQL + PHP query with date causing issues

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related