Parsing 2 values from drop menu

[bjblackmore]

Hi,
I need to parse 2 values from a drop down menu. This menu gets 2 values from a database. 'item' and 'price'. It then displays the value in the menu as 'Item - Price'
i.e.
'Orange - £1'
'Apple - £2'
etc
I need to parse this to the next page, so it displays..
You have chosen 'Apple' at the cost of '£2'. Do you want to continue?
Is this possible?
Regards
Ben

[herve]

It's always possible :-)

Depending on how your data are structured
in your database.

Admit the following :

id | name | price

1 | Apple | £2
2 | Orange | £1

your SELECT tag :

<SELECT NAME="ArticleID">
<OPTION VALUE="1"> Apple £2
<OPTION VALUE="2"> Orange £1
</SELECT>

so the data you will get back for this form
is the Article ID ; you do a SELECT SQL query :

SELECT name,price FROM mytable
WHERE id='$Article_ID';

You have now your name & price again
available to print in the next screen

[bjblackmore]

Thats great, it worked. Thanks