$link = mysql_connect("localhost","root","password");
$dbname = "database";
mysql_select_db($dbname) or die ("Error"];
$sql = "select id from employee";
$result=mysql_db_query($dbname,$sql);
while ($row=mysql_fetch_array($result)) {
$sql2 = "select name from empdetail where id='$row[0]'";
$result2=mysql_db_query($dbname,$sql2);
$row2=mysql_fetch_array($result2);
echo "$row2[0]<br>";
}
แบบนี้หรือปล่าว
Date :
9 ก.พ. 2551 09:19:34
By :
chatpkt
No. 2
Guest
sql="select name from employee left join empdetail whrer employee.id = empdetail.id"
ผิดก็อย่าว่ากันน......
Date :
9 ก.พ. 2551 10:13:42
By :
ToT
No. 3
Guest
Select Name From employee Join employeedetail On (employee.ID = employeedetail.ID)
Load balance : Server 05
