mysql_fetch_array()：提供的参数不是有效的 MySQL

Question

$idc = $_GET['id'];
$name1 = $_GET['name'];
$id2 = $_GET['ids'];
$toplinks = "";

if (isset($_SESSION['category_id'])) {
    // Put stored session variables into local php variable
    $userid = $_SESSION['id'];
    $username = $_SESSION['name'];

}
$sql_2 = mysql_query("SELECT * FROM blabbing WHERE mem_id='$userid' OR men_id='$idc' ORDER BY blab_date DESC LIMIT 20")

while($row = mysql_fetch_array($sql_2)){
    }

Answer 1

我认为您的查询中有错误...您参考 mem_id 然后 OR men_id

尝试添加 or die ( mysql_error () ); 到 mysql_query 行。

IE

$sql_2 = mysql_query("SELECT * FROM blabbing WHERE mem_id='$userid' OR mem_id='$idc' ORDER BY blab_date DESC LIMIT 20") or die ( mysql_error () );

Answer 2

你先mysql_connect了吗？