Programming Forums - View Single Post

big_k105 · Mar 26th, 2008, 2:59 PM

The problem is in your select statement. You don't have a column name after the WHERE in your select statement. Probably should look like this

 sql Syntax (Toggle Plain Text) 
SELECT * FROM users WHERE info LIKE '%searchTerm%'
SELECT * FROM users WHERE info LIKE '%searchTerm%'

so in your php it should be:

php Syntax (Toggle Plain Text)

$sql = "SELECT * FROM users WHERE info LIKE '%$find%'";

Mar 26th, 2008, 2:59 PM	#10
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,603 Rep Power: 10	Re: Simple PHP Search Script The problem is in your select statement. You don't have a column name after the WHERE in your select statement. Probably should look like this sql Syntax (Toggle Plain Text) SELECT * FROM users WHERE info LIKE '%searchTerm%' SELECT * FROM users WHERE info LIKE '%searchTerm%' so in your php it should be: php Syntax (Toggle Plain Text) $sql = "SELECT * FROM users WHERE info LIKE '%$find%'"; $sql = "SELECT * FROM users WHERE info LIKE '%$find%'"; __________________ BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead.