Select

[DanyelNak]

Fiz esse meu SELECT e um botao que quando eu apertar, chama tudo que aconteceu no horario q eu coloquei no meu select.

<select name='auditoria_hora'>

<option value=''>Por Hora</option>

<option value='00:00:00 AND 00:59:59'>00:00</option>

<option value='01:00:00 AND 01:59:59'>01:00</option>

<option value='02:00:00 AND 02:59:59'>02:00</option>

<option value='03:00:00 AND 03:59:59'>03:00</option>

<option value='04:00:00 AND 04:59:59'>04:00</option>

<option value='05:00:00 AND 05:59:59'>05:00</option>

<option value='06:00:00 AND 06:59:59'>06:00</option>

<option value='07:00:00 AND 07:59:59'>07:00</option>

<option value='08:00:00 AND 08:59:59'>08:00</option>

<option value='09:00:00 AND 09:59:59'>09:00</option>

<option value='10:00:00 AND 10:59:59'>10:00</option>

<option value='11:00:00 AND 11:59:59'>11:00</option>

<option value='12:00:00 AND 12:59:59'>12:00</option>

<option value='13:00:00 AND 13:59:59'>13:00</option>

<option value='14:00:00 AND 14:59:59'>14:00</option>

<option value='15:00:00 AND 15:59:59'>15:00</option>

<option value='16:00:00 AND 16:59:59'>16:00</option>

<option value='17:00:00 AND 17:59:59'>17:00</option>

<option value='18:00:00 AND 18:59:59'>18:00</option>

<option value='19:00:00 AND 19:59:59'>19:00</option>

<option value='20:00:00 AND 20:59:59'>20:00</option>

<option value='11:00:00 AND 21:59:59'>21:00</option>

<option value='22:00:00 AND 22:59:59'>22:00</option>

<option value='23:00:00 AND 23:59:59'>23:00</option>

</select>

fiz o Between com o Myqsl, mas nao deu certo.

alguem pode m ajudar??

Obrigado!

[fernando c]

Between o q? veja q ai você só está passando 1 parametro (1 criterio, 1 variavel)..

precisa passar tb o 2º..

ex: ao submeter esse seu select - supondo q você selecionou a 1ª opção - o banco vai entender o seguinte:

select campos from tabela

where (dados) estão entre '00:00:00 AND 00:59:59' E... ???

ok?

[DanyelNak]

Esta assim...

<?php

if($_REQUEST["buscar2"])

{

$sql = "SELECT

DATE_FORMAT(auditoria_data_hora, '%d/%m/%Y %H:%i:%s') AS auditoria_data_hora,

auditoria_usuario_id,

auditoria_nome,

FROM tbl_auditoria

WHERE auditoria_hora BETWEEN '".$_POST['a1']."-".$_POST['m1']."-".$_POST['d1']." 00:00:00' AND '".$_POST['a2']."-".$_POST['m2']."-".$_POST['d2']." 23:59:59'

ORDER BY auditoria_id DESC";

}