Yes I know ,
Just in my small project I need to group result like newegg do , with filter_items and count(filter_it ems).
My question was a simple table. In real database my query use match against and group by and for each type of filter_items is necessary to re-query the database.
My example was really stupid :P
To have an idea just search on newegg.com for "tv" and you will see on the...
Free User
Last Activity: Jun 21 '11, 11:44 PM
Joined: Dec 27 '10
Location:
-
Thank You for your reply Rabbit,
I'm afraid that I will lose performance because I need to search multi rows with MATCH AGAINST.
The goal is to extract result from database like newegg.com :P and I need to multi query MATCH AGAINST and GROUP BY .
Exist any other way with just mysql and php?
Thank You again!Leave a comment:
-
mysql multi group by
Hello ,
I need a small help with multi GROUP BY .
Mysql example table with name 'mytable' has :
id - modelid - nameid
_______________ ___________
1 | 1 | 2
2 | 5 | 6
3 | 3 | 11
4 | 2 | 10
5 | 6 | 1
6 | 7 | 1
7 | 5 | 1
8 | 8 | 1
I need to...
No activity results to display
Leave a comment: