Getting column titles from MySQL

[Dean_Glass]

Hi all,

I wonder if anybody could help me with some column headings i'm trying to get hold of from my MySQL database. I have got the following code which gets the main elements of the record set:

if (! $rsL = mysql_query("SELECT * FROM cv WHERE cv_title='$cvname'",$conn))
		 {
		  die("Cannot Execute Query!".mysql_error());
		  }

while ($ar = mysql_fetch_row($rsL))
		{
			foreach ($ar as $col)
			{
				echo ("Title: <br>");
				echo ("<textarea rows=\"7\" cols=\"60\">");
				echo ($col);
				echo ("</textarea><br><br>");
			}

	}

Now, while this very nicely gets all the column fields that i require, I do not know how to get the actual column title? If anyone has any ideas i would be gratefull.

Thanx in advance,
DEAN

[khaldryck]

fairly easy :
use this function :

mysql_field_name()

you can read more about this here

[Dean_Glass]

Thanx for the tip and resource