dropdown populate from db and update db

[gab]

Hi I am very new to this and is stuck trying to make this work... :-(

I want a 2 dropdown box'es which is populated from a mysql db (that I can do, I think :-p )
[PHP]
$sql="SELECT X FROM table WHERE Y=Z";
$result=mysql_query($sql);

$options="";

while ($row=mysql_fetch_array($result)) {

$X=$row["X"];
$options.="<option VALUE=\"$X\">".$X.'</option>';
}
?>

<SELECT NAME=something>
<OPTION VALUE=0>choose
<?php echo $options ?>
</SELECT>[/PHP]

I then want a button which runs a mysql update with the selected input in the dropdown boxes

the DB table is:
name
choice1 (should be from dropdownbox1)
choice2 (should be from dropdownbox2)

also (if possible) I would like that the selected value is the one that is the one in the db.

Really hope someone can help me :-)

[pbmods]

Heya, gab. Welcome to TSDN!

For XHTML compliance, consider making your tags all lowercase.

As for your question, Create a form around your select elements, and set its action to the page you want to use to update the form (generally, this should be a separate page):

<?php
    if(! empty($_GET['message']))
        echo "<div style=\"text-align:center;\">$_GET[message]</div>";
?>
<form action="dbi/updatePrefsOrWhatever.php" method="get">
    <select name="choice1">
        <?php
            $sql = "SELECT * FROM X ...";
            .
            .
            .
        ?>
    </select>
 
    <select name="choice2">
        <option value="0">Choose:</option>
        .
        .
        .
    </select>
</form>
 

Then in updatePrefsOrWhatever.php:

If(empty($_GET['choice1']) && empty($_GET['choice2'])) {
    header('Location: theOtherPage.php?message=Please%20make%20a%20choice');
    exit();
}
 
$name = '';  // Not sure what goes here.
$choice1 = intval($_GET['choice1']);
$choice2 = intval($_GET['choice2']);
 
//  connect to mysql db here.
 
$sql = "INSERT INTO `X` (`name`, `choice1`, `choice2`) VALUES('$name', $choice1, $choice2)";
if(mysql_query($sql))
    $message = 'Success';
else
    $message = urlencode(mysql_error());
 
header("Location: theOtherPage.php?message=$message");
exit();
 

[gab]

Thanks alot for taking time to help me :-)

I have been trying to mess a little around with your supplied code, but I'm still nok getting there :-p (yes I am very green at this...)

I think I maybe forgot to mention something before...
I have a table which is supposed to fill the dropdowns (choice_tabel).

Then there is a table (table) which is supposed to be like:
username,choice,choice2
username2,choice,choice2


its should:
-fill the dropdown boxes with different data from DB (can only fill the first dropdown with below code)
-be able to update the DB with the selected choices (or make a new db entry if one's username doesn't have one already)
-when it shows the dropdown boxes, if ones username is already in the table then ones previus choice should be selected in the dropdownbox.

thx again :-)

[PHP]<?php
//index.php

//connecting to DB

$username = 'thisismyname'; //going to be dynamic later

$sql="SELECT choice FROM choice_tabel WHERE something...";

$result=mysql_query($sql);


$options="";
$options2="";

while ($row=mysql_fetch_array($result)) {

$choice=$row["choice"];
$options.="<option VALUE=\"$choice\">".$choice.'</option>';
}

$sql2="SELECT choice FROM choice_tabel WHERE something else...";
$result2=mysql_query($sql2);
while ($row2=mysql_fetch_array($result2)) {

$choice2=$row2["choice"];
$options2.="<option VALUE=\"$choice2\">".$choice2.'</option>';
}
?>


<form action="update.php" method="get">
<SELECT NAME=dropdown1>
<OPTION VALUE=0>choose 1
<?php echo $options ?>
</SELECT>

<SELECT NAME=dropdown2>
<OPTION VALUE=0>choose 2
<?php echo $options2 ?>
</SELECT>
...
<input type="Submit" name="submit" value="submit">
</form>




//update.php

<?php

If(empty($_GET['choice']) && empty($_GET['choice2'])) {
header('Location: index.php?message=Please%20make%20a%20choice');
exit();
}

//$username = ''; // Not sure what goes here.
$choice = intval($_GET['choice']);
$choice2 = intval($_GET['choice2']);

// connecting to DB here.

$sql = "INSERT INTO `tabel` (`username`, `choice`, `choice2`) VALUES('$username', $choice, $choice2)";
if(mysql_query($sql))
$message = 'Success';
else
$message = urlencode(mysql_error());

header("Location: index.php?message=$message");
exit();

?>[/PHP]

[pbmods]

Heya, gab.

<SELECT NAME=dropdown1>
 

$choice = intval($_GET['choice']);
 

You're gonna want these to match:

<select name="choice">
 

$choice = intval($_GET['choice']);