NO LA VERDAD SIGUIE EN LO MISMO QUE PENA MOLESTAR TANTO
AQUI VA EL CODIGO
<?php
$link = mysql_connect("localhost", "root", "");
mysql_select_db("helpdesk",$link)or die ("Verifique la Base de Datos");
$fecha1 = "2010-01-01";
$fecha2 = "2010-12-22";
//$result= mysql_query("SELECT * FROM td_tickets WHERE date between :fecha1 and :fecha2",$link)or die( mysql_error() );
// $result= mysql_query("SELECT * FROM td_tickets WHERE dname LIKE '%ESTAFETA%' AND date('fecha1,d-M-Y H:m:s') ORDER BY date asc",$link)or die( mysql_error() );
//$result= mysql_query("SELECT * FROM td_tickets WHERE [date] >= 1 &format('date,d-M-Y H:m:s') AND [date] <= 0 &format ('date,d-M-Y H:m:s') ",$link)or die( mysql_error() );
//$result= mysql_query("SELECT * FROM td_tickets WHERE date('1789',fecha1) >= 1 AND date('2050',fecha2) <= 0")or die( mysql_error() );
//$result= mysql_query("Select * form td_tickets where date >=1 fecha1 and fecha <= 0 fecha2")or die( mysql_error() );
//$result= mysql_query("SELECT * FROM td_tickets WHERE dname LIKE '%ESTAFETA%' AND date >= '07-sep-2010' AND date <= '09-sep-2010'")or die( mysql_error() );
$result= mysql_query("SELECT * FROM td_tickets WHERE dname LIKE '%ESTAFETA%' AND (date >= '$fecha1' and date<= '$fecha2')")or die( mysql_error() );
if(mysql_num_rows($result) > 0){
echo "<table border= '3'\n";
echo "<tr> \n";
echo "<td><b>id</b></td> \n";
echo "<td><b>dname</b></td> \n";
echo "<td><b>mname</b></td> \n";
echo "<td><b>amname</b></td> \n";
echo "<td><b>email</b></td> \n";
echo "<td><b>subject</b></td> \n";
echo "<td><b>message</b></td> \n";
echo "<td><b>date</b></td> \n";
echo "<td><b>close_reason</b></td> \n";
echo "</tr> \n";
while($row = mysql_fetch_array($result)){
echo "<tr> \n";
echo "<td>".$row["id"]."</td> \n";
echo "<td>".$row["dname"]."</td> \n";
echo "<td>".$row["mname"]."</td> \n";
echo "<td>".$row["amname"]."</td> \n";
echo "<td>".$row["email"]."</td> \n";
echo "<td>".$row["subject"]."</td> \n";
echo "<td>".$row["message"]."</td> \n";
echo "<td>".date("d-M-Y H:m:s ",$row["date"])."</td> \n";
echo "<td>".$row["close_reason"]."</td> \n";
echo "</tr> \n";
}
echo "</table>";
}else{
echo "¡ La base de datos está vacia !";
}
?>
Y SIgUE CON LO MISMO LA BASE DE DATOS ESTA VACIA