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] Link to comment https://forums.phpfreaks.com/topic/30010-order-problems/ 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. Link to comment https://forums.phpfreaks.com/topic/30010-order-problems/#findComment-137940 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] Link to comment https://forums.phpfreaks.com/topic/30010-order-problems/#findComment-137941 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 Link to comment https://forums.phpfreaks.com/topic/30010-order-problems/#findComment-137943 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.