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
