Topic awaiting preservation: MySQL Listing Alphabetical (Page 1 of 1)

Ok, I have a website where I post tutorials on. Now I have all my tutorials in SQL with the following table

id - Number Incremented
title - Title of Tutorial
description - Description of tutorial
picture - pretty self explanatory
date - Date uploaded
tutorial - the tutorial itself

Now On the tutorial selection Page, I want to list all the tutorials Alphabetically according tot he first letter in the 'title' column

IS there any way to do that in PHP?

The ORDER BY clause is alphabetical by default, ASC (ascending)

SELECT * FROM table ORDER BY title ASC

__________________

Jon Kriek
www.phpfreaks.com

And just to clarify slightly, it's not in the PHP, it's right in your SQL - let the database do the work whenever possible.

and read at least the select section in the mysql manual... there are a number of such goodies that the database can handle for you.