[SOLVED] Nested Query in while loop

[thefollower]

I have a while loop where by it gets the ID of the user then theres query to get the username of the useid how ever the query is in the while loop so it lags the page alot.. what is the best way to avoid the while loop constantly loading this query but also using the query to obtain the username... this is the while loop.. or the part which im on about:

 

 

while($row = mysql_fetch_assoc($GetReports)){
	$RecordID = $row['RecordID'];
	$Info = $row['Log'];
	$ReportedPlayer = $row['ReportedPlayer'];
//Get name
	$GetUserName = mysql_query("SELECT * FROM userregistration WHERE UserID='$ReportedPlayer'")
		or die(mysql_error());
	$UserNameRow = mysql_fetch_assoc($GetUserName);
	$ReportedPlayer = $UserNameRow['Username'];

 

Is there a better method than this to get username?

[wildteen88]

Don't select everything from the the userregistration table. If you are only want to return the Username then define just the Username column in your query rather than Select all (*)

$GetUserName = mysql_query("SELECT Username FROM userregistration WHERE UserID='$ReportedPlayer'")
		or die(mysql_error());

[thefollower]

Is that still possible if you only wanted say 4 fields... ? or would you have to do * then ?

[wildteen88]

No you can just list them within your query, just separate your columns with a comma, eg:

SELECT Username, col1, col2, col3 FROM userregistration WHERE UserID='$ReportedPlayer'

[thefollower]

Thanks!