[請益] 請問一個字串操作的問題~~
想請教各位一個字串操作的問題
我原先對MySQL中的資料給予兩碼數字編號
ex: a 01 ,a 02......
但是現在發現資料多出99了~~
所以變成
a 100,a 101
但是如此一來排序就會有問題
變成
a 01
~
a 10
a 100
我要用php寫一個程式來處理.但不知要用何種方法與函式
另外想請教各位
在EXCEL中的LEFT跟RIGHT字串函式
php中要用何種函式來作
ex: res=LEFT("aaa",2) 結果 res=aa
感謝~~
→
09/09 12:54, , 1F
09/09 12:54, 1F
→
09/09 12:57, , 2F
09/09 12:57, 2F
→
09/09 12:58, , 3F
09/09 12:58, 3F
→
09/09 17:53, , 4F
09/09 17:53, 4F
→
09/09 17:55, , 5F
09/09 17:55, 5F
→
09/09 17:57, , 6F
09/09 17:57, 6F
※ 編輯: jimshsu 來自: 59.115.217.45 (09/09 18:36)
→
09/10 00:07, , 7F
09/10 00:07, 7F
→
09/10 00:07, , 8F
09/10 00:07, 8F
→
09/10 00:08, , 9F
09/10 00:08, 9F
→
09/10 00:09, , 10F
09/10 00:09, 10F
→
09/10 00:10, , 11F
09/10 00:10, 11F
→
09/10 01:12, , 12F
09/10 01:12, 12F
→
09/10 01:12, , 13F
09/10 01:12, 13F
→
09/10 01:13, , 14F
09/10 01:13, 14F
→
09/10 01:15, , 15F
09/10 01:15, 15F
→
09/10 06:42, , 16F
09/10 06:42, 16F