Re: showing any mysql query in a table, help!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Mar 19, 2006 at 05:12:06AM +0000, pgaio@xxxxxxxxxxxxxxx wrote:
> Ok...
> it has to be a way to do such a thing.
> I do i get the column names?
> I can get the number of columns using mysql_num_fields() right?
> but what if i want to get the columns name? Wich functtion and how should i use?

  http://php.net/mysql_fetch_field

Something like:

$result = mysql_query($sql);

$j = mysql_num_fields($result);
for($i = 0; $i < $j; $j++ ) {
  $field = mysql_fetch_field($result, $i);
  echo $field->name;
}


Curt.
-- 
cat .signature: No such file or directory

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux