Php Mysql Search Between Two Dates

Question

I've mysql table like this:

id      start_date         username
1       2013-04-04         18
2       2013-03-31         19
3       2013-04-04         19
4       2013-04-02         19 
5       2013-04-03         18

I'm trying to get username where start_date is between 2013-03-31 to 2013-05-01 with following query:

// $from = 2013-03-31 and $to = 2013-03-01 (example)

$search = mysql_query("SELECT username FROM oc_calendar WHERE start_date >'$from' AND 
start_date < '$to'"); 
$re_search = mysql_fetch_array($search);
echo $search_p_id = $re_search['username'];

But It's just print username = 18, It's should be print 18 and 19 number username. why it's doesn't show? Any idea?

Treps · Accepted Answer · 2013-03-15 17:17:06Z

8

Query:

$search = mysql_query("SELECT username FROM oc_calendar WHERE 
start_date between '$from' AND '$to'");

And you need a while-loop to display more that one username and a correct SQL-query (see above):

while($re_search = mysql_fetch_array($search)) {
  $re_search['username'] . '<br>';
}

answered Mar 15, 2013 at 17:17

Treps

7983 gold badges13 silver badges29 bronze badges

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

Comments

Vatev · Accepted Answer · 2018-08-23 10:54:08Z

1

SELECT username FROM oc_calendar WHERE start_date between '$from' AND '$to'

edited Aug 23, 2018 at 10:54

Vatev

7,5801 gold badge36 silver badges42 bronze badges

answered Mar 15, 2013 at 17:11

Farhadix

1,4572 gold badges13 silver badges26 bronze badges

Comments

Angel · Accepted Answer · 2013-03-15 17:09:53Z

0

You can use this query :

$search = mysql_query("SELECT username FROM oc_calendar WHERE start_date between '$from' AND '$to'");

Regarding the condition that you are using :

where start_date >'$from'

your fromdate = 2013-03-31 so the above mentioned condition is not true for username = 19. Instead you should use

where start_date >= '$from' and startdate <='$to'

answered Mar 15, 2013 at 17:09

Angel

3331 silver badge5 bronze badges

1 Comment

Babu Ahmed Over a year ago

Well, your update query is not show the 18 and 19 number username.

Collectives™ on Stack Overflow

Php Mysql Search Between Two Dates

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related