what's the matter with using mssql_num_fields() and get the answer directly.
$fields = mysql_list_fields("$db", "$table", $link); $columns = mysql_num_fields($fields); Hugh ----- Original Message ----- From: "Mark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "John Holmes" <[EMAIL PROTECTED]> Sent: Monday, June 10, 2002 1:18 AM Subject: RE: [PHP] PHP function for listing number of columns in table yes, I think getting the result set for 'describe $table' or 'show fields from $table' and then doing mysql_num_rows() on that is best because it will return right away and will work for empty tables as well. On Mon, 10 Jun 2002 09:00:41 +0100, Tim Ward wrote: >Just off the top of my head wouldn't describe then mysql_num_rows() >be a lot >more efficient. > >Tim Ward >www.chessish.com <http://www.chessish.com> >[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > ---------- > From: John Holmes [SMTP:[EMAIL PROTECTED]] > Sent: 09 June 2002 18:29 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: [PHP] PHP function for listing number of columns in >table > > No. There is, however, a function that'll tell you how many columns >are > in a result set. So, if you select all columns, then you can use >that > function to find out how many columns are in the table. > > www.php.net/mysql_num_fields > > ---John Holmes... > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, June 09, 2002 12:54 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP] PHP function for listing number of columns in table > > > > Pardon the probably stupid question but, > > > > Is there a PHP function for listing number of columns in a mySQL > table? > > > > Thanks in advance > > > > JJ Harrison > > [EMAIL PROTECTED] > > www.tececo.com > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php