Selection drop-down box 1

[andy98]

I have a selection box with a list of SALES people in, that is pulled from a Database table and i later store the SALES_ID in the ORDER table:

$query = "SELECT * FROM sales ORDER BY sales_person ASC";
$result = mysql_query($query) or die (mysql_error()); 

echo "<select name='sales_id' id='$sales_id'>";
   
     while ($row = mysql_fetch_row($result)){
                 $sales_id = $row[0];
                 $sales_person = $row[1];
				 $sales_office = $row[2];
                 print("<option value=\"$sales_id\">$sales_person, $sales_office</option>\n");
          }

This is fine, however - I use the selection box in an ORDER table where I store the SALES_ID to associate a SALES_PERSON with an Order.

What I can't figure out is how I would EDIT the Order and have the SALES_PERSON selected as default from the selection box!

http://www.goplanetgo.co.uk

 

[Chacalinc]

<select name='sales_id' id='$sales_id'>
<option value="1">sales_person, sales_office</option>
<option value="2" selected>sales_person, sales_office</option>
<option value="3">sales_person, sales_office</option>

Add an "if" statment.. if the sales_id is the same as the row add the "selected" in the option tag.

hope this helps.

 

[andy98]

I have got this far - but cannot get this PRINT line to parse:

echo "<select name='sales_id' id='$sales_id'>";
   
     while ($row = mysql_fetch_row($result)){
                 $sales_id     = $row[0];
                 $sales_person = $row[1];
				 $sales_office = $row[2];
[b]print("<option value=\"$sales_id\" if( $row['sales_id']== $_GET['sales_id'] ){'selected'}> $sales_person, $sales_office</option>");[/b]

Am I on the right lines?

http://www.goplanetgo.co.uk

 

[Chacalinc]

hold on...

print("<option value=\"$sales_id\" if( $row['sales_id']== $_GET['sales_id'] ){'selected'}> $sales_person, $sales_office</option>");

is not correct.. it should be:

print("<option value=\"$sales_id\" ");

if( $row['sales_id']== $_GET['sales_id'] )
   print("selected");

print("> $sales_person, $sales_office</option>");

 

[andy98]

That parses successfully now thanks!

But the selection box doesn't SELECT the correct sales person.

It just displays the default list.

Any ideas as to why?

I know that the correct variable SALES_ID is brought into the page.

http://www.goplanetgo.co.uk

 

[Chacalinc]

take a look to the reult page (see resulted page code on the browser) to see the select statment.

post the resulted select statment (at least a portion with the select, options (include the selected) and the end of select.

get documented yourself about select and option:

http://www.w3.org/TR/html4/interact/forms.html#h-17.6

 

[andy98]

The html code returns:

<select name='sales_id' id='2'>
<option value="4" > Deb, UK</option>
<option value="8" > Dave, UK</option>
<option value="2" > Phil, UK</option>
</select>

Option value 2 should be displayed as SELECTED but it doesn't!

http://www.goplanetgo.co.uk

 

[Chacalinc]

ok, replace the if:

if( $row['sales_id']== $_GET['sales_id'] )
print("selected");

if( $sales_id == $_GET['sales_id'] )
print("selected");

I didn't notice that you have $sales_id = $row[0];

 

[andy98]

Many thanks! That's resolved it!

Have a star!!!!!

Regards

http://www.goplanetgo.co.uk