Tema: Consulta en varias tablas.
Ver Mensaje Individual
  #15 (permalink)  
Antiguo 11/01/2013, 05:18
Avatar de satjaen
satjaen
 
Fecha de Ingreso: septiembre-2012
Ubicación: Jaén (Andalucía)
Mensajes: 893
Antigüedad: 11 años, 8 meses
Puntos: 10
Respuesta: Consulta en varias tablas.
Puede ser que el error sea porque yo tenía antes la consulta a una sola tabla y ahora al tener varias tablas los registros les tenga de dar otro nº distinto $registro[0], por cambiar la posicion?:

Código PHP: 
Ver original
  1. $consulta="select id_aviso, id_factura,realizacion,recepcion,marcas,name,apellidos,calle,numero,edificio,puerta,piso,letra,localidad,provincia,dni,telefonos,movil,aparatos,modelo,tecnico,serie,codigo,compra,
  2. sintoma,recambio,denominacion,cantidad,pvp,importe ,recambio2,denominacion2,cantidad2,pvp2,importe2 ,recambio3,denominacion3,cantidad3,pvp3,importe3,recambio4,denominacion4,cantidad4,pvp4,importe4 
  3. ,recambio5,denominacion5,cantidad5,pvp5,importe5,recambio6,denominacion6,cantidad6,pvp6,importe6,recambio7,denominacion7,cantidad7,pvp7,importe7,recambio8,denominacion8,cantidad8,pvp8,importe8
  4. ,recambio9,denominacion9,cantidad9,pvp9,importe9,recambio10,denominacion10,cantidad10,pvp10,importe10,reparacion,entrada,salida,tiempo,material,obra,desplazamiento,base,iva,total  
  5. from facturas where id_aviso like '$id_aviso' ";

