I wanted php script for the following MySQL code:
mysql>select price from table where date("2007-04-18') between field1 and filed2;
If I give 2007-04-18 and submit, it should show results of that.
id price field1 field2
1 1200 2007-04-01 2007-04-11
2 1500 2007-04-12 2007-04-30
It should results of 1500
I required necessary script for above.
select * from table where date('2007-04-18') between field1
Moderator: General Moderators
-
m_ramanaji
- Forum Newbie
- Posts: 1
- Joined: Mon Apr 23, 2007 1:23 am
Something like...
Code: Select all
<?php
$date = '2007-04-18';
$query = "SELECT price FROM table WHERE field_1 <= '" . mysql_real_escape_string ( $date ) . "' AND field_2 >= '" . mysql_real_escape_string ( $date ) . "';";
?>