D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] PHP and recordsets

 

What db access/abstraction layer are you using?
With direct mysql functions you could use mysql_fetch_field() for column info

Most databases make the metadata (or data dictionary) available for
querying via SQL.

Perhaps pphpmyinfo source will help if mysql?

Steve


2008/9/14 Tom Potts <tompotts@xxxxxxxxxxxxxxxxxxxx>:
> I'm trying to do some dynamic database stuff - ie I will have unknown data in
> multiple recordsets. Does anyone know how to do the following in php:
> Get the next recordset in a result set.
> Get field data - name,type etc from a recordset
>
> the data obviously there as print_r seems to display it but I seem to be
> having a senior moment on this one
> Tom te tom te tom
>
>
> --
> The Mailing List for the Devon & Cornwall LUG
> http://mailman.dclug.org.uk/listinfo/list
> FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html
>



-- 
Steve Lee
Open Source Assistive Technology Software and Accessibility
fullmeasure.co.uk

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html