[SOLVED] query string

[sitorush]

hello friends,

whats the correct format of query string below:

$query = 'Select * from datersv where $ci BETWEEN datersv.date_in AND datersv.date_out OR $co BETWEEN datersv.date_in AND datersv.date_out';

Thank you.. 

 

[HuggieBear]

If you mean how should it be formatted, I'd go for this, although you haven't specified which database you're using, so I can't confirm if the syntax is exactly right.

 

<?php
$query = "SELECT * FROM datersv WHERE (" . $ci . " BETWEEN datersv.date_in AND datersv.date_out) OR (" . $co . " BETWEEN datersv.date_in AND datersv.date_out)";
?>

 

Regards

Huggie

[sitorush]

yes it works now.

thank you very much..