ethangk Posted July 22, 2007 Share Posted July 22, 2007 Hey, Im stuck on a query, im not sure if its possible in mysql. "SELECT * FROM `table` ORDER BY col1-col2". Is it possible to do that with mysql. I tryed working around it with php, like throwing the results into a array then sorting that but ran into a few problems. Thanks ethangk Quote Link to comment Share on other sites More sharing options...
AndyB Posted July 22, 2007 Share Posted July 22, 2007 That (style of) query isn't going to work. What exactly are you trying to do? Quote Link to comment Share on other sites More sharing options...
ethangk Posted July 22, 2007 Author Share Posted July 22, 2007 Thanks for the quick reply. Im trying to make a basic rating system. In essence its sortof a digg type thing, digg and bury. Its a rating system for a practise project i am playing around with, you like something, you click that you like it, if you dont, you click that you dont. The query is suppost to be ordering by howmanylikes-howmanydislikes. Quote Link to comment Share on other sites More sharing options...
ethangk Posted July 22, 2007 Author Share Posted July 22, 2007 I worked out how to do it 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.