Use of BETWEEN function from MYSQL database

Question

I am an amateur programmer and have recently been facing a challenge.

I am trying to select a data between range of dates but despite numerous attempts have been unsuccessful. Can someone help me with the code of pulling up data between date ranges.

My code is:

<?php $tdate = $_POST['toDate']; $fdate = $_POST['fromDate']; mysql_connect("localhost","user","pass") or die("Couldn't connect!"); mysql_select_db("db_name") or die("Couldn't find db"); $data = mysql_query("SELECT * FROM db_table BETWEEN saledate '$tdate' AND '$fdate' "); $result = mysql_fetch_array($data); if (!$result) { echo "No result"; } else { echo $result; } ?>

dynamic · Accepted Answer · 2011-06-07 22:27:41Z

3

You shouldn't do Query like that. Use PDO.

Regarding your SQL is wrong. The right is:

$data = mysql_query("SELECT * FROM db_table WHERE saledate BETWEEN '$tdate' AND '$fdate' ");

answered Jun 7, 2011 at 22:27

dynamic

48.2k56 gold badges163 silver badges236 bronze badges

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

4 Comments

darsh Over a year ago

Thanks yes123 that helps, since I am a really new programmer what command shall i use to display the entire data between these two dates on the page.

darsh Over a year ago

I am sorry i was unable to understand as I am not to that stage to understand the link. I am at a very basic level. However, if I am using mysql_num_rows function its showing me 2 and mysql_fetch_array it results array. Kinda confused..

dynamic Over a year ago

@Darsh: you should force yourself to use PDO, it's simpler than it may look at first sight

darsh Over a year ago

i haven't started programming with objects in PHP. Shall look more into it. Thanks

Ash Burlaczenko · Accepted Answer · 2011-06-07 22:28:47Z

2

You sql should be this

SELECT * FROM db_table WHERE saledate BETWEEN $tdate AND $fdate

answered Jun 7, 2011 at 22:28

Ash Burlaczenko

25.6k16 gold badges70 silver badges103 bronze badges

1 Comment

darsh Over a year ago

Thanks Ash that helps, since I am a really new programmer what command shall i use to display the entire data between these two dates on the page.

Phphelp · Accepted Answer · 2011-06-07 23:35:34Z

In your code, instead of

$result = mysql_fetch_array($data); if (!$result) { echo "No result"; } else { echo $result; }

write the following code.

while($result=mysql_fetch_array($data)) { echo $result['Fieldname1']; ...... ...... echo $result['Fieldnamen']; }

In place of fieldname, write the fields from your table. The fields you want to display.

Collectives™ on Stack Overflow

Use of BETWEEN function from MYSQL database

3 Answers 3

4 Comments

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

1 Comment

Related