default value for drop down menu

[truck7758]

i have created a dropdown menu using the following code

 

<?

	$mysqli = new mysqli('host','username','password');
	$mysqli->select_db('orders');

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

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

	$result->close();

	?>

 

this works fine but what i need now is for the default value to be either blank or say something like please select and if nothing else is selected than for it to insert a blank value

 

Thanks,

Mike

[ansarka]

:)

 

<?

	$mysqli = new mysqli('host','username','password');
	$mysqli->select_db('orders');

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

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

	$result->close();

	?>

[truck7758]

This no displays 'Select' as the default value although i have changed this to '0' which is great but now when i submit my form it submits the value '3'  ???

 

Any ideas?

Thanks,

Mike

[truck7758]

i have just done another test and this timme it submitted '2'  ???

 

Thanks,

Mike

[truck7758]

i have now done a few more tests and it is now just submitting the value '1' and i cannot see where it is getting this value from.

Any ideas,

Mike

[truck7758]

Any ideas???

 

Thanks,

Mike

[truck7758]

resolved using previous suggestion by ansarka. the reason it didnt work straight away was i had an error on my insert script 

 

Thanks All