In writing my SQL parser, I need some functions written that get some information from MySQL, and I'm not sure of the best way to go about them.
Could somebody please help me with: // returns current database name as string PMA_INFO_getDB() //returns array of table names in given database PMA_INFO_getTables($DBName) //returns array of tables names in current database PMA_INFO_getTables() //returns array of column names in given table PMA_INFO_getColumns($TableName) //returns array of column names in given table inside given database PMA_INFO_getColumns($DBName,$TableName)
Thanks in advance