[SOLVED] Return column names in SQL using PHP

nate2099 · December 20th, 2007, 07:04 PM

Hi,

Is there any way to return an array containing the column names of a specific table??

Thanks,

Nathan.

c010depunkk · December 20th, 2007, 07:09 PM

Code:

SHOW COLUMNS FROM table_name

nate2099 · December 20th, 2007, 07:14 PM

Hey, thanks for that. But if I use this query:

Code:

  $sql = "SHOW COLUMNS FROM categories";
  $query = mysql_query($sql);

how do I now access this data??

Thanks,

Nathan.

nate2099 · December 20th, 2007, 07:15 PM

sorry, missed your link, will check that out

nate2099 · December 20th, 2007, 07:21 PM

Done.
thanks,

Nathan.

alexgeek · December 20th, 2007, 07:32 PM

Quote:

Originally Posted by nate2099

Hey, thanks for that. But if I use this query:

Code:

  $sql = "SHOW COLUMNS FROM categories";
  $query = mysql_query($sql);

how do I now access this data??

Thanks,

Nathan.

Try

Code:


			
$sql = "SHOW COLUMNS FROM categories";
  $query = mysql_query($sql);
$r = mysql_fetch_assoc($query);
echo $r['COLUMNS'];

nate2099 · December 21st, 2007, 10:54 AM

Hi Alex, for my purposes, and for anybody else who may find this thread..

Code:

$result = mysql_list_tables(db_name);
  while ($row = mysql_fetch_row($result)) 
  {
echo $row[0];
}

Seemed to work to list all tables sequentually.

Thanks guys, as always a great help!!

Nate.

alexgeek · December 21st, 2007, 10:57 AM

Great, thanks for posting your result.
Want to mark this thread as solved now?