Page 1 of 1

retrieving database fields name

Posted: Fri Feb 27, 2009 5:14 am
by naeem1984
i retrieve the data from database using following code

Code: Select all

 
while ($row = (mysql_fetch_array($result1)))
   {
        
        echo $row["auto#"]."<br>";
        echo $row["name"]."<br>";
        echo $row["email"]."<br>";
   
   }
 
but i want to retrieve the database fields name from database which are
auto#,
name,
email

Re: retrieving database fields name

Posted: Fri Feb 27, 2009 5:51 am
by jayshields
I don't really understand why you'd need to do this. Is it dynamic query generation or something? You could just use array_keys() on $row inside the while loop.

Maybe a DESCRIBE query is what you're after.

Re: retrieving database fields name

Posted: Fri Feb 27, 2009 5:52 am
by VladSun

Code: Select all

while ($row = (mysql_fetch_array($result1)))
        foreach ($row as $key => $value)
              echo $key . " =  " . $value . "<br />";
PS: jayshields is right - you need to clarify your question.

Re: retrieving database fields name

Posted: Fri Feb 27, 2009 7:00 am
by naeem1984
how avoid indexes which shows with keys and values

Code: Select all

 
foreach ($row as $key => $value)
    {
           echo  "<td>".$key ."</td>";
    }
 
it shows the field name with indexes
e.g
0 auto#
1 name
2 email
3 person

how avoid indexes

Re: retrieving database fields name

Posted: Fri Feb 27, 2009 8:57 am
by VladSun
mysql_fetch_assoc()