big problemo

[Anon]

i made a script, where a user logs in, then once they hit login, they are taken to a page where it checks there username and password:
$sql = "SELECT username
FROM $table_name
WHERE username = \"$username\" and password = password(\"$password\")
";

but when they go to the next page, i only have:
$sql = "SELECT username, belief
FROM $table_name
";
so when it says "Hi $username!" it won't say the correct persons username, it will say some other persons username, is there an easy way of keeping track of there user name on multiple pages?

[Anon]

cookies or sessions

[Anon]

i have a cookie already, but i guess i dont have the correct information in it...
$cookie_name = "gameauth";
$cookie_value = "ok";
$cookie_expire = "";
$cookie_domain = "";
setcookie($cookie_name, $cookie_value, $cookie_expire, "" , $cookie_domain, 0);

on the pages after the one i set the cookie on, i put:
if ($gameauth == "ok") {
then i put all the php on the page here...
$display_block = what i want to be said on the page
} else {
$display_block = then what i want unlogged in users to see here

i hope what i said isnt too confusing, thanks craig for trying, i appreciate it 🙂

[Anon]

wish i could help, but i'm confused by the description of your code on the first post.

but i would like to point this out, if you are looking for some sort of security, you have none...

i check out your site and look at my cookies
i see gameauth = notok
i clear my cookies
i type www.yoursite.com/index.php?gameauth=ok

just a suggestion.

[Anon]

i dont really need much security, i just need people to login so that they get the right information 🙂