I've one problem regarding retriving data from database. I've produced one database in userrecord and it is table title is tbl_user. I'm attempting to display the consumer information once they sign in the machine. i.e view drenched account. The code is the following:

<?php
    include("auth_user.inc.php"); // authrization page
    $uname=$_SESSION['user']; // logged user name
    $connection=mysql_connect("localhost","root"," ");
    mysql_select_db("userrecord",$connection);
    $sql=("select * from table_user where uname ='$uname'");
    $result=@mysql_query($sql,$connection);
    $row=mysql_fetch_array($result);
?>
<html>
    <head>
        <title>User Account</title>
    </head>
    <body bgcolor="#33CCFF">
        <br>Your Details Information Is Shown Below:<br><br>
        First Name:<?php echo $row['fname'];?><br>
        Last Name:<?php echo $row['lname'];?><br>
        Address:<?php echo $row['address'];?><br>
        E-Mail:<?php echo $row['email'];?><br>
        Gender:<?php echo $row['fname'];?><br>
        User Name:<?php echo $row['uname'];?><br>
    </body>
</html>

The code echo $row[' '] isn't exhibiting the record from database.

and it is table title is tbl_user

As well as your SQL was table_user?

Anyway, I did not see others mistake together with your code, exactly that. Whether it would be a typo, attempt to debug your connection, and provide us the mistake message...

try:

<?php
    include("auth_user.inc.php"); // authrization page
    $uname = $_SESSION['user']; // logged user name
    $connection = mysql_connect("localhost","root"," ") or die('Could not connect to database: '.mysql_error());
    mysql_select_db("userrecord",$connection) or die('Could select database: '.mysql_error());
    $sql = "select * from table_user where uname ='$uname'";
    $result = mysql_query($sql) or die ('Mysql error: '.mysql_error.' - '.mysql_errno());
    $row = mysql_fetch_array($result);
?>

no requirement for this @ symbol:

$result=@mysql_query($sql,$connection);

Correction:

$result=mysql_query($sql,$connection);