;
//$dato = $_POST['dato'];
//$inicio = $_POST['inicio'];
//$final = $_POST['final'];
$query=mysql_query ("SELECT * FROM info WHERE schedule ='s750000'");
$qye=mysql_query ("SELECT * FROM embobinado WHERE schedule ='s750000'");
$qyes=mysql_query ("SELECT * FROM corecoil WHERE schedule ='s750000'");
$qes=mysql_query ("SELECT * FROM preliminar WHERE schedule ='s750000'");
$qesl=mysql_query ("SELECT * FROM oven WHERE schedule ='s750000'");
$qesls=mysql_query ("SELECT * FROM final WHERE schedule ='s750000'");
$qeslls=mysql_query ("SELECT * FROM empaque WHERE schedule ='s750000'");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<body><!-Vamos a crear una tabla que será impresa en el archivo excel->
<!-creamos la tabla de el reporte con border 1 y los títulos->
<table width="641" border="1">
<tr>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>suffix</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Order</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Item</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>CO</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Responsable</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Estatus Embobinado</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Fecha Embobinado</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Estatus Core Coil</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Fecha Core Coil</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Estatus Preliminar</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Fecha Preliminar</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Estatus Oven</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Fecha Oven</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Estatus Final</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Fecha Final</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Estatus Empaque</strong></th>
<th width="50%" style="background-color:#006; text-align:center; color:#FFF"><strong>Fecha Empaque</strong></th>
</tr>
<?php
// Un proceso repetitivo para imprimir cada uno de los registros.
$row = mysql_fetch_array($query);
$raw = mysql_fetch_array($qye);
$rew = mysql_fetch_array($qyes);
$riw = mysql_fetch_array($qes);
$ruw = mysql_fetch_array($qesl);
$ruws = mysql_fetch_array($qesls);
$ruwo = mysql_fetch_array($qeslls);
echo
"<tr>
<td bgcolor=\"#ededed\" align=\"center\">$row[suffix]</td>
<td bgcolor=\"#ededed\" align=\"center\">$row[order]</td>
<td bgcolor=\"#ededed\" align=\"center\">$row[item]</td>
<td bgcolor=\"#ededed\" align=\"center\">$row[co]</td>
<td bgcolor=\"#ededed\" align=\"center\">$row[responsible]</td>
<td bgcolor=\"#ededed\" align=\"center\">$raw[statusemb]</td>
<td bgcolor=\"#ededed\" align=\"center\">$raw[fechaemb]</td>
<td bgcolor=\"#ededed\" align=\"center\">$rew[statuscore]</td>
<td bgcolor=\"#ededed\" align=\"center\">$rew[fechacore]</td>
<td bgcolor=\"#ededed\" align=\"center\">$riw[statuspre]</td>
<td bgcolor=\"#ededed\" align=\"center\">$riw[fechapre]</td>
<td bgcolor=\"#ededed\" align=\"center\">$ruw[statusoven]</td>
<td bgcolor=\"#ededed\" align=\"center\">$ruw[fechaoven]</td>
<td bgcolor=\"#ededed\" align=\"center\">$ruws[statusfinal]</td>
<td bgcolor=\"#ededed\" align=\"center\">$ruws[fechafinal]</td>
<td bgcolor=\"#ededed\" align=\"center\">$ruwo[statusemp]</td>
<td bgcolor=\"#ededed\" align=\"center\">$ruwo[fechaemp]</td>
</tr>";
?>
</table>
</table>
</body>
</html>]