[RESOLVED] default value for drop down menu

truck7758

i use the following code to create a drop down menu with the default value set as 0

<?

	$mysqli = new mysqli('localhost','root','newr00t');
	$mysqli->select_db('orders');

	$result = $mysqli->query("SELECT * FROM quotes");

	echo "<SELECT name='quoteid'>\n";
    echo "<option value=''>0</option>\n";
	while($row = $result->fetch_assoc()) {
		echo "<option value='{$row['quoteid']}'>{$row['quoteid']}</option>\n";	
	}
	echo "</select>\n";

	$result->close();

	?>

My problem now is that when i submit this data if i leave that dropdown as the default (0) the first time it submitted a 3, the second time a 2 and now it just submits 1.
This is very confusing as i cannot see where it is getting this data from.

Thanks,
Mike

dougal85

Can you show us a sample output? I don't fully follow

truck7758

basically iv created a database used for ordermanagement and this is a form for creating a new order. this particular drop down list shows quote ids which come from another table and so if the new order was origanally a quote i want to be able to select the quote id and if not i want it to just submit a zero to show the order was not originally a quote.

Hope this makes a little more sense,
Thanks,
Mike

dougal85

try changing;

$result = $mysqli->query("SELECT * FROM quotes ORDER BY fieldname ASC");

Where fieldname is the field containing the order. This may be the ID or whatever. Change ASC to DESC if you want it the other way.

truck7758

im not sure how this will help

i have two tables:
1: orders - this table contains all the orders made
2: quotes - this contains all the quotes made

when i create a new order i want to be able to select the quoteid(a unique number given to each quote) from a drop down menu if this order corresponds to an existing quote and if it doesn't then for it to just input a zero.
The code i provided above creates the drop down menu with the default value as a zero and all the rest of the menu is populated from an sql database.
i basically want it to imput whatever value is selected in the drop down menu.

Hope this makes things a little clearer

Thanks for your help,
Mike