Topic awaiting preservation: ORDER BY in PHP/MySQL (Page 1 of 1)

I have a select statement like this:
select * from articles order by print_counter $sortdir LIMIT $start , $display

Based on a content management system I wrote, I could have a query such as:
select * from articles order by print_counter desc LIMIT 0 , 29

But I'm getting a SQL query error. If I go into phpmyadmin, and run a query of say:
select * from articles order by print_counter, then phpadmin returns a page with this query:

select * from articles order by print_counter desc LIMIT 0, 30 with all the info I need.

If I COPY AND PASTE this same query into another query in phpmyadmin, I again get a query error.

I can't seem to see what's going on. It's the copy/paste error that really baffles me. I've made sure everything is spelled right, field names are right, etc.



[This message has been edited by Pugzly (edited 05-31-2002).]

Pugzly: That sounds very odd and i was happening to me my first thought would be that it was PHPmMyAdmin - can you instal the latest version or perhaps use an alternative MySQl interface?

___________________
Emps

FAQs: Emperor

Actually, the first part has been resolved. But the copy/paste thing is still bugging me....

Last time I checked, MySQL queries are case sensitive; try either one of these:

SELECT * FROM articles ORDER BY print_counter DESC LIMIT 0, 30

select * from articles order by print_counter desc limit 0, 30

"No one's going to give you a map; you've got to walk your own path." - Hot Ice Hilda, Outlaw Star.

Pugzly, regarding copy/paste problem - are you using the latest version of phpMyAdmin?

I want to say too that sometimes with copy paste you get garbage space and hard return characters in form fields that can mess up queries they end up like

select * from whatever where x = '33 '

where you can't see the space after the 33.



.:[ The Tao of Steve ]:.
Be Desireless
Be Excellent
Be Gone
...................................