SkyRanger Posted December 9, 2006 Share Posted December 9, 2006 I am having an order problem and not sure how to fix it.This is what is coming up:110234etc to 9What I need it1234etc to 10How can I fix this?[code]$result = mysql_query( "SELECT * FROM links where sec=1 order by 'lorder' ASC") or die( "Unable to select database");[/code] Quote Link to comment Share on other sites More sharing options...
Psycho Posted December 9, 2006 Share Posted December 9, 2006 Make sure lorder in the database is a numeric field. Quote Link to comment Share on other sites More sharing options...
bljepp69 Posted December 9, 2006 Share Posted December 9, 2006 Remove the quotes around lorder in your query statement[code]$result = mysql_query( "SELECT * FROM links where sec=1 order by lorder ASC") or die( "Unable to select database");[/code] Quote Link to comment Share on other sites More sharing options...
SkyRanger Posted December 9, 2006 Author Share Posted December 9, 2006 Thanks guys, both things fixed my problem Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.