December 6th, 2002, 12:25 AM
|
|
Contributing User
|
|
Join Date: Aug 2002
Posts: 67
Time spent in forums: < 1 sec
Reputation Power: 7
|
|
|
Confused
Sorry to bother with this but it is eluding me.
I am trying to fight my way through how to use sessions and to detect who is online. I have my own weired way that Ibeleive should work but I for somereason can not update to a tabel.
I get no errors. here is the coding.
PHP Code:
<?
include ($conf['rootdir']."includes/functions/dbconnect.php");
dbconnect ();
$name = mysql_query("SELECT name FROM member WHERE name = '$name' AND password = PASSWORD('$password')");
$num_rows = mysql_num_rows($name);
if ($num_rows <= 0)
{
echo "<p align= center>You either entered your user name or password wrong.</p>";
exit;
}
if(mysql_num_rows($name) != 0)
{
$verified_user = $memberid;
$wired = (time()) + 10; //I want to add 10 minutes
session_register($wired);
echo $wired;
$showonline = ("UPDATE member SET online ='$wired' WHERE memberid = '$memberid'") or die ("Not updating.");
$result = mysql_query($showonline) or die ("Query failed");
echo ("inside if");
}
echo "<p align= center>You are now loged in</p>";
?>
Here is the database. I am wondering if I need to say more.
PHP Code:
CREATE TABLE member (
memberid int(11) NOT NULL auto_increment,
name text NOT NULL,
password text NOT NULL,
gamename text NOT NULL,
df1 tinytext NOT NULL,
df2 tinytext NOT NULL,
dflw tinytext NOT NULL,
tfd tinytext NOT NULL,
bhd tinytext NOT NULL,
gametag text NOT NULL,
perweapon text NOT NULL,
picturedata text NOT NULL,
picturename text NOT NULL,
picturetype text NOT NULL,
quote text NOT NULL,
status text NOT NULL,
position text NOT NULL,
email text NOT NULL,
msn text NOT NULL,
icq text NOT NULL,
aol text NOT NULL,
yahoo text NOT NULL,
website text NOT NULL,
number int(11) NOT NULL default '0',
allow int(11) NOT NULL default '1',
online TEXT NOT NULL;
PRIMARY KEY (memberid),
KEY memberid (memberid)
);
I thought that maybe it was my connection to the database but my connection is working on all the other pages I use this code in the same loacation. I thought it would tell me not updating but it isn't.
Please help.
Thanks,
Attila
__________________
Thanks,
Attila
http://www.glorynaspiration.com
http://www.abitofthings.com
|
Dev Articles Community Forums Sponsor:
I can move on!
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
