[SOLVED] showing column name more than once

[dennismonsewicz]

I know how to get column names to show, but how would i show a particular column name to show more than once?

[r-it]

dude, we don't understand wht type of column you are talking about, give us a code example then we'll be sure to help

[dennismonsewicz]

oh sorry mysql column names is what I am talking about

 

 $sql = "SELECT * FROM table";
$query = mysql_query($sql,$connection);
$columns = mysql_num_fields($query);
for($i = 0; $i < $columns; $i++) {
    print mysql_field_name($columns,$i);
}

 

How would I display a particular mysql column name more than once?

 

IE: If I had a column name called Designer, and I needed to show that column name more than once, but just that particular column name

 

 

[dennismonsewicz]

I was able to figure it out

 

here is the code for those who might want to know

 

$sql = mysql_query("SELECT * FROM tbl_name") or die(mysql_error());
	echo mysql_field_name($sql, 3);

 

the number in the mysql_field_name array is the column name to display

 

Here is where this code came from:

 

http://aspn.activestate.com/ASPN/docs/PHP/function.mysql-field-name.html