Debug Information
Table Name: FSFL0Gyh_vts_jobs
Table Exists: Yes
Total Jobs: 5
Open Jobs: 5
Table Columns:
- id (int(11))
- title (varchar(255))
- job_type (varchar(50))
- category (varchar(100))
- department (varchar(100))
- vacancies (int(11))
- fee (int(11))
- last_date (date)
- description (longtext)
- status (varchar(20))
- created_at (datetime)
- salary_range (varchar(100))
- experience_required (varchar(100))
- qualification (varchar(200))
- location (varchar(100))
- requirements (longtext)
- responsibilities (longtext)
- benefits (longtext)
- contact_email (varchar(100))
- contact_phone (varchar(20))
Sample Jobs:
- ID: 10 - Regional Manager (open)
- ID: 11 - City Manager (open)
- ID: 12 - Hub Supervisor / Warehouse Manager (open)
- ID: 13 - Support Executive / Customer Support Executive (open)
- ID: 14 - System Administrator / IT Officer (open)
Open Jobs Query Result:
Query: SELECT * FROM FSFL0Gyh_vts_jobs WHERE status = 'open' ORDER BY id DESC
Found: 5 open jobs