警告：mysql_fetch_assoc（）期望参数1是资源，在[重复]中给出布尔值

Question

This question already has an answer here:

• mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result 32 answers

I get this error every time I run the code, I tried going through other similar threads but it didn't help. I am newbie

        $count=3;
            $db = new mysqli ('localhost', 'root', '', 'test');

        $selectSQL='SELECT * FROM coll_mark WHERE univ="'.$_POST['univ'].'" AND '.$brachTxt.'<="'.$_POST['perc'].'"AND '.$brachTxt.'!=""  ORDER BY '.$brachTxt.' DESC LIMIT '.$count;       
        $queryset='';
        $queryset=mysql_query($selectSQL);
        while($row = mysql_fetch_assoc($queryset)) 
        {
        echo('<tr><td id="ColgNames">'.$row['name'].'</td><td align="center">'.$row[$brachTxt].'</td></tr>');
        }

I also checked whether the query structure is correct or not, but the query is working perfectly.

</div>

Answer 1

Try Like this,

$count=3;
$db=mysql_connect('localhost','root','');
if(!$db) {
    die('Could not connect: '.mysql_error());
}
$connection_string=mysql_select_db('test',$db);
$selectSQL='SELECT * FROM coll_mark WHERE univ="'.$_POST['univ'].'" AND '.$brachTxt.'<="'.$_POST['perc'].'"AND '.$brachTxt.'!="" ORDER BY '.$brachTxt.' DESC LIMIT '.$count;       
$queryset=mysql_query($selectSQL);
$num=mysql_num_rows($queryset);
if(0==$num) {
    echo "No record";
    exit;
} else {
    while($row=mysql_fetch_assoc($queryset)) {
        echo('<tr><td id="ColgNames">'.$row['name'].'</td><td align="center">'.$row[$brachTxt].'</td></tr>');
    }
}