Thank You, This is my first post since I came around this site, And as i was reading thru the past threads I came across that everyone is very helpfull , so I was wondering if someone can help me out..
I'm trying to create a new Search for users. with different categories suchs as
<select name=\"gender\">
<option selected></option>
<option value=\"boi\">Boi</option>
<option value=\"gurl\">Gurl</option>
</select>
<input type=\"checkbox\" name=\"playlist\" value=\"true\">
<input type=\"checkbox\" name=\"username\" value=\"true\">
<input type=\"checkbox\" name=\"website\" value=\"true\">
<input type=\"checkbox\" name=\"aim\" value=\"true\">
<input type=\"checkbox\" name=\"location\" value=\"true\">
<input type=\"checkbox\" name=\"icq\" value=\"true\">
<input type=\"checkbox\" name=\"email\" value=\"true\">
<input type=\"checkbox\" name=\"profile\" value=\"true\">
<input type=\"checkbox\" name=\"searchjournals\" value=\"true\">
<input size=\"25\" type=\"text\" name=\"query\" value=\"\">
<input type=\"submit\" value=\"SEARCH\">
This would be my form, then not sure hot to continue it, to do search and to display....
$playlist = sql_query("Select user_playlist from ".$prefix."users where(user_playist LIKE '%$query%')");
$username = sql_query("Select uname from ".$prefix."users where(uname LIKE '%$query%')");
if (isset($checkbox)) then do_stuff($playlist, $username);
OR
$search = sql_query("SELECT * FROM table WHERE uname LIKE %query% OR user_icq LIKE %query%"
");
I really need some help as you can see so please if anyone can help me out I would really appreciate it.... Thank You
