Jump to content

sql query


crazyglue71

Recommended Posts

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.

 

 

 

 

 

Link to comment
https://forums.phpfreaks.com/topic/184087-sql-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.