Get the name of the column

hi there, this is very useful for me, so my issue is, when i use a
$result = sybase_query("sp_something")
while($r = sybase_fetch_array($result)) {
etc.....

how can i get the name of the columns? for example for the raw data

Col1 Col2 Col3
-------------------------------------
hi 15 other value


how can i get the values "Col1", "Col2", "Col3"....
please, thanks for advanced.

Re: Get the name of the column

while ($row = sybase_fetch_assoc($result))
{
while (current($row)) // or while (current($row) != false)
{
$data = current($row);
$key = key($row);

//
// do stuff here
//

next($row);
}
}

Re: Get the name of the column

Jorge Reyes wrote:
> hi there, this is very useful for me, so my issue is, when i use a
> $result = sybase_query("sp_something")
> while($r = sybase_fetch_array($result)) {
> etc.....
>
> how can i get the name of the columns? for example for the raw data
>
> Col1 Col2 Col3
> -------------------------------------
> hi 15 other value
>
>
> how can i get the values "Col1", "Col2", "Col3"....
> please, thanks for advanced.
>

The fetch_array functions return an associative array, where the keys
are the column names. So to get an array of the column names, you can
use the array_keys function:

$keys = array_keys($result);

More info:
http://us3.php.net/manual/en/function.array-keys.php

Jeremy