SELECT * FROM city WHERE city.pname=$row_a['pname'] $row_a['pname']為另一個表格的變數,求問這條句語可行否,如果出錯,錯在哪 回複討論(解決方案) MYSQL中根本沒有 =$row_a['pname'] 這種東西。 把這個sql列印出來 放資料庫裡執行下 看看能不能執行 你那個$row_a['pname']是從PHP程式中傳來的吧,改成這樣就能執行了,大概 $sql="SELECT * FROM
The PHP development team announces the immediate availability of PHP 5.4.14 and PHP 5.3.24. These releases fix about 10 bugs aswell as upgrading the bundled PCRE library. All users of PHP are encouraged to upgrade to PHP 5.4.14. Version 5.4.14
"select * from databases where 'name'='my name'" 當my name變成I'm xiao的時候就出錯了,怎麼解決啊???? "select * from databases where 'name'='I'm xiao'" 回複討論(解決方案) 1、"select * from databases where `name`='my name'" 欄位名稱用的是`,ESC
複選框,如果我想對選擇的資料進行group_concat()操作,請問怎麼做呢? 回複討論(解決方案) $in=implode(',',$_POST['id']); //假設複選框name為id[]$sql="select id, group_concat(name) from tt where id in($in) group by id";... 謝謝jordan102大大的解答
原sql語句為: SELECT * from ( SELECT DISTINCT *, year( from_unixtime(time ) ) year, month( from_unixtime(time ) ) month FROM A表 WHERE id = 1) as a WHERE is_del =0 AND year = 1 AND month = 1 order by time DESC 現在我想關聯B表.如何查詢? A表.id=B表.id
name LIKE "%A%" OR time LIKE "%b%" 怎麼排完like A的結果 在排 B的結果? 回複討論(解決方案) ...order by if(instr(name,'A') >0,1,0) desc ...order by if(instr(name,'A') >0,1,0) desc 大哥 有全句樣本嗎?這麼半句看不懂! 這個半句足夠可以理解了