skinnydragon
New Member
I have this right now:\[code\]if(isset($_POST["search"]) && !empty($_POST["search"])) { $full_name = mysql_real_escape_string($_POST["search"]); $sex = mysql_real_escape_string($_POST["sex"]); list($firstname, $lastname) = array_map('ucfirst', explode(' ', $full_name)); $query = "SELECT firstname, lastname, id, user_name, sex, last_access, bostadsort FROM users WHERE (firstname LIKE '$firstname' OR lastname LIKE '$lastname') AND sex = '$sex'"; $result1 = mysql_query($query) or die(mysql_error()); $count = mysql_num_rows($result1); while($get = mysql_fetch_array ($result1)){ echo $get["firstname"] . " " .$get["lastname"]."<br>"; }}\[/code\]This is my search query. Now the form is called "Search for full names". You type in, and then it splits to $firstname , $lastname.Works great, no problems. Although if you ONLY enter a user