how do i order the data in ascending order?..
Let's say you want to order by ID<BR>Add " ORDER BY ID ASC" for ascending and " ORDER BY ID DESC" for descending order. Add this at the end of your sql select statement. That's all
...but ORDER BY xxx ASC is the *default*. So if you code neither ASC nor DESC, you will get ASC automatically.<BR><BR>So the simplest answer to the original question is: don't add anything.<BR><BR>
yeah DUHHHH, i knew that.. dont know where my brain goes sometimes...