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()