Thanks. but I think it is tblorders not tblclients
Full query here - worked fine for me
$query = "SELECT tblorders.*,tblclients.firstname,tblclients.lastname,
tblpaymentgateways.value,
tblhosting.id as hostingid, tbldomains.id as domainids, tbldomains.type as domaintype,
tblproducts.name as productname
FROM tblorders INNER JOIN tblclients ON tblclients.id=tblorders.userid
INNER JOIN tblpaymentgateways ON tblpaymentgateways.gateway=tblorders.paymentmethod
left JOIN tblhosting ON tblhosting.orderid=tblorders.id
left JOIN tbldomains ON tbldomains.orderid=tblorders.id
left JOIN tblproducts ON tblproducts.id=tblhosting.packageid
WHERE
tblpaymentgateways.setting='name' AND
date like '$year-$pmonth%' AND tblorders.status='Active' ORDER BY date ASC";
$result = mysql_query($query);