[PHP-DB] Help displaying Column Names

2006-09-14 Thread Grant Griffith
Hello All,

 

I am fairly new to PHP but have coded in asp and asp.net for years.  I
am trying to find the code that will allow me to display the name of the
column's from the table I am using.  Below is the code where I am
writing all the data out in a comma delimited fashion, but I want to
make the very first row show the name of the database table names.  For
example I want to show the ID,Name,Address, etc...

 

Can someone tell me what that command is in PHP?  I have searched and
can not find anything, I guess I am searching for the wrong info as I
know it can be done!!!

 

code snippet

$sel_result = mysql_query(select * from customerdata where account_type
= '$tmpType',$db);

 

//Now loop thru account types and show the one selected

while($sel_row=mysql_fetch_array($sel_result))

  {

  print
\$sel_row[0]\,\$sel_row[1]\,\$sel_row[2]\,\$sel_row[3]\,\$sel_
row[4]\,\$sel_row[5]\,\$sel_row[6]\,\$sel_row[7]\,\$sel_row[8]\
,\$sel_row[9]\,;

  print
\$sel_row[10]\,\$sel_row[11]\,\$sel_row[12]\,\$sel_row[13]\,\$
sel_row[14]\,\$sel_row[15]\,\$sel_row[16]\,\$sel_row[17]\,\$sel_
row[18]\,\$sel_row[19]\,;

  print
\$sel_row[20]\,\$sel_row[21]\,\$sel_row[22]\,\$sel_row[23]\,\$
sel_row[24]\,\$sel_row[25]\,\$sel_row[26]\,\$sel_row[27]\\n;

  }

/codesnippet

 

Thanks,

Grant Griffith

Web Application Developer

Enhanced Telecommunications

http://www.etczone.com

812-932-1000

 



Re: [PHP-DB] Help displaying Column Names

2006-09-14 Thread Dimiter Ivanov

On 9/14/06, Miguel Guirao [EMAIL PROTECTED] wrote:



You haven't searched at all, go to www.php.net and look up for
mysql_field_name() and related functions!!

-Original Message-
From: Grant Griffith [mailto:[EMAIL PROTECTED]
Sent: Jueves, 14 de Septiembre de 2006 10:22 a.m.
To: php-db@lists.php.net
Subject: [PHP-DB] Help displaying Column Names


Hello All,



I am fairly new to PHP but have coded in asp and asp.net for years.  I
am trying to find the code that will allow me to display the name of the
column's from the table I am using.  Below is the code where I am
writing all the data out in a comma delimited fashion, but I want to
make the very first row show the name of the database table names.  For
example I want to show the ID,Name,Address, etc...



Can someone tell me what that command is in PHP?  I have searched and
can not find anything, I guess I am searching for the wrong info as I
know it can be done!!!



This functionality is related to the database you are using. Thus you
have to look into the functions that PHP provides for this database.

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