This is retarded

[happyhippy]

This is what I have all it does is come up with blank page I've been working on this for 8 hours with no change looked everywhere no idea what to do.

 

<?php 

// Connects to your Database 

mysql_connect("localhost", "name", "password") or die('Error: '.mysql_error()); 

mysql_select_db("database") or die(mysql_error());

if(isset($_COOKIE['ID_my_site'])) 

{ 
//$username of login user
	$username = $_COOKIE['ID_my_site']; 

	$pass = $_COOKIE['Key_my_site']; 

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

	while($info = mysql_fetch_array( $check )) 	 

		{ 
//fname is the first name of login user
	 Print "<b>Name:</b> ".$info['fname'] . " "; 
}}

?> 

 

my database is all on one table

 

id | username | password | fname | lname

 

1 | unsernam1 | **** | John | Doe

2 | unsernam2 | **** | Amy | Jane

3 | unsernam3 | **** | Doug | Smith

 

I want it so that when the new page upons it finds the username (Like usernam2) in database and prints out the users first name etc in.

 

Help?

[jcbones]

If this outputs anything, copy/paste the output here.

<?php 
error_reporting(-1);
ini_set('display_errors',1);
// Connects to your Database 

mysql_connect("localhost", "name", "password") or die('Error: '.mysql_error()); 

mysql_select_db("database") or die(mysql_error());

if(isset($_COOKIE['ID_my_site'])) 

{ 
//$username of login user
	$username = $_COOKIE['ID_my_site']; 

	$pass = $_COOKIE['Key_my_site']; 

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

	while($info = mysql_fetch_array( $check )) 	 

		{ 
//fname is the first name of login user
	 Print "<b>Name:</b> ".$info['fname'] . " "; 
}}

?> 

[smerny]

try using more descriptive subjects in the future...

[happyhippy]

Solved

 

What an idiot I never realized my cookie had expired.

 

Thank you

[Adam]

Hmm.. Is your login detection just checking if a cookie is set? What's to stop me setting a "ID_my_site" cookie to your username?