You do NOT have to sign-up to search the database or respond to an advert.
";
}
function category(){
echo "
.
Browse Positions by Category
";
require("db_conn.php3");
$select_str = "SELECT c.*, IF((ISNULL(pos_id)),0,1)*COUNT(*) AS count
FROM cats AS c LEFT JOIN positions AS p
ON p.cat_id=c.cat_id
GROUP BY c.cat_id
ORDER BY categories";
$result = mysql_query($select_str);
$col_split = ceil(mysql_affected_rows()/2);
$row_count = 0;
while ($row = mysql_fetch_array($result)){
if ($row_count == $col_split){
echo "