<?php

$link1 = mysql_connect("localhost", "root", "");
$link2 = mysql_connect("localhost", "root", "", true);
mysql_select_db("lproduccion", $link1);

$query1 = mysql_query("SELECT nom_pro, nom_taller FROM productos LEFT JOIN lotes ON productos.id_pro = lotes.id_pro LEFT JOIN talleres ON lotes.id_tall = talleres.id_tall", $link1);

$createquery = mysql_query("CREATE DATABASE dwlaser", $link2);
mysql_select_db("dwlaser", $link2) or die("Cannot select database");

$create_productos_taller = mysql_query("CREATE TABLE dwlaser.productos_taller (productos VARCHAR (250) NOT NULL, taller VARCHAR (250) NOT NULL)", $link2);

while($temp = mysql_fetch_array($query1))
  {
    echo $temp[0];
    echo " | ";
    echo $temp[1];
    echo "<br>";
    echo "<br>";
  }

?>