Re: [PHP-DB] Get Names of columns of a table
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
> 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
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
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