Jump to content

Storing option value as variable from dropdown without submit


jamiejones82

Recommended Posts

Hopefully someone can help, firstly i am a newbie at php coding but keen to learn more.

 

Here is my problem 

Untitled-1.jpg

 

The database is built correctly with all the information i need, the first part is the dropdown menu which you select a car, next you choose a month and mileage - from there it shall show you the correct price for each one. There is columns for each price, mileage and months i just need to figure out how best to start this thing.

 

I first started by this

 

$query = "SELECT DISTINCT Full_Description FROM import"; 
$result = mysql_query($query) or die(mysql_error());
 
echo "<select name=\"carname\">";
echo '<option value="">Please select...</option>';
while($row = mysql_fetch_array($result))
echo "<option value='{$row['id']}'>{$row['Full_Description']}</option>";
 
echo "</select>";
 
$carids = $_POST["carname"];
$_SESSION["carid"] = $package_id;
echo $_SESSION["carid"];
 
$query2 = "SELECT Mileage FROM import WHERE id = '$carnames22'";
$resultsdsd = mysql_query($query2) or die(mysql_error());
 
?>
 
This got me all the cars listed in a dropdown select, but it did not store the selected car id for me to use else where, i am not even sure if this is the best approach.
 
Please can some help me!
 
Jay

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.