Re: [PHP-DB] Get Names of columns of a table

2003-12-17 Thread CPT John W. Holmes 
From: <[EMAIL PROTECTED]>
> > is there a PHP function that wil return the names of the columns for a
> > given table?

> http://www.php.net/mysq_list_fields

Note: The function mysql_list_fields() is deprecated. It is preferable to
use mysql_query() to issue a SQL SHOW COLUMNS FROM table [LIKE 'name']
Statement instead.

Even if you're not using MySQL, the database should have a SHOW query or an
equivilent.

---John Holmes...

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Get Names of columns of a table

2003-12-17 Thread mike karthauser 
> is there a PHP function that wil return the names of the columns for a given
> table?

You need to use an SQL function called DESCRIBE

http://www.mysql.com/doc/en/DESCRIBE.html

HTH
-- 
Mike Karthauser 
Managing Director - Brightstorm Ltd

Email   >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
Tel >> 0117 9426653 (office)
   07939 252144 (mobile)

Snailmail   >> Unit 8, 14 King Square,
   Bristol BS2 8JJ

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Get Names of columns of a table

2003-12-17 Thread jeffrey_n_Dyke 

http://www.php.net/mysq_list_fields

hth
Jeff


   
 
  "Shaun"  
 
  <[EMAIL PROTECTED]To:   [EMAIL PROTECTED]
   
  .com>cc: 
 
       Subject:  [PHP-DB] Get Names of columns 
of a table   
  12/17/2003 08:30 
 
  AM   
 
   
 
   
 




Hi,

is there a PHP function that wil return the names of the columns for a
given
table?

Thanks for your help

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Get Names of columns of a table

2003-12-17 Thread Shaun 
Hi,

is there a PHP function that wil return the names of the columns for a given
table?

Thanks for your help

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php