How do you display a table description that is part of a MySQL (v. 5.0)
database via PHP (v. 5.2) web page?

Thanks

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

Thanks for all the responses sent directly to me. I have it working now.

""none"" <ng [at] photobugbytes.com> wrote in message
news:02.8B.16968.B74E0874 [at] pb1.pair.com...
> How do you display a table description that is part of a MySQL (v. 5.0)
> database via PHP (v. 5.2) web page?
>
> Thanks

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

------=_Part_5767_4378730.1201413836979
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Didn't even realize I sent it to you directly...I'm sending it to the list
to archive it.

Here's what I said:

For displaying table comments:
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA =
'your-table-name'

For displaying column comments:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA =
'your-table-name'

On Jan 6, 2008 6:35 PM, none <ng [at] photobugbytes.com> wrote:

> Thanks for all the responses sent directly to me. I have it working now.
>
> ""none"" <ng [at] photobugbytes.com> wrote in message
> news:02.8B.16968.B74E0874 [at] pb1.pair.com...
> > How do you display a table description that is part of a MySQL (v. 5.0)
> > database via PHP (v. 5.2) web page?
> >
> > Thanks
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


--
ts2do

------=_Part_5767_4378730.1201413836979--