Orden de compra:
$Cia = $_GET['cia'];
$ID = $_GET['id'];
$No = $_GET['no'];
$i=0;
$query3="SELECT
pr.name,
pr.id_prov,
pr.country
FROM
ptoscotizacion pc
INNER JOIN cotizacion c ON c.ID = pc.ID
INNER JOIN product p ON p.id_product = pc.id_product_cot
INNER JOIN proveedor pr ON pr.id_prov = p.provider
LEFT JOIN ordencompra oc ON oc.id_cotizacion = c.No AND oc.id_prov = pr.id_prov
WHERE
c.No =".$No."
AND oc.id_PO IS NULL
GROUP BY
pr.name,
pr.id_prov,
pr.country
ORDER BY
pr.name";
$result3=mysql_query($query3,$con) or die(mysql_error());
while($registro3=mysql_fetch_row($result3))
{
$prov = new proveedor();
$prov->id = $registro3["1"];
$prov->name = $registro3["0"];
$prov->country = $registro3["2"];
$proveedores[$i] = $prov;
$i++;
}
?>