Echo tables which contain the column userid

[JMH11788]

I'm trying to write a code which reads the tables in the database and then reads the columns within those tables. If the table has a column "userid" then I want to echo the table name.

I've tried a bunch of different things and get mixed results.

Here is where I stand right now:

PHP Code:

$table = $vbulletin->db->query("SHOW tables");
while ($row = mysql_fetch_object($table)) {
    foreach($row as $key=>$value):
        $query = $vbulletin->db->query("SHOW COLUMNS FROM  "."".$value."");
        while ($row2 = mysql_fetch_object($query)) {
            foreach($row2 as $key2=>$value2):
                if ($value2 = 'userid') {
                    print $value." = ".$value2."<br>";
                }
            endforeach;
        }
    endforeach;
} 


Any help is greatly appreciated.

Thanks!

EDIT: Nevermind, I got it working!