dynamically checking mysql row type

[somaboy mx]

Is it possible to check the types of columns in a mysql resultset so you
don't need to know the type of data returned beforehand?

I'd like to be able to do something like:

if($coltype == "datetime") {
// parse date
}else if ($coltype == "varchar") {
// parse string
}

thx


..s

[Andy Hassall]

Re: dynamically checking mysql row type

On Sun, 17 Oct 2004 13:31:20 +0200, "somaboy mx" <none@nosuch.no > wrote:
[color=blue]
>Is it possible to check the types of columns in a mysql resultset[/color]

http://uk.php.net/mysql_field_type

--
Andy Hassall / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
<http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool

[somaboy mx]

Re: dynamically checking mysql row type

thank you!

..s