Re: query only that return the fields that an table existe

2004-02-18 Thread Ligaya Turmelle
Go here http://www.php.net/manual/en/function.mysql-field-type.php in the PHP manual and you will find in example 1 how to get all the information about a table. You can then pare it down just to get the information you want. Respectfully, Ligaya Turmelle ""Luiz Rafael Culik Guimaraes"" <[EMAIL

Re: query only that return the fields that an table existe

2004-02-18 Thread Luiz Rafael Culik Guimaraes
Hi Rhino > If your table name is bar and it is in a database named foo, the following > commands will show you the columns in that table: > > describe foo.bar; > > -OR- > > show columns from foo.bar; > > If you try either command on a table that does not exist, you get an error > message. Therefo

Re: query only that return the fields that an table existe

2004-02-18 Thread Rhino
the fields if the table exists. Is that what you wanted? That's how I understood your question Rhino - Original Message - From: "Luiz Rafael Culik Guimaraes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 18, 2004 10:35 AM Subject:

query only that return the fields that an table existe

2004-02-18 Thread Luiz Rafael Culik Guimaraes
Dear Friends as subject. is this possible if yes, how to get the field names returned Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.588 / Virus Database: 372 - Release Date: 13/2/2004 -- MySQL General Mailing Li