[PHP-DB] Retrieve the field name itself instead of the info of the field name

[gert vonck]

hello everyone,

this is my code to retrieve info from my mysql db. This works perfect, but 
what i also want is a column before this column. In the first column, i want 
to see the field names from my table. So instead of selecting the info of 
the field names uitbater,straatnaam,... , I want to get uitbater 
itself.

How can I do this?

$result = mysql_query(SELECT uitbater, straatnaam, postcode, gemeente, 
provincie, telefoon, fax, email FROM info_general) or die (mysql_error());
$num = mysql_numrows($result);

printtable width=200 border=1\n;

while ($get_info = mysql_fetch_row($result))
{
foreach ($get_info as $field)
print \ttrtd$field/td/tr\n;
}
print /table\n;
mysql_close();


_



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

Re: [PHP-DB] Retrieve the field name itself instead of the info of the field name

[Mark]

Uwe mysql_fetch_array() to get a row into an associative array, or
use mysql_field_name()


--- gert vonck [EMAIL PROTECTED] wrote:
 hello everyone,
 
 this is my code to retrieve info from my mysql db. This works
 perfect, but 
 what i also want is a column before this column. In the first
 column, i want 
 to see the field names from my table. So instead of selecting the
 info of 
 the field names uitbater,straatnaam,... , I want to get
 uitbater 
 itself.
 
 How can I do this?
 
 
 $result = mysql_query(SELECT uitbater, straatnaam, postcode,
 gemeente, 
 provincie, telefoon, fax, email FROM info_general) or die
 (mysql_error());
 $num = mysql_numrows($result);
 
 printtable width=200 border=1\n;
 
 
   while ($get_info = mysql_fetch_row($result))
   {
 
   foreach ($get_info as $field)
   print \ttrtd$field/td/tr\n;
 
 
   }
 print /table\n;
   mysql_close();
 
 
 
 
 _
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


=
Mark Weinstock
[EMAIL PROTECTED]
***
You can't demand something as a right unless you are willing to fight to death to 
defend everyone else's right to the same thing.
***

__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com

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