crazyglue71 Posted December 5, 2009 Share Posted December 5, 2009 can somone help me with a sql query i'm trying to search the table to mach the search query made by a user $getRecord_sql = 'SELECT * FROM '.$SQL_FROM.' WHERE '.$SQL_NICK.' LIKE "'.$searchq.'%"' ; what i'm trying to achieve here is something like this "SELECT * FROM '.$SQL_FROM.' WHERE '.$SQL_NICK.' OR '.$SQL_SEX.' OR '.$SQL_FNAME.' OR '.$SQL_LNAME.' LIKE "'.$searchq.'%"'; but it doesnt work please help thank you. Quote Link to comment https://forums.phpfreaks.com/topic/184087-sql-query/ Share on other sites More sharing options...
fenway Posted December 5, 2009 Share Posted December 5, 2009 Show us the actual query, and tell us what doesn't work. Quote Link to comment https://forums.phpfreaks.com/topic/184087-sql-query/#findComment-971908 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.