PHP/MySQL Database/mysql num fields

mysql_list_fields.php

   <source lang="html4strict">

<? mysql_connect("localhost","root",""); $fields = mysql_list_fields("mydatabase","password"); echo mysql_num_fields($fields); ?>

 </source>
   
  

mysql_num_fields.php

   <source lang="html4strict">

<?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).".
";

?>

 </source>