Mysql query error

[dlinden]

I am a novice and have an error that's driving me NUTS.  ???

 

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home5/camfulco/public_html/CompanyHome.php on line 132

 

code

case "content":                                    #110

      $dept_id = $_GET['dept_id'];

      $type_id = $_GET['type_id'];

      $sql = "SELECT a.name, a.type_id, b.title,

                b.description, b.content_date,

                b.create_date, b.created_by,

b.last_upd_date,b.last_upd_by,

                c.name as dept_name, content_id

              FROM Content_Type a, Department c

              LEFT OUTER JOIN Content b on

                a.type_id = b.content_type

                and a.type_id = b.content_type

                and b.dept_id = $dept_id

                and b.content_type = $type_id

              WHERE c.dept_id = $dept_id

              ORDER BY content_date DESC";

      $results = mysqli_query($cxn, $sql);

 

      $body_links = "";

      $content_count = 0;

      $page["body_text"] = "";

 

      while($row = mysqli_fetch_assoc($results))      #132

[thepip3r]

well reading your query error you're using mysqli_query() and the error for mysqli_fetch_assoc is telling you that it's expecting mysqli_result() instead.

 

soz but that's about as far as i can go as i'm not familiar with the mysqli family functions.