SQL Helper howto use with this Querys?

[fragger]

Hello,

 

i have 2 Queries and i don't know how to integrate this in the SQL Helper function.

 

Query #1:

SELECT * FROM `mod_customer_rating` WHERE `rating` = '5' AND id >= (SELECT FLOOR( MAX(id) * RAND()) FROM `mod_customer_rating` WHERE `status` = 'Active' ) LIMIT 1

Cause of Select int the WHERE-Clause

 

Query #2

SELECT DISTINCT `tblproductgroups`.`id`, `tblproductgroups`.`name` FROM `tblhosting` INNER JOIN `tblproducts` ON `tblhosting`.`packageid` = `tblproducts`.`id` INNER JOIN `tblproductgroups` ON `tblproductgroups`.`id` = `tblproducts`.`gid` WHERE `tblhosting`.`domainstatus` = 'Active' AND `tblhosting`.`userid` = '$_SESSION[uid]'

Cause of DISTINCT in the Select Field

 

Thanks!

[WHMCS Chris]

Hello,

What SQL helper function?

[fragger]

http://docs.whmcs.com/SQL_Helper_Functions

-> select_query