No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hi All, I have a requirement first to fetch top unique company_names out of duplicate values based on the product name search and then fetch rest of the record randomly.Below is my sample table structure but the actual table has more than 90k records. id com_id company_name product_name package_id 1 … |
|
|
I am using MYSQL and php version 5.4.16.My table structure is as given below. I want to sort the temp_id cat_id and colors based on the cat_id as given in the second table. The com_id same values should not come at once. My Table is something like this: col1 col2 …
|
|
|
I am using MYSQL MYISAM and php version 5.4.16,MYISAM and am doing a fulltext search based on the (product_name) column and i want to randomize the result but the problem is rand()not giving the random values. I tried something like this: SELECT `product_name`,`main_cat_id`,`sub_cat_id`,`prod_cat_id`,`prod_short_desc`,`com_id`,`product_id`,`product_ratings`, `min_order_quantity`, `fob`,`country_id`,`company_name`,`attributes`,`attr_values`,`verify`,`image`,`product_additionals` , MATCH (`product_name`)AGAINST ('"girls top"'IN … 
|