PHP debug 處理

錯誤訊息

Query failed : You have an error in your SQL syntax near '' at line 1

該是debug的時後了

就是這裡

<?
        $sql = "select * from news where sn = " . $sn;
        $result = getDB($sql);
        $row = mysql_fetch_array($result);
?>

我先直接給值

$sql = "select * from news where sn = " . 46;

查詢 ok

我再於 $sql 下一行加入 print $sql;

就看到

select * from news where sn = Query failed : You have an error in your SQL
syntax near '' at line 1

所以就是沒給到 46 這個值

至於要怎麼取值咧，由phpinfo(); 來查變數是什麼，有 _GET["sn"] 及 _REQUEST["sn"] 可用

所以咧，在 $sql 上一行加入 $sn = $_REQUEST["sn"];

<?
        $sn = $_REQUEST["sn"];
        $sql = "select * from news where sn = " . $sn;
        $result = getDB($sql);
        $row = mysql_fetch_array($result);
?>

就 OK啦

但最後原來是 php global 沒 on  – -"，不過程式寫的真爛