<? mysql_connect("localhost","root",""); mysql_select_db("mydatabase"); $query = "SELECT id as ID, title FROM mytable ORDER BY title"; $result = mysql_query($query); $row = mysql_fetch_row($result); echo mysql_field_table($result, 0); ?>