How Do I Display a table description (PHP/MySQL question)
am 06.01.2008 15:23:49 von none
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
Re: How Do I Display a table description (PHP/MySQL question)
am 07.01.2008 01:35:14 von none
Thanks for all the responses sent directly to me. I have it working now.
""none"" wrote in message
news:02.8B.16968.B74E0874@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
Re: Re: How Do I Display a table description (PHP/MySQL question)
am 27.01.2008 07:03:56 von Aaron Schiff
------=_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 wrote:
> Thanks for all the responses sent directly to me. I have it working now.
>
> ""none"" wrote in message
> news:02.8B.16968.B74E0874@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--