insert data into db by form

[benracer]

hi,
i am trying to create a orders page and i need a form on a list of orders to show the current status of the order eg new , dispatched ect,

when a order is created the defult value is NEW sohow can i show this and alter it in the page?

i have this so far

<form id="form1" name="form1" method="post" action="">
                              <select name="select">
                                <option><? echo $rows['status']; ?></option>
							    <option><? echo $dispatched; ?></option>
								<option><? echo $awaiting; ?></option>
                              </select>
                            </form>

thanks in advance

[chasiv]

So this is for a user to change the status of the order?

It appears your Options have no values... so you want something like:

In a loop for each row:

<select name="select">
    <?php
    unset($sel);
    If($row['status'] == 'dispatched') { $sel = " selected = ' selected ' "; }
    echo "<option value='dispatched' $sel>dispatched</option>";
    unset($sel)
    If($row['status'] == 'awaiting') { $sel = " selected = ' selected ' "; }
    echo "<option value='awaiting' $sel>awaiting</option>";
    ?>
</select>

That will show the dropdown appropriately if I understand you properly...