rbrown Posted December 24, 2010 Share Posted December 24, 2010 Anyone run into this problem? I have this line... "SELECT * FROM customer ORDER BY street ASC" and it shows all the records but one which should be the the first record. But if I change it to this: "SELECT * FROM customer ORDER BY street DESC" the one missing record shows up as the last record... The script shows all the records on one page. So there isn't any logic between the query and the output or if I change the ORDER BY to: state, city, or zip it shows that one record either way.... So I'm pulling my hair out here.... Thanks... Link to comment https://forums.phpfreaks.com/topic/222559-weird-problem-asc-not-working-desc-does/ Share on other sites More sharing options...
PFMaBiSmAd Posted December 24, 2010 Share Posted December 24, 2010 I can just about guarantee that your code is fetching and discarding a row from the result set. You would need to post your code from the point where you are executing the query through to end of the loop where you are displaying the results. Link to comment https://forums.phpfreaks.com/topic/222559-weird-problem-asc-not-working-desc-does/#findComment-1151009 Share on other sites More sharing options...
rbrown Posted December 24, 2010 Author Share Posted December 24, 2010 Yep... DUH... that is what it is doing.... After you mentioned it, I deleted the one row then noticed another record went missing... I have been working on this script (other parts) since 6am and it now midnight... So maybe I should take a nap... So I can think straight... Thanks... Link to comment https://forums.phpfreaks.com/topic/222559-weird-problem-asc-not-working-desc-does/#findComment-1151020 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.