System for Job Posting... Please help!

programming
1

I’m trying to determine what would be the easiest/best way to have a site where users can post jobs. Basically, they would have to fill out a form with the basic information, and the info would be posted on the site’s list and given its own page.

Is there any code aviable that I could use as a skeleton? Or should i hire some sort of coder for this? Thanks

Mike

2

Would be super simple. Your fields would be something like:
Company
Location
Company Website
Job Title
Job Description
Application URL or Download

then just make a call to the database, easy cheesy

3

^ better to make all those different tables with references.

i.e.

Jobs_content
Jobs_ref(references job content)

Also, I would include skills a needed or qualifications table for referencing and possibly, to help with similar job listings links.

4

[QUOTE=bear;2325087]^ better to make all those different tables with references.

i.e.

Jobs_content
Jobs_ref(references job content)

Also, I would include skills a needed or qualifications table for referencing and possibly, to help with similar job listings links.[/QUOTE]You would only need 1 table, anymore than that makes no sense at all and is overkill IMO. There’s nothing that really needs to be relational unless you’re allowing creation of user accounts.


CREATE TABLE `t_jobs` (
  `job_id` int(11) unsigned NOT NULL auto_increment,
  `post_date` varchar(11) default NULL,
  `name` varchar(255) default NULL,
  `location` varchar(255) default NULL,
  `website` varchar(255) default NULL,
  `title` varchar(255) default NULL,
  `description` text,
  `application` varchar(255) default NULL,
  PRIMARY KEY  (`job_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

things like qualifications and things like that can just be kept as text inside the body/description. no reason to make it more complex than what it needs to be.