ThaiSEOBoard.com

SELECT * FROM customer JOIN product ON customer.c_order_1 = product.name

SELECT * FROM customer,product WHERE customer.c_order_1 = product.name AND customer.c_order_2 = product.name AND customer.c_order_3 = product.name

SELECT
c.c_order_1,
c.c_order_2,
c.c_order_3,
p1.name as name1,
p2.name as name2,
p3.name as name3
FROM
customer AS c
Inner Join product p1 ON p1.id = c.c_order_1
Inner Join product p2 ON p2.id = c.c_order_2
Inner Join product p3 ON p3.id = c.c_order_3

$conn=mysql_connect("localhost","root","");
mysql_select_db("test",$conn);
$sql="SELECT c.c_order_1,c.c_order_2,c.c_order_3,p1.name as name1,p2.name as name2,p3.name as name3";
$sql.=" FROM customer c Inner Join product p1 ON p1.id = c.c_order_1 Inner Join product p2 ON p2.id = c.c_order_2 Inner Join product p3 ON p3.id = c.c_order_3";
$query=mysql_query($sql);
$rs=mysql_fetch_assoc($query);
echo $rs["name1"]."<br/>";//p1.name as name1
echo $rs["name2"]."<br/>";//p2.name as name2
echo $rs["name3"]."<br/>";//p3.name as name3

$conn=mysql_connect("localhost","root","");
mysql_select_db("test",$conn);
$sql="SELECT c.c_order_1,c.c_order_2,c.c_order_3,p1.name as name1,p2.name as name2,p3.name as name3";
$sql.=" FROM customer c Inner Join product p1 ON p1.id = c.c_order_1 Inner Join product p2 ON p2.id = c.c_order_2 Inner Join product p3 ON p3.id = c.c_order_3";
$query=mysql_query($sql);
while($rs=mysql_fetch_assoc($query)){
echo $rs["name1"]."<br/>";//p1.name as name1
echo $rs["name2"]."<br/>";//p2.name as name2
echo $rs["name3"]."<br/>";//p3.name as name3
}

$sql = " SELECT id, (SELECT name FROM product WHERE id = c_order_1) as pro_name1, (SELECT name FROM product WHERE id = c_order_2) as pro_name2,
(SELECT name FROM product WHERE id = c_order_3) as pro_name3 FROM customer";
$rs = mysql_query($sql);
$row = mysql_fetch_array($rs);

echo "Product 1: " . $row['pro_name1'] . "<br />";
echo "Product 2: " . $row['pro_name2'] . "<br />";
echo "Product 3: " . $row['pro_name3'];