Posted By

mattneary on 01/22/11

Tagged

form
mysql
php
search

Versions (?)

Last Edited at 01/22/11 09:09am

Statistics

Viewed 800 times

Favorited by 0 user(s)

Related snippets

MySQL Search/Category Filter

/ Published in: PHP

I thought this was pretty elegant code and wanted to share it with anyone who found it useful.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

$query = $search ?
		( !$cat ? 
			"SELECT * FROM games WHERE name LIKE '%".$search."%'" :
			"SELECT * FROM games WHERE category='".$cat."' AND name LIKE '%".$search."%'"
		):
		( $cat ?
			"SELECT * FROM games WHERE category='".$cat."'" :
			"SELECT * FROM games WHERE name='N/A'"
		);
basic_connect($query);