I have calendar in php and two veriable : date3 , data4
When i run a statement
<input type="button" name="button2" id="button2" value="Date" onClick="javascript:alert('from date : '+this.form.date3.value+' ,to date: :'+this.form.date4.value);">
I have in response two dates
I need to use this dates in query to oracle to filtr result from db.
<?php
stmt=OCIParse($conn,"SELECT * FROM tests WHERE (TEST_TIME BETWEEN $date3 AND '$date4");
$ret=OCIExecute($stmt);
$nrows=ocifetchstatement($stmt,$results);
how to write correctly above stmt , and how to call query via button ?