we have these 2 queries and we want to merge them and run as? a single query by grouping them
$ts=mysql_query("select * from transaction where TUsername='XXXXX' and approved=1 and package=4 order by ID");
while($ats=mysql_fetch_array($ts)) {
$rs1=mysql_query("select * from members where Username='$ats[1]' and pack4=1 and pack4q=2");
}
if you have complete idea how to do it then only make the bid.