hola once more

    Date: 08/09/05 (PHP Community)    Keywords: php, database

    [Error: Irreparable invalid markup ('') in entry. Owner must fix manually. Raw contents below.]

    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...

    #connect to mysql

    $conn = mysql_connect( "localhost", "", "" )
    or die( "Am I using the right file?" );
    #define variables

    $result = mysql_list_dbs($conn);
    $self = $_SERVER['PHP_SELF'];
    $schools = $_POST['schools'];
    #list schools

    $form = "
    ";
    $form.="Select School:  ";
    $form.="


    ";
    #delete schools

    $sql = "DROP DATABASE $schools";
    if( mysql_query( $sql, $conn ) )
    {
    echo( "$schools successfully deleted" );
    }
    $form.="
    ";
    echo( $form );
    ?>

    is there something that i'm doing wrong or forgetting?
    @xxxxx]::::::::::::::::::::::::::>*

    Source: http://www.livejournal.com/community/php/333205.html

« using postnuke for subdomains? || The Holy Grail of PHP »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home