I have a MySql database that has a column which corresponds to a text area in the form. In this text area the user is putting/submitting a recipe.
What is the correct way to query the database to get that field's (column) data? I am trying to use the following but have no idea what to use between the '' for recipe variable. I want to pull the complete recipe out of the row (record) when the other query restrictions are met.
Culinarily Yours,
Chef Mars
$query = "SELECT * FROM $userstable WHERE (origin LIKE 'Dominican Republic' && meal LIKE 'dinner' || name LIKE 'Majarete' && recipe '')";