query($sql); if($docResult->num_rows > 0 ) { while($row = $docResult->fetch_assoc()){ $doc[] = $row; } } break; case 2: $sql = "SELECT clc_doc.* FROM clc_doc INNER JOIN clc_cat_relationships ON clc_doc.id = clc_cat_relationships.doc_id where clc_cat_relationships.cat_id = $cat and doc_type = $type ORDER BY clc_doc.year DESC"; $docResult = $db_conx->query($sql); if($docResult->num_rows > 0 ) { while($row = $docResult->fetch_assoc()){ $doc[] = $row; } } break; case 3: $sql = "SELECT clc_doc.* FROM clc_doc INNER JOIN clc_cat_relationships ON clc_doc.id = clc_cat_relationships.doc_id where clc_cat_relationships.cat_id = $cat and (clc_doc.doc_title LIKE '%$search%' or clc_doc.keyword LIKE '%$search%' or clc_doc.doc_description LIKE '%$search%') and doc_type = $type ORDER BY clc_doc.year DESC"; $docResult = $db_conx->query($sql); if($docResult->num_rows > 0 ) { while($row = $docResult->fetch_assoc()){ $doc[] = $row; } } break; default: $sql = "SELECT clc_doc.* FROM clc_doc INNER JOIN clc_cat_relationships ON clc_doc.id = clc_cat_relationships.doc_id where clc_cat_relationships.cat_id = $cat ORDER BY clc_doc.year DESC"; $docResult = $db_conx->query($sql); if($docResult->num_rows > 0 ) { while($row = $docResult->fetch_assoc()){ $doc[] = $row; } } } ?> CLC Database: Publications

Categories >



0 results found. ()

... ...

query($sql); if($result->num_rows > 0 ) { while($row = $result->fetch_assoc()){ echo $row['nicename']; } } ?>

... ... ... ...


The search document was not found in database. Please try again!