Re: [SQL ] 核取方塊的問題

看板Database作者JoeHorn (每天都在公司玩OLG)時間17年前 (2008/09/04 19:27)推噓1(1推 0噓 0→)

留言1則, 1人參與討論串1/2 (看更多)

※ 引述《jkhunter (我不配)》之銘言： : $sqla="select * from yahoo where yahoo.key LIKE '%$url%'and page LIKE : '%$gg%'and jk LIKE 'A' ORDER BY `price` ASC"; : $sqlb="select * from yahoo where yahoo.key LIKE '%$url%'and page LIKE : '%$gg%'and jk LIKE 'B' ORDER BY `price` ASC"; : $sqlc="select * from yahoo where yahoo.key LIKE '%$url%'and page LIKE : '%$gg%'and jk LIKE 'C' ORDER BY `price` ASC"; : $sqld="select * from yahoo where yahoo.key LIKE '%$url%'and page LIKE : '%$gg%'and jk LIKE 'D' ORDER BY `price` ASC"; : $sqld="select * from yahoo where yahoo.key LIKE '%$url%'and page LIKE : '%$gg%'and jk LIKE 'E' ORDER BY `price` ASC"; : $sqlf="select * from yahoo where yahoo.key LIKE '%$url%'and page LIKE : '%$gg%'and jk LIKE 'F' ORDER BY `price` ASC"; $sql = "SELECT * FROM `yahoo` WHERE `key` LIKE '%$url%' AND `page` LIKE '%$gg%' AND ( `jk` LIKE 'A' OR `jk` LIKE 'B' OR `jk` LIKE 'C' OR `jk` LIKE 'D' OR `jk` LIKE 'E' OR `jk` LIKE 'F' ) ORDER BY `price` ASC"; -- ★kathsda 踩叮噹能發洩情緒壓力是本公司的福利 To kathsda: 感謝您說明踩叮噹的益處，我會協助推廣踩叮噹運動～ ★kathsda (￣□￣|||)a。。。為什麼我一直在出產簽簽呢 To kathsda: 據聞... 叮噹出產（簽簽），必屬佳作！ ★kathsda 別再相信沒有根據的事實了( ‵□′)───C＜─___-)||| ★kathsda x的...打錯自婊了 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 218.173.168.32

推

jkhunter

09/04 19:29, , 1^F

09/04 19:29, 1^F

‣ 返回看板[ Database ] 資庫

‣ 更多 JoeHorn 的文章

文章代碼(AID): #18lyOalB (Database)