Im using the onchange event for a dropdown list to change SQL statements based on the index of that dropdown chosen. For example I have a function like this for my onchange event of the drop down list.

<script type="text/javascript">

function listboxchange(index)

declare connection ...
SQL = "Select * FROM `mytable` WHERE `Field1` = ' "%>index<%" ' "

make connection with SQL statement...

Im trying to pass the javascript variable "index" into the SQL statement but its not working. Am I using the wrong syntax?