Problems with dates

[astrodestino]

Hi!
I'm migrating my site form mssql & asp to mysql & php and I'm having a problem with this sql sintax.
What I do is select a value between 2 dates and show the results but I cannot figure how to do it in mysql.
My mssql sintax is:

$sqlstm="SELECT * FROM vidas_pasadas where fecha1<=#".$fecha."# and fecha2>=#".$fecha."#";

How should the mysql sintax look like?

Thank you!!!

 

[guelphdad]

SELECT * FROM vidas_pasadas where fecha1 between firstdate and seconddate

 

[astrodestino]

ITnx for the reply but I got two columns in the database, one with lowerdate(fecha1) and one with upperdate(fecha2) what I want to do is to select the recorset where the selected date value is greater than fecha1 and smaller than fecha2.
Tnx

 

[astrodestino]

I did it! tnx for you help!