asked on
$conn = new PDO("mysql:host=$host;dbname=$db;charset=$charset", $user, $pass);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Establish a MySQL connection
$query2 = $conn->prepare('SELECT * FROM `product`
LEFT JOIN `product_description`
USING (product_id)
LEFT JOIN url_alias
USING (query)');
while ($row2 = $query2->fetch(PDO::FETCH_ASSOC))
{
echo $row2['product_id']." ".$row2['description']." ".$row2['query'];
}