Mysql showing values

[Dobby]

Hello i have a login and register script but when people login in i want it to show what rank they are.

So when a person logs in it will say

Welcome "user"
Your rank is: "Rank"

How would i do this?

 

[Sysode]

Post some snippets of your code?

 

[Dobby]

The members mage

                    <?php
session_start();
require_once("connect.php");
 
// Check his status.
if (!empty($_SESSION[username])) // he got it.
{
   
    echo "You are currently logged in as <b>$_SESSION[username]</b>.<br>";
    echo "Your Pre-Alpha rank is:";
   
   
   
   
   
   
   
   
}
else // bad info.
{
    echo "You are currently <b>NOT</b> logged in.";
}
 
?>

Login

<?php
session_start();
// Check if he wants to login:
if (!empty($_POST[username]))
{
    require_once("connect.php");
 
    // Check if he has the right info.
    $query = mysql_query("SELECT * FROM members
                            WHERE username = '$_POST[username]'
                            AND password = '$_POST[password]'")
    or die ("Error - Login failed.");
   
    $row = mysql_fetch_array($query)
    or die ("Error - Login failed.");
   
    if (!empty($row[username])) // he got it.
    {
        $_SESSION[username] = $row[username];
        echo "Welcome $_POST[username]! You've been successfully logged in.<br>";
        echo "right now the UCP is being worked on but you are on the system.<br>";
        exit();
    }
    else // bad info.
    {
        echo "Error - Login failed.<br /><br />
            Please try again.";
        exit();
    }
}
 
?>

 

[Sysode]

Do you have a table called ranks in your database?

 

[Dobby]

yes, well its in the table members

 

[DaLightz]

$dbquery = mysql_query("SELECT rank FROM ranktable WHERE username=""$SESSION['username']");

 

rank is: <?php echo $dbquery ?>

I think.

 

[Dobby]

$dbquery = mysql_query("SELECT rank FROM ranktable WHERE username=""$SESSION['username']");

 

rank is: <?php echo $dbquery ?>

I think.

That wont work? I dunno where you are getting rank table from?

database is

u739026383_beta ​

inside is the table: members with a colum called: Rank. Default is member​

 

[Weasel]

change
$dbquery = mysql_query("SELECT rank FROM ranktable WHERE username=""$SESSION['username']");

with
$dbquery = mysql_result("SELECT rank FROM ranktable WHERE username=""$SESSION['username']");

 

[DaLightz]

change
$dbquery = mysql_query("SELECT rank FROM ranktable WHERE username=""$SESSION['username']");

with
$dbquery = mysql_result("SELECT rank FROM ranktable WHERE username=""$SESSION['username']");

Yeah, this.

 

[Dobby]

Nope didnt work

 

[Weasel]

Nope didnt work

What is it showing?

 

[Dobby]

Parse error: syntax error, unexpected '"' in /home/u739026383/public_html/members.php on line 67

 

[DaLightz]

Parse error: syntax error, unexpected '"' in /home/u739026383/public_html/members.php on line 67

Fix the quotes.

 

[Dobby]

Fix the quotes.

How? Whats ment to go there? :L im not good with php

 

[DaLightz]

$dbquery = mysql_result("SELECT rank FROM ranktable WHERE username="$SESSION['username']"");
There.

 

[Dobby]

-.- Parse error: syntax error, unexpected '$SESSION' (T_VARIABLE) in /home/u739026383/public_html/members.php on line 67

 

[Khalil]

$dbquery = mysql_result((mysql_query("SELECT rank FROM YOURTABLENAMEHERE WHERE username = '".$_SESSION['username']."'")), 0);

 

[Weasel]

change
$dbquery = mysql_result("SELECT rank FROM ranktable WHERE username=""$SESSION['username']");

with
$dbquery = mysql_result("SELECT rank FROM ranktable WHERE username='".$SESSION['username']."');

 

[Dobby]

Thanks. Works now