query sql/php
Publicado por Juan (1 intervención) el 15/02/2017 07:55:13
Hola buenas noches a todos soy nuevo en esto de la programación por mas vueltas que le doy no encuentro como hacer esto :) por fa echenme la mano :/
en el codigo que tengo me arroja como resultado lo qu esta en la imagen 1 lo que busco es como hacerlo para que salga en la imagen 2 separarlos por grupos de dos o en caso que en la busqueda salgan 3 equipos dividir en 2 y 1 no se si me explique
anexo codigo
espero me puedan orientar por favor amigos
saludos
en el codigo que tengo me arroja como resultado lo qu esta en la imagen 1 lo que busco es como hacerlo para que salga en la imagen 2 separarlos por grupos de dos o en caso que en la busqueda salgan 3 equipos dividir en 2 y 1 no se si me explique
anexo codigo
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
"Times New Roman","serif"'><o:p> </o:p></span></p>
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0
style='border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt;
mso-yfti-tbllook:1184;mso-padding-alt:0in 5.4pt 0in 5.4pt'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:23.25pt'>
<td width=188 style='width:140.9pt;border:solid windowtext 1.0pt;mso-border-alt:
solid windowtext .5pt;background:#BFBFBF;mso-background-themecolor:background1;
mso-background-themeshade:191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal; text-align:center'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>Detalle<o:p></o:p></span></b></p>
</td>
<td width=188 style='width:140.9pt;border:solid windowtext 1.0pt;border-left:
none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade:
191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal; text-align:center'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>Marca<o:p></o:p></span></b></p>
</td>
<td width=188 style='width:140.9pt;border:solid windowtext 1.0pt;border-left:
none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade:
191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal; text-align:center'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>Modelo<o:p></o:p></span></b></p>
</td>
<td width=188 style='width:140.9pt;border:solid windowtext 1.0pt;border-left:
none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade:
191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal; text-align:center'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>No.Serie<o:p></o:p></span></b></p>
</td>
<td width=188 style='width:140.95pt;border:solid windowtext 1.0pt;border-left:
none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade:
191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal; text-align:center'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>Folio<o:p></o:p></span></b></p>
</td>
<td width=188 style='width:140.95pt;border:solid windowtext 1.0pt;border-left:
none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade:
191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal; text-align:center'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>Datos Adicionales <p>(Hostname, Direccion)</p><o:p></o:p></span></b></p>
</td>
</tr>
<?php
$my_device = mysql_query("select * from location_details
LEFT JOIN stdevice ON location_details.id = stdevice.id
LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id
where NOT EXISTS
(select * from location_details where dev_status='Dump')
and stdev_id = '$get_id'
order by date_deployment DESC")or die(mysql_error());
while($row = mysql_fetch_array($my_device)){
$id = $row['id'];
?>
<tr style='mso-yfti-irow:1'>
<td width=188 valign=top style='width:140.9pt;border:solid windowtext 1.0pt;
border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
padding:0in 5.4pt 0in 5.4pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['dev_name']; ?><o:p></o:p></span></p>
</td>
<td width=188 valign=top style='width:140.9pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['dev_brand']; ?><o:p></o:p></span></p>
</td>
<td width=188 valign=top style='width:140.9pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['dev_model']; ?><o:p></o:p></span></p>
</td>
<td width=188 valign=top style='width:140.9pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['dev_serial']; ?><o:p></o:p></span></p>
</td>
<td width=188 valign=top style='width:140.95pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
<!-- <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['date_deployment']; ?><o:p></o:p></span></p>-->
</td>
<td width=188 valign=top style='width:140.95pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
<!-- <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['dev_status']; ?><o:p></o:p></span></p>
</td> -->
<?php } ?>
</tr>
<tr style='mso-yfti-irow:2;mso-yfti-lastrow:yes'>
<td width=1127 colspan=6 valign=top style='width:845.5pt;border:solid windowtext 1.0pt;
border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
padding:0in 5.4pt 0in 5.4pt'>
<!--<p class=MsoNormal align=center style='margin-bottom:0in;margin-bottom:.0001pt;
text-align:center;line-height:normal'><span style='font-family:"Times New Roman","serif"'>***NOTHING
FOLLOWS***<o:p></o:p></span></p>--->
</td>
</tr>
</table>espero me puedan orientar por favor amigos
saludos
Valora esta pregunta
0