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

 

Reply via email to