Retrieving column properties

jumpup · #1 (**permalink**) 11-18-03, 21:26

Is there an SQL statement l can use from within PHP to extract all the column names, data types etc from a table?

Thanks in advance

P.S First post, this'll email when an answer happens right ?

jumpup · #2 (**permalink**) 11-19-03, 17:52

How about retrieving column names then ?

Would think there would be an SQL statement to do this ?????

ziobudda · #3 (**permalink**) 11-19-03, 18:38

Quote:

Originally posted by jumpup
Is there an SQL statement l can use from within PHP to extract all the column names, data types etc from a table?

Thanks in advance

for table:
mysql_query("show tables");

for columns
mysql_qeury("show columns from TABLENAME");

Try the query into mysql client and you understand how to use it under PHP.

bye from italy

jumpup · #4 (**permalink**) 11-19-03, 19:06

Thanks for the info zio

Actually will be running the command in visual basic this time round

Internet Services

Web Development

Digital Marketing

Consumer Tech