Ver Mensaje Individual
  #9 (permalink)  
Antiguo 12/11/2008, 16:56
RicardoU
(Desactivado)
 
Fecha de Ingreso: mayo-2007
Mensajes: 547
Antigüedad: 17 años, 10 meses
Puntos: 1
Por que solo puedo consultar un dato ?

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