prepare(" SELECT l.*, (SELECT COUNT(*) FROM jobs j WHERE j.location_id = l.id AND j.status = 'approved') as job_count FROM locations l $where ORDER BY l.name ASC "); $stmt->execute($params); $cities = $stmt->fetchAll(); $alphabetStmt = $pdo->query("SELECT DISTINCT UPPER(LEFT(name, 1)) as letter FROM locations ORDER BY letter"); $availableLetters = $alphabetStmt->fetchAll(PDO::FETCH_COLUMN); require_once 'includes/header.php'; ?>

Jobs By City

Explore job opportunities in your preferred location

ALL
cit found starting with ""

No cities found

No cities starting with "" were found.

View All Cities

0): ?> Job Available Jobs Available