What i want to do... is a little wierd... but help wanted!

[DoD]

Is there a way that i can get MySQL to search the database for all tables with the name *_config? and THEN select a value from each of them and then process that?

effectively, all i need to do is a search which will return the names of the tables which contain *_config... if possible???

even better would be a forumsconfig (obviously where = anything)

Thanks for any help 🙂

[John_Canyon]

No you cannot do that, however you could plug the values of * into an array and loop through each table, stacking an array with the values you want.

$array = (table1,table2,table3);
$cArray = array();

for($i=0;$i<count($array);$i++)
{
   $sql = mysql_query("SELECT * FROM forum_".$array[$i]."_config ");
   while($row = mysql_fetch_array($sql))
   {
         array_push($cArray,$row[value]);
   }
}

[EgoManiac]

i think you might be able to use the sql query "SHOW TABLES" to get the list of all the tables, then compare each name with *_config.