CODEWITHSUNDEEP
phpmysql
waraza
waraza

Reputation: 33

Different outputs from mysql

I have two sql query outputs from a table , with orders..

One sql order directly from the table and the data is showing right, from last to first. But when i try the same way to show up the data but, this time I use a post method, so when click submit that data is being shown, but this time the showup begin from the first to the last query . Why is that.The mysql is simple just .

select * from smt order by smtorde

Upvotes: 0

Views: 55

Answers (1)

Phill Pafford
Phill Pafford

Reputation: 85388

You could also append the way you want the MySQL Sort ordered with ASC or DESC

// Ascending 
select * from smt order by smtorde ASC

// Descending 
select * from smt order by smtorde DESC

Upvotes: 2

Related Questions