Memberlist Search

[Boofo]

Can anyone please tell me how to make the following code to a partial serach for a member instead of having to have the full member name first?

if ($action=="quickfind") {
$usernamecheckq = $DB_site->query("SELECT userid FROM user WHERE username='".addslashes(htmlspecialchars($membername))."'");
$usernamecheck = mysql_fetch_array($usernamecheckq);
if (!$usernamecheck[userid]) {
eval("standarderror(\"".gettemplate("error_invalidusername")."\");");
exit; }
$goto="member.php?s=$session[sessionhash]&action=getinfo&userid=$usernamecheck[userid]";
eval("standardredirect(\"".gettemplate("redirect_memberfound")."\",\"$goto\");");
}

[Xenon]

instead of username='".addslashes($membername)."'
use username LIKE '%".addslashes($membername)."%'

[Boofo]

Ok, that worked, thank you. Now, how can I pull out the full username from the search and display it in the "redirect_memberfound" template. If I use "$membername" like it is now, it pulls out what was in the search string (like boofos ba) instead of the full username. Also, is there a way to have it bring up a listing of just the names found in the search so the user can pick from them?

Originally posted by Xenon
instead of username='".addslashes($membername)."'
use username LIKE '%".addslashes($membername)."%'

[Xenon]

you have to construct a while loop to get all usernames...

to get the correct username instead of $membername use $usernamecheck[username]

[Boofo]

Ok, but will that do an excessive amount of queries then?

I tried using $usernamecheck[username] and all I get is a blank spot where the name should be. :)

Originally posted by Xenon
you have to construct a while loop to get all usernames...

to get the correct username instead of $membername use $usernamecheck[username]

[Xenon]

no, no great ammount of queries, just one query and then just fetcharrays ;)

oh sorry, you must include ,username in the query: SELECT userid,username FROM...

[Boofo]

Thanks, Stefan, now it brings up the username ok.

How do I get it to bring up the user alphabetically instead of going by the userid? Right now a user with a Marj in the name comes up before an Marc when I type Mar. It is going by when they joined right now. :)

Originally posted by Xenon
no, no great ammount of queries, just one query and then just fetcharrays ;)

oh sorry, you must include ,username in the query: SELECT userid,username FROM...

[Xenon]

add a "ORDER BY username" into the query

[Boofo]

I take it from my DB error, I put it in the wrong place? :)

$usernamecheckq = $DB_site->query("SELECT userid,username FROM user ORDER BY username WHERE username LIKE '%".addslashes(htmlspecialchars($membername))."%'");

Originally posted by Xenon
add a "ORDER BY username" into the query

[Xenon]

SELECT userid,username FROM user WHERE username LIKE '%".addslashes(htmlspecialchars($membername))."%' ORDER BY username
shoud be right ;)

[Boofo]

I'm getting this error now. :)

Parse error: parse error, unexpected T_STRING in /home/boofo/public_html/forum/memberlist.php on line 320

[Xenon]

try now ;)

[Boofo]

Still giving me errors. Here is what I have for that whole line now. What did I screw up? :)

$usernamecheckq = $DB_site->query("SELECT userid,username FROM user WHERE username LIKE '%".addslashes(htmlspecialchars($membername))."%' ORDER BY username);

[Xenon]

add a " before the final ) ;)

[Boofo]

Just shoot me. :) How in the heck could I miss something so obvious? I figured it out at the exact same time my Outlook pulled for mail and your message here showed up. This calls for a big DOOHHH!!!!! Thanks, Stefan. You would think I would learn, huh? :)

Originally posted by Xenon
add a " before the final ) ;)