List of tables with links to details

stanforrest

I am stuck. I created a ticket tracking system last year for a client. My client really like the system and has asked for a few added features, so now I am working on the next generation of the program.

I now have created one page with both search and update functions on the same page. You can search a table in the database and the records you search for are returned to the same page and then you can update multiple fields with one submit. On this same page you can create a new table in the database, which automatically has all data dumped into it from a Master Table. On the left hand side of this same page a list of all tables in the database is created.

Now it is at this point I am stuck as to what to do. The tables that are listed on the left hand side of the page need to be links as well, so when a user clicks on one of them, all records in that table will be shown on the page for searching and updating. Not quite sure as to how to do this. Below is my code that creates the list of tables.

$db = mysql_connect("localhost","username","password");

mysql_select_db ("databasename");

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

{
mysql_close($db);
}

Please help this is the last thing needed for the backend of the program.

stanforrest

Okay I have now changed my code to the following

$db = mysql_connect("localhost","username","password");

mysql_select_db ("databasename");

$q = mysql_query("show tables");
while ($row = mysql_fetch_row($q)) {
echo "<a href=details_test2.php?lang=en-iso-8859-1&server=1&db=databasename&table=$row[0]>$row[0]</A><br>";
}

{
mysql_close($db);
}

Now this code does create a link and seems to be selecting the proper table, I think but the results still do not show the choosen table on the details page. may be I need to change my content source code at the top of the details page?

Currently it looks like this

<?php // GoLive Content Source
$Tickets = WrapMySQLDatabaseResults("ticketwizard", "select * from Master_Table where TicketLevel like '%" . pageParameter("TicketLevel","") . "%' and TicketSection like '%" . pageParameter("TicketSection","") . "%' and TicketRow like '%" . pageParameter("TicketRow","") . "%' and TicketSeat like '%" . pageParameter("TicketSeat","") . "%' and TicketStatus like '%" . pageParameter("TicketStatus","") . "%' and TicketFName like '%" . pageParameter("TicketFName","") . "%' and TicketLName like '%" . pageParameter("TicketLName","") . "%'", "block=20","Tickets");
?>

This code only returns the details of all records in the Master_Table.

How would I replace the Master_Table in the "select * from Master_Table where" clause to be a variable. So when a link from the table list is clicked it will retrieve records from the right table?