Get the name of the column 2

Wow this is very very useful believe me, at least for me, but i have
two more questions, i have the next code:

while($row = sybase_fetch_assoc($result)) {
while(current($row)) {
$key = key($row);
$data = current($row);
print ("
".$key."
".$data);
next($row);
}
}
and i have a raw data like

Col1 Col2 Col3
------------------------------------------------------------ ---------------------
24/10/2007 07:30:52.000 PM 0 CENTRO

then the result is:

Col1
Oct 24 2007 7:30PM
Col3
CENTRO

so, question number 1) how can i do to preserve the original date
format (dd/mm/yyyy hh:mm:ss AM/PM
2) and most important, who can i do because when Col2 is 0 it is not
showed in the result but i want to show it

thanks for advanced

Re: Get the name of the column 2

On Tue, 30 Oct 2007 23:54:34 +0100, Jorge Reyes =
=

wrote:

> Wow this is very very useful believe me, at least for me, but i have
> two more questions, i have the next code:
>
> while($row =3D sybase_fetch_assoc($result)) {
> while(current($row)) {
> $key =3D key($row);
> $data =3D current($row);
> print ("
".$key."
".$data);
> next($row);
> }
> }
> and i have a raw data like
>
> Col1 Col2 Col3
> ------------------------------------------------------------ ----------=
-----------
> 24/10/2007 07:30:52.000 PM 0 CENTRO
>
> then the result is:
>
> Col1
> Oct 24 2007 7:30PM
> Col3
> CENTRO
>
> so, question number 1) how can i do to preserve the original date
> format (dd/mm/yyyy hh:mm:ss AM/PM

Well, show the query, normally database queries will return the stuff in=
=

the original format unless you ask otherwise. If your database doesn't, =
=

see it's documentation for handling date/time columns and formatting =

possibilities.

> 2) and most important, who can i do because when Col2 is 0 it is not
> showed in the result but i want to show it

Just use an foreach($row as $key =3D> $data)( echo "
".$key."
".$d=
ata; =

} instead of the inner while.
-- =

Rik Wasmus