[eq1987]

I am using
Code:
$SQL = "SELECT * FROM users WHERE id LIKE '$user_input' OR guildname LIKE '%$user_input'%";

but it wont search the guildname, only the ID, so if i type 4, the guild with 4 as an id will come up, but if i type The Awesome Guild, it wont come up... can someone please show me whats wrong? Thanks, by the way, it wont work without the % either.

[sufyan]

Try this:

Code:

$SQL = "SELECT * FROM users WHERE id LIKE '$user_input' OR guildname LIKE '%$user_input%'";

I changed '%$user_input'% to '%$user_input%'