My problem is:
I have a start date field and a end date field and in my table a date field . The user is going to type a start date and a end date , and in the database I check if there are data included between those dates. If there is a possibility that there may be several data between these dates. And my real problem is .. How to mount HTML for User?
Ex:
Data Inicial : 02/05/2008 Data Final : 05/07/2012
<tr>
<td>
<font size="-1">Data inicial :</font>
</td>
<td >
<input name="tx_data_inic" id="id_data_inic" type="text" maxlength="10" size="5">
</td>
<td >
<font size="-1">Data final :</font>
</td>
<td >
<input name="tx_dt_fina" id="id_data_final" type="text" maxlength="10" size="5">
<button type="button" onClick="f_veri_datas();"></button>
</td>
</tr>
Select checks to see if you have data in the table:
$w_querybusca="SELECT * FROM sai_cad_datas
INNER JOIN sai_cad_cara
ON sai_cad_cara.fk_seq_data = sai_cad_datas.seq_data
where sai_cad_datas.dt_nota between '$w_tx_dt_inic' and '$w_tx_dt_fina';";
Below, the results data is assembled in HTML. I do not know if the correct way would be to use a radio button where a while will mount according to the number of data found.
1 - dados do resultado
2 - dados do resultado
3 - dados do resultado