Menu
Community /Pin to ProfileBookmark
@NogDogApr 28.2005 — #You could do something like this, perhaps:
listing fields
Hi, what i need to do is list the fields within a table. I have used the mysql_list_fields function and that works great for someone who knows how to read it. However I need to show this to a client and all I need is the actual field name and not the type, null, and extra options. Thank you.
Jason
Sign in
to post a comment3 Comments(s) ↴
0
@NogDogApr 28.2005 — #You could do something like this, perhaps:[code=php]
$query = "SELECT * FROM table LIMIT 1";
$result = mysql_query($query);
if($row = mysql_fetch_assoc($result))
{
echo "<p>The fields in the table are:</p>n<ul>n";
foreach($row as $field => $value)
{
echo "<li>$field</li>n";
}
echo "</ul>";
}
else
{
echo "<p>Oops! Query didn't work.</p>n";
}
[/code]