 |
คำสั่งselect อย่างไรให้ออกใบเสร็จมาครั้งล่าสุดอ่ะ ถ้าสมมุติว่าคนสั่งซื้อวันเดียวกันหลายครั้ง |
| |
 |
|
|
 |
 |
|
order by ชื่อฟิว DESC
|
 |
 |
 |
 |
| Date :
2011-06-18 23:29:00 |
By :
taza678 |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
$sql1 = "select distinct oid from confirm_or where uid='$user' and date='2011-06-18' order by oid desc limit 1";
$res1 = mysql_query($sql1) or die(mysql_error());
list($lastOID) = mysql_fetch_row($res1);
$sql="SELECT DISTINCT concat(user.fname,' ',user.lname) as fullname ,user.address, user.tel, user.email, ";
$sql.="confirm_or.oid, confirm_or.date FROM user INNER JOIN confirm_or ON user.uid=confirm_or.uid AND ";
$sql.="confirm_or.oid ='$lastOID' ";
หรือ
$sql="SELECT DISTINCT concat(user.fname,' ',user.lname) as fullname ,user.address, user.tel, user.email, ";
$sql.="confirm_or.oid, confirm_or.date FROM user INNER JOIN confirm_or ON user.uid=confirm_or.uid AND ";
$sql.="confirm_or.uid='$user' AND date='2011-06-18' order by oid desc limit 1 ";
|
ประวัติการแก้ไข
2011-06-19 11:16:03
| |
|
|
| |
| Date :
2011-06-19 10:25:04 |
By :
sakuraei |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
