Este es no codigo no encuentro el error
Lo que sucede es que en la consulta SQL me funcionan todas consultas , por que lo probe de uno en uno , pero cuando agrego las demas , ya no me funciona ninguna, ahorita separe todas las demas por que estuve haciendo pruebas pero no doy con la falla.
en resumen
sql5="SELECT * from reservation where res_code LIKE '%$reser_number%'"; asi asi funciona sql5="SELECT * from reservation where res_code LIKE '%$reser_number%'and paid LIKE '%$paidres%'"; asi asi funciona no funciona.
Ojala me puedas ayudar
<?
if (isset($_GET[search])) {
$reser_number=$_GET['reser_number'];
$paidres=$_GET['paid'];
$arrives=$_GET['date'];
$nights=$_GET['nigths'];
$roomer=$_GET['room'];
$fname1=$_GET['fname'];
$lname1=$_GET['lname'];
if (($reser_number=='')and($paidres=='')and($arrives= ='')and($nights=='')and($roomer=='')and($fname1==' ')and($lname1=='')){ echo" ";}
else{
include ('../include/conexion.php');
$db=mysql_select_db($base,$conexion);
echo"$reser_number";echo"$paidres";echo"$arrives"; echo"$nights";echo"$customer"; echo"$room";echo"$fname"; echo"$lname";
$sql5="SELECT reservation.paid, room_selected.reservation_id, reservation.id, reservation.res_code, reservation.arrive_date, reservation.num_nights, reservation.customer_id, room_selected.room_id, room.room_number
FROM room_selected, reservation, room
WHERE room_selected.reservation_id = reservation.id
AND room_selected.room_id = room.id AND
res_code LIKE '%$reser_number%'and paid LIKE '%$paidres%' ";
//res_code LIKE '%$reser_number%'and paid LIKE '%$paidres%'and arrive_date LIKE '%$arrives%' and num_nights LIKE '%$nights%'and room LIKE '%$roomer%'and fname LIKE '%fname%'and lname LIKE '%lname%' $result5=mysql_query($sql5,$conexion); while ($fila5=mysql_fetch_array($result5)){
echo"<tr>";
echo"<td bgcolor=#CCCCCC>","</td>";
echo"<td align=\"left\" bgcolor=#CCCCCC > <font size=2 color= \"#003366\">", "<a href='reservation_edit.php?id=".$fila5[id]."'>",
$fila5['res_code'] ,"</a>","</td>";
echo"<td align=\"left\" bgcolor=#CCCCCC> <font size=2 color= \"#003366\">", $fila5['arrive_date'],"</td>";
echo"<td align=\"left\" bgcolor=#CCCCCC > <font size=2 color= \"#003366\">", $fila5['num_nights'],"</td>";
echo"<td align=\"left\" bgcolor=#CCCCCC > <font size=2 color= \"#003366\">", $fila5['room_number'],"</td>";
echo"<td align=\"left\" bgcolor=#CCCCCC > <font size=2 color= \"#003366\">", $fila5['customer_id'],"</td>";
echo "<td align=\"left\" bgcolor=#CCCCCC > <font size=2 color= \"#003366\"><a