Help With SQL Statement

[stevesimo]

Hi I wish to retrieve records from a table called order where orderDate contains the text 'LEX' and the order date is greater than or equal to startDate and also the order date is less than or equal to endDate

 

i.e. Select * from orders where orderDate >=startDate AND orderDate <=endDate AND policyRef contains 'Lex' Order by orderDate

 

I am not sure how to write this in PHP, can anyone offer any advice on how I do this?

 

Many thanks,

 

Steve (Blackpool)

[tauchai83]

<?php
$sql= "SELECT * FROM orders WHERE orderDate BETWEEN startDate AND endDate AND policyRef= 'Lex' ORDER BY orderDate";
$result=mysql_query($sql);

?>

try this and see.