I want to give the user the option to order their database search:

im trying the following not working:

<select name ="order">
<option value="price"> price</option>
<option value="size"> size</option>
<option value="date">date </option>

var=request.form("order")

SQL = "SELECT * FROM table ORDER BY 'var'"

im a newbie is there a syntax problem???
thanks
mick