Hi

I know that in mysql you can retrieve the number of rows from a table by using numrow, but is there a command that will count the number of columns?

My table has a varying number of columns and i need to loop through those columns in a specific row.

Any help much appreciated

Mark

I know one way to count the number of columns returned from each row is do a count of array elements from the returned row. Depending on the language you use, this will be a different method.

by "table" do you mean the recordset returned from the query? or are you creating temporary tables "on the fly"
Other than that, tables have a set number of columns normally determined at DB design time.

BTW there is no MySQL function for "numrow" , there is a PHP function of mysql_num_row if that is what you are meaning.