how to dsiplay data from a checked table & to retain if unchecked

je_vaughn

I am trying to crate a displaying page in where i'm able to display all the content of my MySQLdatabase thats checked and only those that are so!
The database will hold the data from the form and i'll like to create a page which would work like a content management, in where i could check and uncheck the tables which i want to be displayed.
thanks in advance ,I will deffinitely appreciate any help in this matter!

devinemke

not sure i understand you. you want to list the tables from a database and have checkboxes next to each table? if so then do a SHOW TABLES query:

<form action="" method="POST">
tables:<br>

<?php
$result = mysql_query('SHOW TABLES');
while ($row = mysql_fetch_row($result))
{
	echo '<input type="checkbox" name="tables[]" value="' . $row[0] . '">' . $row[0] . '<br>';
}
?>

<input type="submit" name="submit" value="submit">
</form>

then use $_POST['tables'] to form what ever specific query you want.

je_vaughn

first and foremost, thanks for your help!
the script you gave me works but just not the way i intend for it to work. the problem beign that i was not specific.
This is the basics! i am creating a site inwhere people are able
to place ads. these ads are displayed for all to see in a displaying page. so through a form they fill in the data, this data goes to the database and because the displaying page queries the database, the content will immidiately be displayed! I need to have a sort of content management system here in where one of my database field is a hidden field in the form itself but visiable in my updating page, as a checkbox. so that i may check or uncheck this field which contains the data inserted into the table before it would be displayed.
So thats it. its just that i don't know how to go about it! whether this query would go into the displaying page and or in the updating page or just in the form page! and what would be the query itself. I would deffinitely appreacite any step by step that you can provide!