Código PHP: 
Ver original
  1. while($registro=mysql_fetch_row($r)){
  2.     
  3.                 $pdf->SetFont('Arial','B',9);
  4.                 $pdf->SetXY(-100,10);$pdf->Cell(85,5,'SERVICIO TÉCNICO OFICIAL',0,0,'C');
  5.                 $pdf->SetFont('Arial','B',8);
  6.                 $pdf->SetXY(-98,26);$pdf->Cell(0,20,'NºAviso',0,5,'L');$pdf->SetXY(-100,33.5);$pdf->SetFont('Arial','I',9);$pdf->Cell(85,5,$registro[0],0,0,'C');
  7.                 $pdf->SetFont('Arial','B',8);$pdf->SetXY(-98,30);$pdf->Cell(0,20,'NºFactura WM2 /',0,5,'L');$pdf->SetXY(-100,37.5);$pdf->SetFont('Arial','I',9);$pdf->Cell(85,5,$registro[1],0,0,'C');
  8.                 $pdf->SetFont('Arial','B',8);$pdf->SetXY(-98,34);$pdf->Cell(0,20,'F.Realización',0,5,'L');$pdf->SetXY(-100,41.5);$pdf->SetFont('Arial','I',9);$pdf->Cell(85,5,$registro[2],0,0,'C');
  9.                 $pdf->SetFont('Arial','B',8);$pdf->SetXY(-98,38);$pdf->Cell(0,20,'F.Recepción',0,5,'L');$pdf->SetXY(-100,45.5);$pdf->SetFont('Arial','I',9);$pdf->Cell(85,5,$registro[3],0,0,'C');
  10.                 $pdf->SetXY(30,51.5);$pdf->Cell(30,5,$registro[5],0,0,'L');$pdf->Cell(85,5,$registro[6],0,0,'L');
  11.                 $pdf->SetXY(30,56.5);$pdf->Cell(100,5,$registro[7],0,0,'L');$pdf->Cell(5,5,$registro[8],0,0,'L');$pdf->Cell(5,5,$registro[9],0,0,'L');$pdf->Cell(10,5,$registro[10],0,0,'L');$pdf->Cell(5,5,$registro[11],0,0,'L');$pdf->Cell(5,5,$registro[12],0,0,'L');
  12.                 $pdf->SetXY(30,61.5);$pdf->Cell(30,5,$registro[13],0,0,'L');$pdf->SetXY(170,61.5);$pdf->Cell(30,5,$registro[14],0,0,'L');
  13.                 $pdf->SetXY(160,51.5);$pdf->Cell(30,5,$registro[15],0,0,'L');
  14.                 $pdf->SetXY(30,66.5);$pdf->Cell(30,5,$registro[16],0,0,'L'); $pdf->SetXY(48,66.5);$pdf->Cell(0,5,'/',0,0,'L');$pdf->SetXY(50,66.5);$pdf->Cell(30,5,$registro[17],0,0,'L');
  15.                 $pdf->SetXY(25,74);$pdf->Cell(30,5,$registro[18],0,0,'L');
  16.                 $pdf->SetXY(25,80.5);$pdf->Cell(30,5,$registro[4],0,0,'L');
  17.                 $pdf->SetXY(25,86.5);$pdf->Cell(30,5,$registro[19],0,0,'L');
  18.                 $pdf->SetXY(25,92.5);$pdf->Cell(30,5,$registro[20],0,0,'L');
  19.                 $pdf->SetXY(118,74);$pdf->Cell(30,5,$registro[21],0,0,'L');
  20.                 $pdf->SetXY(118,80.5);$pdf->Cell(30,5,$registro[22],0,0,'L');
  21.                 $pdf->SetXY(118,86.5);$pdf->Cell(30,5,$registro[23],0,0,'L');
  22.                 $pdf->SetXY(25,104.5);$pdf->Multicell(0,3,$registro[24],0,'J',0);
  23.                 $pdf->SetXY(10,143);$pdf->Cell(30,5,$registro[25],0,0,'L');$pdf->SetXY(50,143);$pdf->Cell(30,5,$registro[26],0,0,'L');$pdf->SetXY(65,143);$pdf->Cell(0,5,$registro[27],0,0,'C');$pdf->SetXY(108,143);$pdf->Cell(0,5,$registro[28],0,0,'C');$pdf->SetXY(175,143);$pdf->Cell(0,5,$registro[29],0,0,'C');
  24.                 $pdf->SetXY(10,148);$pdf->Cell(30,5,$registro[30],0,0,'L');$pdf->SetXY(50,148);$pdf->Cell(30,5,$registro[31],0,0,'L');$pdf->SetXY(65,148);$pdf->Cell(0,5,$registro[32],0,0,'C');$pdf->SetXY(108,148);$pdf->Cell(0,5,$registro[33],0,0,'C');$pdf->SetXY(175,148);$pdf->Cell(0,5,$registro[34],0,0,'C');
  25.                 $pdf->SetXY(10,153);$pdf->Cell(30,5,$registro[35],0,0,'L');$pdf->SetXY(50,153);$pdf->Cell(30,5,$registro[36],0,0,'L');$pdf->SetXY(65,153);$pdf->Cell(0,5,$registro[37],0,0,'C');$pdf->SetXY(108,153);$pdf->Cell(0,5,$registro[38],0,0,'C');$pdf->SetXY(175,153);$pdf->Cell(0,5,$registro[39],0,0,'C');
  26.                 $pdf->SetXY(10,158);$pdf->Cell(30,5,$registro[40],0,0,'L');$pdf->SetXY(50,158);$pdf->Cell(30,5,$registro[41],0,0,'L');$pdf->SetXY(65,158);$pdf->Cell(0,5,$registro[42],0,0,'C');$pdf->SetXY(108,158);$pdf->Cell(0,5,$registro[43],0,0,'C');$pdf->SetXY(175,158);$pdf->Cell(0,5,$registro[44],0,0,'C');
  27.                 $pdf->SetXY(10,163);$pdf->Cell(30,5,$registro[45],0,0,'L');$pdf->SetXY(50,163);$pdf->Cell(30,5,$registro[46],0,0,'L');$pdf->SetXY(65,163);$pdf->Cell(0,5,$registro[47],0,0,'C');$pdf->SetXY(108,163);$pdf->Cell(0,5,$registro[48],0,0,'C');$pdf->SetXY(175,163);$pdf->Cell(0,5,$registro[49],0,0,'C');
  28.                 $pdf->SetXY(10,168);$pdf->Cell(30,5,$registro[50],0,0,'L');$pdf->SetXY(50,168);$pdf->Cell(30,5,$registro[51],0,0,'L');$pdf->SetXY(65,168);$pdf->Cell(0,5,$registro[52],0,0,'C');$pdf->SetXY(108,168);$pdf->Cell(0,5,$registro[53],0,0,'C');$pdf->SetXY(175,168);$pdf->Cell(0,5,$registro[54],0,0,'C');
  29.                 $pdf->SetXY(10,173);$pdf->Cell(30,5,$registro[55],0,0,'L');$pdf->SetXY(50,173);$pdf->Cell(30,5,$registro[56],0,0,'L');$pdf->SetXY(65,173);$pdf->Cell(0,5,$registro[57],0,0,'C');$pdf->SetXY(108,173);$pdf->Cell(0,5,$registro[58],0,0,'C');$pdf->SetXY(175,173);$pdf->Cell(0,5,$registro[59],0,0,'C');
  30.                 $pdf->SetXY(10,178);$pdf->Cell(30,5,$registro[60],0,0,'L');$pdf->SetXY(50,178);$pdf->Cell(30,5,$registro[61],0,0,'L');$pdf->SetXY(65,178);$pdf->Cell(0,5,$registro[62],0,0,'C');$pdf->SetXY(108,178);$pdf->Cell(0,5,$registro[63],0,0,'C');$pdf->SetXY(175,178);$pdf->Cell(0,5,$registro[64],0,0,'C');
  31.                 $pdf->SetXY(10,183);$pdf->Cell(30,5,$registro[65],0,0,'L');$pdf->SetXY(50,183);$pdf->Cell(30,5,$registro[66],0,0,'L');$pdf->SetXY(65,183);$pdf->Cell(0,5,$registro[67],0,0,'C');$pdf->SetXY(108,183);$pdf->Cell(0,5,$registro[68],0,0,'C');$pdf->SetXY(175,183);$pdf->Cell(0,5,$registro[69],0,0,'C');
  32.                 $pdf->SetXY(10,188);$pdf->Cell(30,5,$registro[70],0,0,'L');$pdf->SetXY(50,188);$pdf->Cell(30,5,$registro[71],0,0,'L');$pdf->SetXY(65,188);$pdf->Cell(0,5,$registro[72],0,0,'C');$pdf->SetXY(108,188);$pdf->Cell(0,5,$registro[73],0,0,'C');$pdf->SetXY(175,188);$pdf->Cell(0,5,$registro[74],0,0,'C');
  33.                 $pdf->SetXY(10,213);$pdf->Multicell(60,4,$registro[75],0,'J',0);
  34.                 $pdf->SetXY(15,200);$pdf->Cell(30,5,$registro[76],0,0,'L');
  35.                 $pdf->SetXY(35,200);$pdf->Cell(30,5,$registro[77],0,0,'L');
  36.                 $pdf->SetXY(55,200);$pdf->Cell(30,5,$registro[78],0,0,'L');
  37.                 $pdf->SetXY(174,197);$pdf->Cell(30,5,$registro[79],0,0,'C');
  38.                 $pdf->SetXY(174,202.5);$pdf->Cell(30,5,$registro[80],0,0,'C');
  39.                 $pdf->SetXY(174,208);$pdf->Cell(30,5,$registro[81],0,0,'C');
  40.                 $pdf->SetXY(174,213.5);$pdf->Cell(30,5,$registro[82],0,0,'C');
  41.                 $pdf->SetXY(174,224.5);$pdf->Cell(30,5,$registro[83],0,0,'C');
  42.                 $pdf->SetFont('Arial','I',10);$pdf->SetXY(173,230);$pdf->Cell(30,5,$registro[84],0,0,'C');
  43.               
  44.     }