PHP - Select Default

I created a drop-down menu using a MySQL statement in php for a form.
My drop down menu works fine, but I want to assign a default value to it (normal text) the value will never change,
thus I do not need to extract the default value from the table, I already know the value.

Here is the basic snippet from the script:

<?php
   include("../includes/xxx.php");
   $cxn = mysqli_connect($host,$user,$password,$dbname);
   $query = "SELECT DISTINCT `plant_id` FROM `plant` ORDER BY `plant_id`";
   $result = mysqli_query($cxn,$query);
      while($row = mysqli_fetch_assoc($result))
      {
      extract($row);
      echo "<option value='$plant_id'>$plant_id</option>\n";
      }
?>

Hey guys.
Me again...

Essentially what i am doing is pulling data from a MySQL database about the number of thumbnails on a page.
The user can then change this using a <select> dropdown menu.

How ever, i want the <select> to default to the amount already specified by the Database.
I know i can do this by inserting a Selected attribute to one of the <options> but what is the best way of doing this?

Heres my code..
$NumberOfThumbnails = mysql_result($data, 0,"NumberOfThumbnails");
 <select name="numberofthumbnails"> 
    

<option value="0">None</option>
        <option value="2">2</option>
        <option value="4">4</option>
        <option value="6">6</option>
        <option value="8">8</option>
        <option value="10">10</option>
        <option value="12">12</option>
        <option value="14">14</option>
        <option value="16">16</option>
        <option value="18">18</option>
        <option value="20">20</option>
        <option value="22">22</option>
        <option value="24">24</option>
        <option value="25">25</option>
        <option value="26">26</option>
        <option value="27">27</option>
        <option value="28">28</option>
    </select>


Thanks - Danny

Hi,
I need to call to this text to add a all with value "blank/empty" or "0" to the dropdownlist code below..
it should be inserted int the first position in the dropdownlist and have a value blank and call to this text from the language files:            
            $searchAll = gettext('_LANGUAGE_SEARCH_ALL',_LANGUAGE_SEARCH_ALL,false,false);
            example is:
            ratestitle=>0 gettext('_LANGUAGE_SEARCH_ALL',_LANGUAGE_SEARCH_ALL,false,false);
            the words it calls is "ALL" when the user selects or leaves the "ALL" in the list the value
             remains empty this allows the search to search everything..
basically im stuck how to get it in the dropdown list as the first default position:
can anyone help?

here is my code://this is a search function which calls to the field rate_title the text from the select box is matched to the database table and the search pages shows the search option is the search is successful.. I have 5 of these types of searches but cant give a broader search option to my users as the values must be selected to search--- i need the option "ALL" to have a "EMPTY" value or no value....
         

if (in_array("ratestitle",$searchOptions)&& $showSearchOptions )
            {
            if (empty($sch->filter['ratestitle']) )
               $selectOption=$output['LANGUAGE_SEARCH_RATESTITLE'];
            else
               $selectOption=$sch->filter['ratestitle'];
            $showButton=true;            
         $query = "SELECT DISTINCT rate_title FROM #__rates_table ORDER BY rate_title ASC";
         $dropDownList ="<select class=\"inputbox\" name=\"ratestitle\">";
         $ratesitles =doSelectSql($query);         
         foreach ($ratesitles as $ratetitle)
            {
            $selected="";
            $rate_title=$ratetitle->rate_title;
            if ($ratetitle==".$sch->filter['ratestitle'].")
               $selected="selected";
            $dropDownList .= "<option ".$selected." value=\"".$rate_title."\">".$rate_title."</option>";
            }
         $dropDownList.="</select>";
         $output['RATESTITLE']=$dropDownList;
            }
               

hirealimo.com.au/code1.php

this works as i want it:
Quote

SELECT * FROM price INNER JOIN vehicle USING (vehicleID) WHERE vehicle.passengers >= 1 AND price.townID = 1 AND price.eventID = 1



but apparelty selecting * is not a good thing????

but if I do this:
Quote

SELECT priceID, price FROM price INNER JOIN vehicle....etc


it works but i lose the info from the vehicle table.

but how do i make this work:
Quote

SELECT priceID, price, type, description, passengers FROM price INNER JOIN vehicle....etc


so that i am specifiying which colums from which tables to query??

thanks

Hi guys and gals ,

got a minor problem.  I have a table in which i want the "photo" column to have a default value of "noimage.jpg".

I set the default value to "noimage.jpg" and put "as defined" too.

but when i fill the form in and leave the upload field blank it doesnt show the noimage.jpg as it should and in the mysql table it leaves it blank and not with default value.

Here is the inserts.php which adds the data to the mysql table.   

Can you help please.

<CENTER><B>Vehicle Added</B></CENTER>
<BR>

<?php

mysql_connect("localhost", "wormste1_barry", "barry") or die(mysql_error());
mysql_select_db("wormste1_barry") or die(mysql_error());

$CarName = mysql_real_escape_string(trim($_POST['CarName']));
$CarTitle = mysql_real_escape_string(trim($_POST['CarTitle']));
$CarPrice = mysql_real_escape_string(trim($_POST['CarPrice']));
$CarMiles = mysql_real_escape_string(trim($_POST['CarMiles']));
$CarDescription = mysql_real_escape_string(trim($_POST['CarDescription']));
$pic = mysql_real_escape_string(trim($_FILES['uploadedfile']['name'])); 


$target_path = "images/";

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); 

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
    echo "The file ".  basename( $_FILES['uploadedfile']['name']). 
    " has been uploaded";
    echo "<br />";
} else{
    echo "There was an error uploading the file, please try again!";
}



mysql_query("INSERT INTO cars 
(CarName, CarTitle, CarPrice, CarMiles, CarDescription, photo) VALUES('$CarName', '$CarTitle', '$CarPrice', '$CarMiles', '$CarDescription', '$pic' ) ") 
or die(mysql_error());  


echo "The vehicle data has been added!";

?>