PHP MYSQL select * with this value with between these dates

Question

I'm trying to select a list of customers that have entered a specific voucher code, within certain dates.

Here is my code with my latest attempt:

$result = mysql_query(
          "SELECT COUNT(members.voucher_code)
           FROM members WHERE YEAR(date_started) = 2014
           members.voucher_code = 'new'");
$count = mysql_result($result, 0);
echo $count;

I would like it to show all voucher codes that have the value of new which have been submitted between 01/01/14 - 31/12/14

I've tried a number of things but I can't seem to get it working correctly.

What format is the column 'date_started'? – Feb 04 '14 at 11:50 — , Feb 04 '14 at 11:50
`where year(date_Started) = 2014 and voucher_code = 'new'` – Raphaël Althaus Feb 04 '14 at 11:52 — Raphaël Althaus, Feb 04 '14 at 11:52
Use `AND` keyword after 2014... – user2727841 Feb 04 '14 at 11:52 — user2727841, Feb 04 '14 at 11:52

score 2 · Answer 1 · edited Feb 04 '14 at 11:55

2

Correct query should be like:

SELECT COUNT(members.voucher_code)
FROM members
WHERE date_started > 'from_date' AND date_started < 'to_date'

Here from_date and to_date is the date passed by you.

edited Feb 04 '14 at 11:55

Vivek Jain

3,811
6
30
47

answered Feb 04 '14 at 11:53

Manish Kumar

571
3
15

score 1 · Accepted Answer · answered Feb 04 '14 at 11:55

1

Try this :

SELECT COUNT(members.voucher_code) 
FROM members 
WHERE 
   members.voucher_code = 'new' AND
   date_started BETWEEN '2014-01-01' AND '2014-12-31'

answered Feb 04 '14 at 11:55

RiggsFolly

93,638
21
103
149

score 0 · Answer 3 · edited Feb 04 '14 at 11:57

0

You may try:

$result = mysql_query("SELECT COUNT(members.voucher_code)
FROM members
WHERE YEAR(date_started) = 2014 and members.voucher_code = 'new'");

You are missing the AND condition in your query.

edited Feb 04 '14 at 11:57

Linga

10,379
10
52
104

answered Feb 04 '14 at 11:52

Vivek Jain

3,811
6
30
47

PHP MYSQL select * with this value with between these dates

3 Answers3