hola once more
php rookie here...with a slight problem.
Thanks to the tremendous help I received last night...i have mastered creating dynamic dropdown lists and describing database/table contents after they are selected...
I also know how to delete the tables/databases once they are selected...but now I have another problem...
once I delete a database using the dropdown menu and submit button, the database does get dropped...but the name of the database stays in the dropdown menu until i refresh the whole page...removing it. Here is my code...
";
$form.="Select School: <select ... >";
while ($row = mysql_fetch_row($result))
{
$form.="<option ... >$row[0]</option>";
}
$form.="</select>";
$form.="
<input ... >
";
#delete schools
$sql = "DROP DATABASE $schools";
if( mysql_query( $sql, $conn ) )
{
echo( "$schools successfully deleted" );
}
$form.="</form>";
echo( $form );
?>
is there something that i'm doing wrong or forgetting?
@xxxxx]::::::::::::::::::::::::::>*
Thanks to the tremendous help I received last night...i have mastered creating dynamic dropdown lists and describing database/table contents after they are selected...
I also know how to delete the tables/databases once they are selected...but now I have another problem...
once I delete a database using the dropdown menu and submit button, the database does get dropped...but the name of the database stays in the dropdown menu until i refresh the whole page...removing it. Here is my code...
";
$form.="Select School: <select ... >";
while ($row = mysql_fetch_row($result))
{
$form.="<option ... >$row[0]</option>";
}
$form.="</select>";
$form.="
<input ... >
";
#delete schools
$sql = "DROP DATABASE $schools";
if( mysql_query( $sql, $conn ) )
{
echo( "$schools successfully deleted" );
}
$form.="</form>";
echo( $form );
?>
is there something that i'm doing wrong or forgetting?
@xxxxx]::::::::::::::::::::::::::>*
