<?php mysql_connect("localhost","root",""); mysql_select_db("mydatabase"); $query = "SELECT id, title FROM mytable ORDER BY title"; $result = mysql_query($query); echo "Total number of fields returned: ".mysql_num_fields($result).".<br />"; ?>