php with sql query enigma?

J

jimmy

New member
Here's what I've got:
function update()
{
$xml = "";
$error = "";
$error = " before while ";
$xml = $xml . "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
$query = "SELECT sessionID FROM users WHERE sessionID<>''";
$result = mysql_query($query);
while (($element = mysql_fetch_assoc($result)))
{
$error = $error . " in while ";
$tbl = $element["sessionID"];
$error = $error . $tbl . " "; //TBL HAS CORRECT VALUE RIGHT HERE
$xml = $xml . "<session id=" . $tbl . ">\n";
$q = "SELECT username FROM users WHERE sessionID='$tbl'";
$r = mysql_query($query);

while(($usernamear = mysql_fetch_assoc($r)))
{
$error = $error . " in second while "; //THIS POINT IS REACHED
$name = $usernamear["username"]; //WHICH MEANS THIS IS
$error = $error . $name . " "; //BUT NAME IS BLANK
$xml = $xml . "<user>\n";
$xml = $xml . "<username>" . $name . "</username>\n";
$xml = $xml . "</user>\n";
}
$xml = $xml . "</session>\n";
}
return $error; //OR RETURN $XML, WHICH IS WHAT I'LL END UP DOING.

This is my database (username, password, sessionID) all varchars
myusername
*252803....hash.........
testsession
 
Back
Top