21.11.2002, 14:08
Zitat:1. Suchen nach
if($mode == 1) $result = $db_zugriff->query("SELECT userid, userpassword, username, useremail, regemail, regdate FROM bb".$n."_user_table WHERE activation = 1 AND username LIKE '%".trim($search)."%' ORDER BY username ASC");
else $result = $db_zugriff->query("SELECT userid, userpassword, useremail, username, regemail, regdate FROM bb".$n."_user_table WHERE activation = 1 AND userid = '".trim($search)."' ORDER BY username ASC");
2. Ersetzten durch
if($search == "*") {
$result = $db_zugriff->query("SELECT userid, userpassword, username, useremail, regemail, regdate FROM bb".$n."_user_table WHERE activation = 1 ORDER BY username ASC");
} else {
if($mode == 1) $result = $db_zugriff->query("SELECT userid, userpassword, username, useremail, regemail, regdate FROM bb".$n."_user_table WHERE activation = 1 AND username LIKE '%".trim($search)."%' ORDER BY username ASC");
else $result = $db_zugriff->query("SELECT userid, userpassword, useremail, username, regemail, regdate FROM bb".$n."_user_table WHERE activation = 1 AND userid = '".trim($search)."' ORDER BY username ASC");
}
das oder? also wenn dann ist es so gemeint das du erst nach punkt eins suchst und das was du gefunden hast ersetzt durch punkt 2