[nuzzle]

Just wondering if there is anyway possible to put choices in a drop-down menu in alphabetic order?
I tried putting them in alpha order myself through mysql, but when its listed on the site, its not... :/

any help would be appreciated!

Thanks,
Keith

[bizzar528]

Maybe by javascript, but I'm doubting it.

It's very easy to do when you use the Mysql functions. ORDER BY something DESC or ASC usually does the trick. What was the query statement you were trying? Maybe we can help ya with that.

[nuzzle]

here is the code from the site im trying to search from...

[php]
<!--S:Search-->
<script language="JAVAScript" >
function Model(newmodel) {

var models = new Array();

{SCRIPT}


for (var i = document.forms[0].model.options.length ; i >= 0 ; i--)
document.forms[0].model.options[i] = null;

if (newmodel == "" )
return "";
//adding the new values;

for (var i = 1 ; i < models[newmodel].length ; i++)
document.forms[0].model.options[i-1] = models[newmodel][i];


}
</script>

<form action="search.php" method="get">
<table align="center">
<tr>
<td>Make & Model</td>
<td>{MAKE} & {MODEL}</td>
<tr>
<td>Price range:</td>
<td>From: $<input type="text" name="pf" value="{PF}" size="5">
To: $<input type="text" name="pt" value="{PT}" size="5">
</td>
</tr>
<tr>
<td>Year range:</td>
<td>From: <input type="text" name="yf" value="{YF}" size="5">
To: <input type="text" name="yt" value="{YT}" size="5">
</td>
</tr>
<tr>
<td align=center colspan=2><input type="submit"></td>
</tr>
</table>
</form>
<!--E:Search-->

<!--S:Select-->
<select name="{NAME}" onchange="{ONCHANGE}">
<option value="">[ select ]</option>
{OPTIONS}
</select>
<!--E:Select-->

<!--S:SelectOption-->
<option {SELECTED} value="{VALUE}">{NAME}</option>
<!--E:SelectOption-->
[php]

Hope that helps?? Also, with this site, it has catagories... ie different "makes" How can I link to just one type of "make" instead of listing all of them?

Thanks