Two queries into one

[blackhat]

Is there a way these two queries could be put into one by using UNION or something else? I’m not too familiar with having two queries in one. Thanks

	$query = "SELECT experience.experience, members.level FROM experience INNER JOIN members ON members.id = experience.userID WHERE members.id = ".$uid;
	$xpdata = getContent($query);
	$currentXP = $xpdata[0][experience];
	$currentLvl = $xpdata[0][level];

	$query = "SELECT xpneed FROM levels WHERE level = ".$currentLvl."+1";
	$data = getContent($query);

[DaveMaxwell]

This should work…

$query = "SELECT experience.experience
	       , members.level 
	       , levels.xpneed
	    FROM experience 
	   INNER JOIN members ON members.id = experience.userID 
	    LEFT JOIN members ON (members.level + 1) = levels.level 
	   WHERE members.id = ".$uid;

[blackhat]

@DaveMaxwell

$query = "SELECT experience.experience
, members.level
, levels.xpneed
FROM experience
INNER JOIN members ON members.id = experience.userID
LEFT JOIN members ON (members.level + 1) = levels.level
WHERE members.id = ".$uid;

I get an error with not unique table/alias: ‘members’ ?

[DaveMaxwell]

sorry…copy/paste problem. Should be LEFT JOIN Levels, not LEFT JOIN members

[blackhat]

Thanks, I feel silly. Should at least have been able to see that one myself lol