• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL database query

 
Rob Nowlan
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I have 4 tables in mysql.
categories
jobs
jobseekers
applications

I am trying to list all jobs on my homepage so that jobseekers can apply. Applications is a bridge table in between jobs and jobseekers.
What I am trying to do unsucessfuly is list jobs on home page in PHP index.php that includes all the job table column data as well as category name. At the moment I am only listing category ID with the job details and not category name.
Can anyone suggest the right query? I think it may require a join.

Thanks

Rob
 
Roel De Nijs
Sheriff
Posts: 10662
144
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rob Nowlan wrote:What I am trying to do unsucessfuly is list jobs on home page in PHP index.php that includes all the job table column data as well as category name. At the moment I am only listing category ID with the job details and not category name.
Can anyone suggest the right query? I think it may require a join.

And which query are you currently using? And which information (columns) want you to display on your home page?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic