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:
Last updated: