[blinn_shade]

hey,

I have this code:

PHP Code:

## SHOW TABLES



function show_tables(){

    global $table_show_array;

    

    echo '<select name="dbtable">';

    

    $result = mysql_query("SHOW TABLES FROM `".CONFIG_DB_NAME."`");

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

        

        if(in_array($row[0], $table_show_array)){

        }else{

        

            $result2 = mysql_query("SELECT * FROM `".$row[0]."`");

            $num = mysql_num_rows($result2);

            

            echo '<option value="'.$row[0].'">'.$row[0].' ( '.$num.' )</option>';

        }

    }

    

    echo '</select>';

} 

It did once put all the tables in a drop down but now it has just stopped working. Does anyone know another to do this?

Thanks.

[End User]

When you say "just stopped working", does it show anything at all? Is the dropdown completely blank or does it have any values at all in it? Are you seeing any error messages?

[blinn_shade]

This is what I see. Just blank values.

[End User]

When it was working did it use the parentheses that are showing in the image there? If not, I'd say that's a clue. If it just suddenly stopped working, something changed....was any code altered around the same time or anything else done?

It looks to me like the variable $num is not being filled or evaluated, and what's left are just the parentheses that surround it.

Try this....instead of this line:

echo '<option value="'.$row[0].'">'.$row[0].' ( '.$num.' )</option>';

...use this line and tell me if there's any difference:

print "<option value=\"$row[0]\">$row[0] ($num)</option>";

Finally, if you view the source of the dropdown in the page, does it show any values in the 'option value=' sections?

[frosty1433]

try this:
error_reporting(E_ALL);

[aycintl]

your code looks good. maybe there were a changes made in your database, specially the column name or table name.

try comparing your code from your database. maybe the column name is not "0" but maybe its something else like $row['column_name']

[blinn_shade]

None of the above worked. Still the same. I am wondering if it is something to do with the mysql privileges because my tables in there are all empty, I think I deleted them.

I have easyPHP installed on my machine, can anyone export the data from the database : information_schema and the table : USER_PRIVILEGES.

Thanks.

[End User]

Originally Posted by blinn_shade

my tables in there are all empty, I think I deleted them.

Umm, yeah, that could do it.

Originally Posted by blinn_shade

I have easyPHP installed on my machine, can anyone export the data from the database : information_schema and the table : USER_PRIVILEGES.

Are you asking someone here to login to your system and try an export??

[blinn_shade]

No.
I am asking if anyone would paste the SQL so I can import it.

[blinn_shade]

Ok I fixed it. Here is how I done it:

I used a foreach loop on the $row varible.