is there a way that i can display a list of the tables...

[dv6cougar]

but only show the ones that have data records in them?

say i have 2 tables...

one is php

other being html.

now html is empty at the moment.

how can i display just a few rows of information from the table php.

$query = "SELECT *FROM ";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {


echo "Type: ".$row["2"];
}

kind of like that, but only from tables that have records.

i'm sure there is one that will display all table names, but I haven't been able to find it on mysql.com

thanks alot.

[dv6cougar]

well i got hafl this myself here... i got it to list my tables...

2 minor problems, it's not supposed to list one table called admin....

which i can fix myself a different way and I probably will becuase what's the sense of having admin inside the rest of the tables? opps..

anyway, this displays my tables, but in one big group!

<?php
    error_reporting(E_ALL);

include("admindb.php");
$db_list = mysql_list_tables($db);

$i = 0;
$cnt = mysql_num_rows($db_list);
while ($i < $cnt) {
    echo mysql_db_name($db_list, $i) . "\n";
    $i++;
}
?>

they show up all scrunched, the \n doesnt' seem to affect it the way it should... but if i was to list them like that they would get huge anyway.

so I'm thinking of just displaying the table names by hand in Html and having them link to pages that show their respective needs. Maybe do an mysql_num_rows query to show how many parts are avialable within the different tables(categories from a store)....

thanks again.

Thanks alot, any info is greatly appreciated.

[cgraz]

\n is a newline, not a line break. All it does is cause your code to be placed on a new line.

<td>\ntext\n\nhello

would output in your source as

<td>
text

hello

but to html, you can have as many newlines as you want and it makes no difference. To actually put something on a seperate line, you need to use <br>

text<br><br>hello

Cgraz

[dv6cougar]

ah ok, my fault i thought \n and <br> was the same thing.

anyone else have any suggestions? the long way is gonna take me a long time 🙁