Results 1 to 2 of 2
May 14, 2011, 03:14 #1
- Join Date
- May 2006
- 0 Post(s)
- 0 Thread(s)
calculating difference with mysql
I want to run a query to fetch 10 rows from database with the 'category_id' parameter set, and fall back if there are not 10 rows from the mentioned category to fetch the missing rows from the same table without category_id.
How can you calculate a difference with php?
Right now I call this query:
(SELECT asin FROM products $where ORDER BY $order_by LIMIT 10) UNION (SELECT asin FROM products WHERE site_id = $site_id ORDER BY $order_by LIMIT 10)
Which would be more elegant way to do this with mysql?
Thanks for help
May 14, 2011, 11:34 #2
I don't know if it would be possible to have MySQL establish how many rows are extracted from the category, and how many rows must be added from the entire table, but even if it is, I'm sure it would be much more complicated than coding that piece of logic in PHP (like you said, all you need there is array_splice).Guido - Community Team Leader
The 2013 SitePoint Awards - Nominate your heroes now!
Thinking Web: Voices of the Community
Blog - Free Flash Slideshow Widget