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 PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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. Therefore, the query only returns the fields if the table exists. > > > > Is that what you wanted? That's how I understood your question.... > yes, this is what i want, now to get the name of fields and i should use > MYSQL_FIELD with the result returned from the query like > MYSQL_RES * res; > MYSQL_FIELD *field; > mysql_query(my," show columns from foo.bar"); > res = mysql_use_result(my); > for (i:= 0; i<=mysql_num_rows(res); i++) > { > field=mysql_fetch_field_direct(res,i); > do ant thing with field > > Right > > 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 List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]