I am using php and sql to search through a database and list certain details from a table. When the details are found i am trying to...on click, show all the remaining details from the table, as the variable in the list box is the primary key.

PHP Code:

$query=mysql_query("SELECT `Request ID` FROM Requests");
while ($row=mysql_fetch_array($query)) {
        $reqID = $row['Request ID'];
        $reqIDoptions .= "<OPTION VALUE=\"$reqID\">" . $reqID; 


this shows part of the code i am using to show the primary key from the table into the list box.

<SELECT NAME="reqID">
  <OPTION VALUE=0>
    <?=$reqIDoptions?>
    </option>

this is showing the declaration in html of the list box itself. I am only asking how to select the value from the table, and store it in a variable, from there i should be able to work the rest out.

So what exactly are you trying to do? If you're trying to dynamicaly load a dropdown box then you're nowhere near it, can you make it more clear what you're trying to do, because your code is highly screwed up and is FUBAR really.

<OPTION VALUE=0>
You must store it in the value property , and not in the level

I don't know if the code is incomplete on purpose, but try this:

PHP Code:

while ($row=mysql_fetch_array($query)) {
        $reqID = $row['Request ID'];
        $reqIDoptions .= "<OPTION VALUE=\"$reqID\">" . $reqID ."</option>";
} 


and

<SELECT NAME="reqID">
    <?=$reqIDoptions?>
</select>

Understand that you have a select element, and each line in the drop down is 1 option.
It's not 1 option that contains every possible values.