[nuzzle]

Im trying to alphabetize the dropdown menu at my site. The database is setup to show a-y but for somereason its only showing that way when im veiwing the database in phpmyadmin. When I go to the output file :
http://www.prayershares.com/briens/search.php
it dont show in order. I dont know what kinda funky *** order its in!?
Anyone know how to organize these options? Another script maybe? or possibly javascript???

Thanks,
Keith

[nuzzle]

Code:

<!--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-->

[ArksI]

well if you take the info from a DB then ORDER BY will do!

[nuzzle]

I tried that, but like I said it only is ordered in the database while im veiwing it... When I close out the database, and then go to the site... its not ordered!

[ArksI]

post here the query from the site, ok?

[nuzzle]

i did that already but here it is again...

Code:

SELECT * 
FROM `site_make` 
LIMIT 0 , 30

then I change it to:

Code:

SELECT *  FROM `site_make`  ORDER BY `make_name` ASC

But when I click go, it changes... but dont seem to save, cause when i go into another table and come back, its back to the way it was...
Does it matter that a .sql file was ran for this database? im hoping not, cause i dont know where to make the change, i've been looking but see nothing!

[nuzzle]

[B]I FIGURED IT OUT!! LoL finally... grr that was aggrivating! I had to edit that in "operations" not where I was... So its working now, thanks a bunch!!....... Guess now im on to the next problem of trying to edit this free script I d/l'ed and try to make another "catagory" ie New and Used.... or finding a way to link to them... owell.... thanks though

[ArksI]

u r welcome