need some help - froms from mysql db

Thread title: need some help - froms from mysql db

Thread tools Search this thread Display Modes

09-06-2007, 12:11 AM

#31

Salathe

Status: Community Archaeologist
Join date: Jul 2004
Location: Scotland
Expertise: Software Development
Software: vim, PHP

Posts: 3,820

iTrader: 25 / 100%

Salathe will become famous soon enough

Try the following PHP and tell us what it outputs, if anything.

PHP Code:


			


    $sql = "SHOW TABLES LIKE 'cms_%'";

    $query = mysql_query($sql);

    

    $rows = array();

    while($row = mysql_fetch_array($query)) {

        $rows[] = substr($row[0], 4);

    }



    if (count($rows) == 0) {

        echo 'No tables matching <strong>cms_</strong>...';

    } else {

        echo implode('<br>', $rows);

    }