TalkPHP - View Single Post

Gurnk · 10-24-2007, 11:39 AM

PHP Code:


			
$sql = "SELECT * FROM table ORDER by lastname ASC";

That should do it "abcdef" or changing it to DESC will do "fedcba"

Limit it to 5 would be

PHP Code:


			
$sql = "SELECT * FROM table ORDER by lastname ASC LIMIT 0,5";

10-24-2007, 11:39 AM	#2 (permalink)
Gurnk The Contributor Join Date: Oct 2007 Location: US Posts: 66 Thanks: 19	PHP Code: `$sql = "SELECT * FROM table ORDER by lastname ASC";` That should do it "abcdef" or changing it to DESC will do "fedcba" Limit it to 5 would be PHP Code: `$sql = "SELECT * FROM table ORDER by lastname ASC LIMIT 0,5";`