 |
ขอโค้ดตัวอย่าง วิธีการใช้งาน UNION ทีคับ วิธีเอาไปใช้ใช้ยังไง |
|
 |
|
|
 |
 |
|
Code (PHP)
SELECT Column1 AS A1,Column2 AS A2,... FROM [Table-Name]
UNION
SELECT Column1 AS A3,Column2 AS A4,... FROM [Table-Name]
$data=mysql_fetch_array($sql);
echo $data[A1];

|
 |
 |
 |
 |
Date :
2011-02-22 23:24:49 |
By :
iieszz |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
แล้ว $data=mysql_fetch_array($sql); รับมาจากไหนคับ
|
 |
 |
 |
 |
Date :
2011-02-22 23:26:36 |
By :
boodemon |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
Code (PHP)
$sql="SELECT Column1 AS A1,Column2 AS A2,... FROM [Table-Name]
UNION
SELECT Column1 AS A3,Column2 AS A4,... FROM [Table-Name] ";
$data=mysql_fetch_array($sql);
echo $data[A1];
|
 |
 |
 |
 |
Date :
2011-02-23 06:30:53 |
By :
webmaster |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|