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?