Displaying Column Names

[Lyleyboy]

Morning all,

 

I have a question regarding the ability to show the column names from my table/query.

What I'm looking to do is to be able to have my users enter their own query via a builder (Which I haven't built yet).

I've found a little test script from the net but it shows them in an array.

 

My code is

<?php
  
include('includes/inc.conn.php');
  
mysql_select_db("discover_messaging");


$result = mysql_query("SHOW COLUMNS FROM `messages`");

if (mysql_num_rows($result) > 0) {
    while ($row = mysql_fetch_assoc($result)) {
        print_r($row);
    }
}
    
?>

 

Which outputs

Array ( [Field] => msg_id [Type] => int(11) [Null] => NO [Key] => PRI [Default] => [Extra] => auto_increment ) Array ( [Field] => msg_to [Type] => varchar(99) [Null] => NO [Key] => [Default] => [Extra] => ) Array ( [Field] => msg_from [Type] => varchar(99) [Null] => NO [Key] => [Default] => [Extra] => ) Array ( [Field] => msg_subject [Type] => varchar(255) [Null] => NO [Key] => [Default] => [Extra] => ) Array ( [Field] => msg_body [Type] => text [Null] => NO [Key] => [Default] => [Extra] => ) Array ( [Field] => read_flg [Type] => varchar(3) [Null] => NO [Key] => [Default] => off [Extra] => ) Array ( [Field] => sent_date [Type] => varchar(255) [Null] => NO [Key] => [Default] => [Extra] => )

 

Is there a way to have the field names come out of the array so that I can do something like?

<table>
<tr>
<td>msg_id</td>
<td>msg_to</td>
etc ...

 

Thanks all.

 

[Lyleyboy]

Hi all,

 

Tried a slightly different way.

 

$sql="SHOW COLUMNS FROM `messages`";

$result = mysql_query($sql) or die(mysql_error());
while ($get_info = mysql_fetch_row($result)) {
  foreach ($get_info as $column) {
    echo $column;
  }
}

 

and got

msg_idint(11)NOPRIauto_incrementmsg_tovarchar(99)NOmsg_fromvarchar(99)NOmsg_subjectvarchar(255)NOmsg_bodytextNOread_flgvarchar(3)NOoffsent_datevarchar(255)NO

 

Nearly there but also kind of not.

How do I get shut of the rubbish. I just want the emboldened bit  msg_idint(11)NOPRI

 

Thanks in advance.

[trq]

<?php
  
include('includes/inc.conn.php');
  
mysql_select_db("discover_messaging");


$result = mysql_query("SHOW COLUMNS FROM `messages`");

if (mysql_num_rows($result) > 0) {
    while ($row = mysql_fetch_assoc($result)) {
        echo $row['Field'];
    }
}
    
?>

[Lyleyboy]

Flippin marvellous.

 

Thanks.

 

How do I mark as solved?

[Lyleyboy]

Ok, Another thought.

 

Will this work on a joined table query?