Query from to date with php in mysql

Question

I have a date field in a mysql table formatted like this: Y-m-d.

I want to export every post that has a date between $fromDate and all the way to $toDate I am sure its easy but now i am totaly blocked from ideas.

I am using codeigniter if that helps.

Best Regards Audun

they are like this $toDate = $this->input->post('toDate'); that gives Y-m-d like 2009-03-23. — Audunfr
– Audunfr, Commented Nov 25, 2009 at 13:02

houmam · Accepted Answer · 2009-11-25 13:14:37Z

2

Try building a query similar to this and passing it to mysql_query (assuming your date format in $fromDate and $toDate match the date format of your mysql column)

<?

$query="SELECT * FROM table WHERE date BETWEEN '$fromDate' AND '$toDate'";

?>

answered Nov 25, 2009 at 13:14

houmam

4642 silver badges5 bronze badges

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

Comments

Matt · Accepted Answer · 2016-06-14 21:36:33Z

2

In CodeIgniter documentation about Active Record at http://www.codeigniter.com/userguide2/database/active_record.html, there is a sub-section with title "$this->db->where();".

You can use comparison signs (like !=, <, >, <= and >=) just after the name of the column on which condition(s) is checked. For instance :
$this->db->where('id <', $id);

$array = array('name !=' => $name, 'id <' => $id, 'date >' => $date);
$this->db->where($array);

edited Jun 14, 2016 at 21:36

Matt

75.4k26 gold badges156 silver badges181 bronze badges

answered Feb 8, 2011 at 10:21

Tomfr

211 bronze badge

Collectives™ on Stack Overflow

Query from to date with php in mysql

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