Need help with set-up of custom query using $_GET variables for use in search fields

Hello,

I’m trying to set-up a custom query that joins fields from two tables using the query below, however I get a syntax error with the $_GET variables. Could you please help me with the correct syntax?

SELECT * FROM line JOIN expense ON line.expense_id = expense.id WHERE line.description LIKE ‘$_GET[‘description’}’ AND line.part_number LIKE ‘$_GET[‘catalog’}’ AND expense.company LIKE ‘$_GET[‘company’}’ AND expense.requestor LIKE ‘$_GET[‘requester’}’ AND expense.number LIKE ‘$_GET[‘number’}’ ORDER BY expense.date DESC

Thanks,
Cynthia

Community Page
Last updated: