SQL PHP HTML ASP JavaScript articles and free scripts to download

If you are facing any problem in viewing this page, please tell us

mysql_num_fields Functions to get number of fields returned in a query

WE can get the number of fields in our executed query by using mysql_num_fields function. This function returns the number of fields returned by the query.

Here is an example

$query="select * from student";
$result=mysql_query($query);
$fields=mysql_num_fields($result);
echo $fields;

The above code will print 4 as we have 4 columns in our student table.

Now let us change the query a bit ( only query part is changed and all other parts remain same )

$query="select name,id from student";

Now the output of the print command will display 2 ( not 4 ). So the function mysql_num_fields function returns the number of columns returned by the query.

Read how mysql_num_fields() is along with mysql_field_name function is used to display all column names of a table.

Download sql dump of student table

Not known	28-11-2009
The above code duplicates the value for each cell. Any fix?
smo	15-01-2010
Above code works perfectly. No problem.

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email	( not to be displayed)Privacy Policy
1+2=	This is to prevent automatic submission by spammers. Please enter the result of the sum as asked

Sections

SQL Tutorial List

mysql_affected_rows mysql_auto_increment mysql_close mysql_connect mysql_create_db mysql_db_name mysql_errno mysql_error mysql_fetch_field mysql_fetch_lengths mysql_fetch_row mysql_field_flags mysql_field_len mysql_field_name mysql_field_type mysql_insert_id mysql_list_dbs mysql_list_tables mysql_num_fields mysql_num_rows mysql_pconnect mysql_query mysql_select_db mysql_tablename

mysql_change_user mysql_data_seek mysql_db_query mysql_drop_db mysql_fetch_array mysql_fetch_assoc mysql_field_seek mysql_field_table mysql_free_result mysql_list_fields mysql_result

SQL site Map

Knowledge Management

Subscribe

Submit your email address and receive article and product notifications. Your email is safe with us.

mysql_num_fields Functions to get number of fields returned in a query

$query="select * from student"; $result=mysql_query($query); $fields=mysql_num_fields($result); echo $fields;

$query="select name,id from student";

$query="select * from student";
$result=mysql_query($query);
$fields=mysql_num_fields($result);
echo $fields;