Search site

[conker87]

I'm trying to make a search form for my site. Just a quick question. This is my query:

 

$query = "SELECT * FROM `articles`, `reviews`
		WHERE `articles`.`title` LIKE '%$search%' OR
		`articles`.`author` LIKE '%$search%' OR
		`articles`.`type` LIKE '%$search%' OR
		`articles`.`content` LIKE '%$search%' OR
		`reviews`.`title` LIKE '%$search%' OR
		`reviews`.`genre` LIKE '%$search%' OR
		`reviews`.`platform` LIKE '%$search%' OR
		`reviews`.`author` LIKE '%$search%' OR
		`reviews`.`content` LIKE '%$search%'";

Where '$search' is the escaped query. Will this work? And can I use it with mysql_fetch_array/assoc?

[RMcLeod]

$query = "SELECT * FROM `articles`, `reviews`
WHERE articles.title LIKE '%$search%' OR
articles.author LIKE '%$search%' OR
articles.type LIKE '%$search%' OR
articles.content LIKE '%$search%' OR
reviews.title LIKE '%$search%' OR
reviews.genre LIKE '%$search%' OR
reviews.platform LIKE '%$search%' OR
reviews.author LIKE '%$search%' OR
reviews.content LIKE '%$search%'";

 

No need for the ` when you referencing a table and column using table.column syntax. If you're doing a content search I would recommend you look into using MySQL's Full Text capabilities.