Quote:
$query = "SELECT * FROM shop_tshirts WHERE shop_id = '429942'";
$zquery = "SELECT * FROM shop_tshirts WHERE shop_id = '266497' AND design_id = '$designid'";
|
for first two
Code:
select * from shop_tshirts t left join shop_tshirts t1
on t.design_id = t1.design_id
where t.shop_id = 429942
If queries as it si now slow, you don't have indexes on key fields.