prepare( "SELECT id, cat1 FROM category WHERE scheme = 'EO' AND id = ? LIMIT 1" )) { /* bind parameters s -string, b - boolean, i - int, etc */ $categoryStmt -> bind_param("i", $getid); // execute it $categoryStmt -> execute(); // bind results $categoryStmt -> bind_result($id, $cat1); // fetch results while ($categoryStmt -> fetch()) { $catArray['id'] = $id; $catArray['cat1'] = $cat1; } // free results $categoryStmt -> free_result(); // close it $categoryStmt -> close(); } // Get feature records for reqeusted category if ($featureStmt = $mysqli -> prepare( "SELECT feature.id FROM feature, category_xref WHERE feature.id = category_xref.table_id AND category_xref.category_id = ? AND feature.status = 'publish' ORDER BY post_date DESC" )) { /* bind parameters s -string, b - boolean, i - int, etc */ $featureStmt -> bind_param("i", $getid); // execute it $featureStmt -> execute(); // bind results $featureStmt -> bind_result($id); // store results $featureStmt -> store_result(); $totalRowsFeatures = $featureStmt->num_rows(); // fetch results while ($featureStmt -> fetch()) { $featureArray[] = $id; } // free results $featureStmt -> free_result(); // close it $featureStmt -> close(); } $section = 'Features'; $subsection = 'Features By Topic'; if (isset($catArray['cat1'])) { $subsection .= " : " . $catArray['cat1']; } include ($rootpath . "parts/header.php"); /** * create the feature object */ $featureRecords = new featureRecord($mysqli); //body starts ?>