按用户名选择查询不起作用

Question

This query is supposed to select domain_name where the username match, but its not working

$domain = $db->getAll("SELECT `domain_name` FROM `".PREFIX."domains` WHERE `custom_for` = ?i", $user->filter->username );

custom_for column have user's usernames, by the way $user->filter->username does echo user's username fine.

however at the same time if i select by user's id it does work

$domain = $db->getAll("SELECT `domain_name` FROM `".PREFIX."domains` WHERE `custom_for_id` = ?i", $user->filter->userid );

it select by user's uid it echo the results correct but with user's username it do not work, i want it to work with user's username.

What is wrong i am doing here ?

Thanks.

Answer 1

Either you should change i to something which will work for varchar. OR set custom_for field as int, it will work.
?i is for INT type.