Read all MySQL rows 'Username' and return all

[woocha]

Hi Guys..

 

  I need to read all of the rows from a MySQL table and return only the results that start with a user input letter.  So like if the user types in Andrew.  I want the database to return all rows that have usernames beginning with the letter a.

 

Has anyone ever done anything like this before?

 

Thanks

[webref.eu]

So you just need to: 

 

- Get first letter of user input. 

 

- Write a query that selects all Usernames beginning with that letter. 

 

Correct?

 

Rgds

[webref.eu]

echo $variable[0];

 

will echo the first character of a variable, so you can use something similar in your code to retrieve the first letter of user input. 

 

Rgds

[woocha]

Thanks guys, but I am more worried about the SQL query...I mean If I use substr to finms the first letter of the name, how to I write the SQL to search all usernames that begin with that substring?  Is there an SQL function like

 $query = "SELECT username FROM users WHERE username starts with a";

?

 

I know it looks stupid, but is there anything like that?

[cooldude832]

try

<?php
$user_input = trim($_POST['name']);
$user_input = mysql_real_escape_string(substr($user_input,0,1));
$q = "SELECT GROUP_CONCAT(Username) as usernames FROM `users` Where username LIKE '".$user_input."%'";
$r = mysql_query($q) or die(mysql_error()."<br /><br />".$q);
print_r(mysql_fetch_assoc($r));
?>

[webref.eu]

$FirstLetter = $variable[0];

 

I can't give you the exact SQL but a guess is:

 

$query = "SELECT username FROM users WHERE username LIKE '" . $FirstLetter . "%'";

 

the above is probably rather wrong syntax-wise but you get the idea (please feel free to correct anyone).  Just use a LIKE statement, then the FirstLetter followed by a wildcard match. 

 

Rgds

[woocha]

LIKE and Wildcard % awesome...that is just what I was looking for guys.

 

Thanks