Hello,

I have some problems with the usage of <{$xoops_uname}>.

I want to select something out from the database, but I don't know why something will be selected out after "stdID = 50724692" have been changed to "stdID =<{$xoops_uname}>".

Can everyone help me


The statements that I type in a block:
____________________________________________________________
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("fyp", $con);

$result = mysql_query("SELECT stdID FROM student
WHERE stdID =<{$xoops_uname}>");

while($row = mysql_fetch_array($result))
{
echo $row['stdID'];
echo "
";
}

mysql_close($con);
____________________________________________________________

<{$xoops_uname}> is a template variable reference. It's only suitable for use in Smarty templates.

In PHP code you would obtain the current username like this: