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 Link to comment https://forums.phpfreaks.com/topic/61168-solved-difficult-mysql-query-help/ 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? Link to comment https://forums.phpfreaks.com/topic/61168-solved-difficult-mysql-query-help/#findComment-304405 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. Link to comment https://forums.phpfreaks.com/topic/61168-solved-difficult-mysql-query-help/#findComment-304407 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 Link to comment https://forums.phpfreaks.com/topic/61168-solved-difficult-mysql-query-help/#findComment-304548 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.