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
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!