Conditions help....

Originally Said By: Jason Byrnes

  SELECT CompanyInfo.CompanyInfo_Logo, CompanyInfo.CompanyInfo_COName, Jobs.Job_Date, Jobs.Job_Position, Jobs.Job_Salary, Jobs.Job_Department, Jobs.Job_Division, Jobs.Job_City, Jobs.Job_State, Jobs.Job_Contact, Jobs.Job_Email, Jobs.Job_Summary
FROM (Jobs
LEFT JOIN CompanyInfo ON CompanyInfo.ID_User=Jobs.ID_User)
WHERE departments LIKE 'Brokerage%'
ORDER BY Jobs.Job_Date DESC  

Hi Jason, again, thanks for all the help, I have one question, see, I need now to filter the departments and only print jobs under brokerage and certain departments, for example,

Show only brokerage jobs with Brokerage - System
or
Show only brokerage jobs with Brokerage - Administration

etc, how should I construct the query to have jobs listed only within the requested department? I plan to have 2 pages, one with the department categories where you can click on any and that should be sent as URL parameter like:

list-brokerage-by-category.php?<?php echo $row_rsShowCats['Job_Department']; ?>=Department Here

but the other page, the one that receives that parameter is where I need to construct that query.

Any idea will be greatly appreciated! Thanks!

A.-