[SOLVED] MySQL / PHP problem...

[lill87]

Ive recently made a login feature on my site, and MySQL doesnt want to read in the redirected area.

 

my auth.php file:

<?php

mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("xxxxx") or die(mysql_error());

include 'codelib.php';

session_start();

$username = $_POST['username'];
$password = $_POST['password'];

if (isset($_POST["username"]) && isset($_POST["password"]))
{

// MySQL Data

$resulta = mysql_query("SELECT * FROM accounts WHERE username='$username'");
$resultb = mysql_query("SELECT * FROM bans WHERE username='$username'");

$rowa = mysql_fetch_array( $resulta );
$rowb = mysql_fetch_array( $resultb );

if(($rowb['banned']) == 1)
{
mainmenubanned();
}
if(($rowb['banned']) == 0)
{

if(($username == $rowa['username']) && ($password == $rowa['password']))
{

$_SESSION['user_logged'] = true;
$_SESSION['username'] = $rowa['username'];
$_SESSION['password'] = $rowa['password'];


header("Location: game.php");
exit;

}
mainmenuerror();
}

}

?>

 

my game.php file:

<?php

mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("xxxxx") or die(mysql_error());

include 'codelib.php';

session_start();

// MySQL Data

$username = $_SESSION['username'];
$resultacc = mysql_query("SELECT * FROM accounts WHERE username='$username'");

$rowacc = mysql_fetch_array($resultacc);

// MySQL Data END

if (!isset($_SESSION["user_logged"]) || $_SESSION["user_logged"] != true)
{
header("Location: index.php");
exit;
}

echo $rowacc['username'];

?>

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

The echo $rowacc['username']; wont work.

 

But echo $_SESSION['username']; and echo $username; works perfectly.

 

 

now, why doesnt it read:

 

$resultacc = mysql_query("SELECT * FROM accounts WHERE username='$username'");

 

$rowacc = mysql_fetch_array($resultacc);

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

 

Any help appreciated!!

 

[Corona4456]

so are you sure that whatever is stored in $username is in the 'account' table?

use 'mysql_error()' to see if you get an error for your mysql_query().

[lill87]

so are you sure that whatever is stored in $username is in the 'account' table?

use 'mysql_error()' to see if you get an error for your mysql_query().

 

Yeah, I checked again now, still doesnt get any error.

 

Im so confused, i cant find any errors  :-\ and ive been trying to look for it all day

[Barand]

first step is to check for errors in query

 

$resultacc = mysql_query("SELECT * FROM accounts WHERE username='$username'") or die(mysql_error());

 

echo mysql_num_rows($resultacc);          // add to see if any record is found if no error

[lill87]

first step is to check for errors in query

 

$resultacc = mysql_query("SELECT * FROM accounts WHERE username='$username'") or die(mysql_error());

 

echo mysql_num_rows($resultacc);          // add to see if any record is found if no error

 

it printed the number: 1

 

btw: this is how my create table file looks like, when i created the table:

 

mysql_query("CREATE TABLE accounts
(
accid INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(accid),
pkills varchar(30),
mkills varchar(30),
deaths varchar(30),
username varchar(30),
password varchar(30),
firstname varchar(30),
lastname varchar(30),
email varchar(30),
country varchar(30),
gender varchar(30),
reckey varchar(30),
hidecontact varchar(30),
date varchar(30),
position varchar(30),
donated varchar(30),
level varchar(30),
health varchar(30),
healthmax varchar(30),
experience varchar(50),
title varchar(30),
align varchar(30),
energy varchar(30),
lastlogin varchar(30),
ip varchar(30),
guildname varchar(30),
comment tinytext,
reputation varchar(30),
gold varchar(30),
bank varchar(30),
online varchar(30),
vocation varchar(30),
mainhand varchar(40),
offhand varchar(40),
head varchar(40),
chest varchar(40),
shoulder varchar(40),
hands varchar(40),
legs varchar(40),
feet varchar(40),
ring varchar(40),
duelwon varchar(40),
duellost varchar(40),
guild varchar(50),
slot1 varchar(50),
log1 varchar(50),
mail1 varchar(50),
strength int(10),
agility int(10),
stamina int(10),
intelligence int(10),
luck int(10),
skillpoints int(10)
)")
or die(mysql_error());

[Barand]

if you comment out this bit of code

 

if (!isset($_SESSION["user_logged"]) || $_SESSION["user_logged"] != true)
{
header("Location: index.php");
exit;
}

 

does it then print the username?