order by problems

[ccrevcypsys]

I am trying to display the songs in an album but when i use the order by track it goes 1 then 10 then 11 then 2 then 3 then 4 so on an so fourth. i need it to go like any album does. 1 2 3 4 5 6 7 8 9 10 11. heres my code

	
$query = "SELECT i.*,c.screenname,c.customer_id 
		  FROM ".$glob['dbprefix']."StreamRush_inventory i
		  LEFT JOIN ".$glob['dbprefix']."StreamRush_customer c
		  ON c.customer_id=i.customer_id
		  WHERE i.album_id=".$_GET['album_id']."
		  ORDER BY productCode ASC";

how do i stop that from happening?

[pocobueno1388]

Well, you are ordering by "productCode"...does that have something to do with the tracks? It's hard to help you without knowing the setup of your database.

[ccrevcypsys]

yes yes it does.. sorry i forgot to post that. it is the tracks name

so

 

what im trying to say is

productCode==tracks

[pocobueno1388]

Well, if that is the tracks name, then what do you expect it to do? Obviously it is going to order by the name, and not the track.

 

Could you post your database table setup?

[ccrevcypsys]

----Inventory----

productId    (the key id auto incriments)

productCode (what number the track is)

images

file_location

album_id

[pocobueno1388]

And where exactly are the tracks?

[ccrevcypsys]

Dude they are the productCode row... ive told you that like nine times