PHP drop down list not generating

Question

I need help regarding my PHP drop down list. I've created a Database call state. I'm trying to populate a state drop down on an html page using php connecting to mysql. Here is my code for the html page:

<form action="CreateUser.php" method="POST">
            <label type='text'>State:</label>
            <select name='state'>
            <option value='0'>--Choose a State--</option>
            <?php   
                    $dbTable='states'
                    $QueryResult=msql_query('Select * from       "$dbTable"'); 

                    while($Row = mysql_fetch_assoc($QueryResult))
                    {
                    ?>
                        <option value="<?php echo $Row['StateID']; ?>">
                            <?php echo {$Row['StateName']}; ?>
                        </option>

            <?php   } ?>

            </select>


            <input id='movebutton' type = "Submit" name="submit" value="submit"/>
        </form>

And here is my PHP code for the dbconnection:

$DBName = "business"; 
$DBConnect = @mysql_connect("localhost", "root", "");

if($DBConnect === FALSE)
{
    echo "<p>Unable to connect to the database server.</p>" . "<p>Error code " . mysql_errno() . ": " . mysql_error() . "</p>"; 
}
else 
{       

    $DB = mysql_select_db($DBName, $DBConnect); 

    if(!$DB)
    {
        echo "<p>Unable to connect to the database server.</p>" . "<p>Error code " . mysql_errno() . ": " . mysql_error() . "</p>";

        mysql_close($DBConnect); 
        $DBConnect = FALSE; 
    }

}

Can someone tell me what I'm doing wrong? I've checked on this forum and also on YouTube regarding PHP dropdown. I'm new to php and still learning.

are you sure you have put correct credentials and server information of db? — abmussani
– abmussani, Commented Apr 11, 2014 at 15:24

Kraang Prime · Accepted Answer · 2014-04-11 15:24:33Z

1

The query is invalid. It should be as follows:

$QueryResult=msql_query("Select * from `$dbTable`");

answered Apr 11, 2014 at 15:24

Kraang Prime

10.6k11 gold badges66 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Terry Seidler Over a year ago

Yeah. ' and " are not the same in PHP, that's where a big part of your problem lies :).

SagarPPanchal · Accepted Answer · 2014-04-11 15:37:02Z

0

Update your query like $QueryResult=msql_query("Select * from '$dbTable'"); and also

Remove Curly braces inside option, or replace this code

<option value="<?php echo $Row['StateID']; ?>">
                            <?php echo $Row['StateName']; ?>
                        </option>

edited Apr 11, 2014 at 15:37

answered Apr 11, 2014 at 15:31

SagarPPanchal

10.2k6 gold badges36 silver badges66 bronze badges

Collectives™ on Stack Overflow

PHP drop down list not generating

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related