作者JoeHorn (每天都在公司玩OLG)
看板Database
标题Re: [SQL ] 核取方块的问题
时间Thu Sep 4 19:27:29 2008
※ 引述《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
1F：推 jkhunter:谢谢~~我懂了 感恩 09/04 19:29