Pulling from database.

[Zepo.]

I have a memberlist where you select a letter ect.

How do you make a mysql pull where username starts with $letr

[marcus]

SELECT * FROM `users` WHERE `username` LIKE '".$letter."%'

[Zepo.]

Ok thank you, i also have a number link how would i do that?

[marcus]

same way.

 

// from beginning
LIKE '".$letter."%'

// from end
LIKE '%".$letter."'

// in the string
LIKE '%".$letter."'

[Zepo.]

http://eliteladders.com/development/members.php

 

Doesnt show anything

 

if(isset($ltr)){
$letter="WHERE 'name' LIKE '".$ltr."%'";
$letterlink="&ltr=$ltr";
}

$stafflist=mysql_query("SELECT id,name,email,aim,website,points,country,lastactive,DATE_FORMAT(joined,'%M %d, %Y') FROM members $letter ORDER BY name LIMIT $page,25");
while(list($id,$name,$email,$aim,$website,$points,$country,$lastactive,$joined)=mysql_fetch_row($stafflist)){

[Zepo.]

bump

[Guernica]

Where is the display? Its just a mysql query...

[Zepo.]

http://eliteladders.com/development/members.php

There is no error.

[Zepo.]

Bump