Menu
I have a basic search page that queries the database and displays results based on the search term. I have an “approved” field that is set to 0 by default. When the user searches, I would like to exclude rows that have the “approved” field set to 0.
Here’s what I have now:
[code=php]$q =”SELECT * FROM tablename WHERE name LIKE ‘%” . $searchterm . “%'”;
Still new to PHP/MySQL, so please bear with me if this is childs play stuff ?
Thanks in advance!