select * from table where date('2007-04-18') between field1
Posted: Mon Apr 23, 2007 1:33 am
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.
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.