[SOLVED] query wont call up username

[SirChick]

I have a query that wont call up the username even tho the username is spelt case accurate... is my syntax wrong?

 

$ReportedPlayer = 1;
$GetUserName = mysql_query("SELECT Username FROM userregistration WHERE UserID='$ReportedPlayer'")
		or die(mysql_error());
	$UserNameRow = mysql_fetch_assoc($GetUserName);
	$ReportedPlayer = $UserNameRow['Username'];

[kts]

Just to help you along with debugging, I'd suggest you figure this one out by echoing out your variables and seeing what they contain. That should be able to answer your question.

[craygo]

Yes, you should also break things up so that you can debug when needed

<?php
$ReportedPlayer = 1;
$sql = "SELECT Username FROM userregistration WHERE UserID='$ReportedPlayer'"; 
echo $sql; // Will echo what will be passed to mysql
$GetUserName = mysql_query($sql) or die(mysql_error());
	$UserNameRow = mysql_fetch_assoc($GetUserName);
	$ReportedPlayer = $UserNameRow['Username'];
?>

 

You may also want to check to make sure you are actually connecting to the database

 

Ray

[rajeshrr]

Are you able to get some error message? If not then try executing the same query using phpMyAdmin and see if it works.

 

Regards

Rajesh R R

________________

www.rajeshrr.com

-------------------

Dreams are for ever

-------------------

[SirChick]

its sorted thankyou