table forms on the fly...

Anon

I am trying to create a page of the following format:

table name:
<a href=table fields>

with all table names that start with 'G' and I am totally lost!! :-(

I can retrieve the table names with mysql_list_tables can't figure out how to print the names I want that start with G (i.e. how do I set up the SELECT statement)?

This isn't working:

$result = mysql_list_tables($dbname);
while ($myrow = mysql_fetch_row($result)); {

$result1= mysql_query("SELECT * FROM $dbname WHERE $myrow LIKE 'G%'");

while ($myrow = mysql_fetch_array($result1))

Anon

Hi!
You can use this...

$result = mysql_list_tables($dbname);
$i = 0;
while ($i < mysql_num_rows ($result)) {
$tb_names[$i] = mysql_tablename ($result, $i);
if (ereg("^{[G]+",$tb_names[$i]))}
echo $tb_names[$i] . "<BR>";
$i++;
}

Anon

thanks, that worked great!! can I pass the results of this into other expressions though? I want to create a listing of our products on a page with one <TABLE> going to each product table in the database (each of which starts with G). I want the page to be dynamic so I can add new product categories (database tables) and have the webpage generate the new table listing on the fly.

thus-I have multiple tables starting with G that I want to dump their rows into table rows. How can this be done? I currently have it set up to fetch thetable fields from the database and create the hyperlink list (to specific products) on the fly, but I have to add general product categories (tables) by hand.

can I take the output from the previous command that gives me a listing of all tables in the dbase that start with G, dump them into an array, then output that into a WHILE loop to generate tables within a webpage?

TIA,
/frank

Anon

Yes, u can do that, infact the result is in the array, instead of echoing it, u can give the respective SELECT statements for each array element and thus get the result in the form of a table.

It should help u.

Anon

Can't seem to get it to work, here is the code I am using just to dump the tablenames into a listing. Figure I would start simple to make sure things work before dumping it into a while loop with <TABLE> setups.

can you see what I am doing wrong to select the tablenames that just start with G then dump that into a table. this is giving me a parse error, think it is due to what I am calling 'names' in the printf statement, any ideas?

<?php
$db = mysql_connect("hostname","username","password") or DIE("Sorry, couldn't con
nect");
mysql_select_db("database",$db);
$result = mysql_list_tables("database");
while ($i < mysql_num_rows ($result)) {
$names[$i] = mysql_tablename ($result,$i);
//echo $names[$i] . "<BR>";
$i++;
} do {
$result1 = mysql_query("SELECT * FROM $names[$i] WHERE $names[$i]='G%'");
while ($row = mysql_fetch_array($result1)) {
printf("<TR>%s</TR>\n", $row[names]);
}
?>

thanks,
/frank