Indie-Resource.com

SpiritWebb wrote:

Torniquet wrote:im pretty sure you need to have the include in there lol. as its trying to access a DB. in halls tut as far as i can remember he is not accessing any DBs.

stick the include in and see if it works :p

i did place the include_once, its in the above code, and it still doesnt work.

hallsofvallhalla wrote:ah you are missing your where.....insert into players.......where id=$id ect

<?php
include_once 'connect.php';
session_start();

$lastlogin=$_POST['lastlogin']

$datetime=date("d/m/y h:i:s");

$SQL="INSERT into players where lastlogin=$lastlogin (lastlogin) VALUE('$datetime');  ///or should i leave this (lastlogin) VALUE('$datetime'); out?///
$result=mysql_query($SQL) or die ("MySql Error");

session_destroy();
?>

Torniquet wrote:

SpiritWebb wrote:

Torniquet wrote:im pretty sure you need to have the include in there lol. as its trying to access a DB. in halls tut as far as i can remember he is not accessing any DBs.

stick the include in and see if it works :p

i did place the include_once, its in the above code, and it still doesnt work.

feel free to call me spasticated.... but i cannot see it lol

SpiritWebb wrote:Here is the entire code:

I didnt change nothing with the code that halls provided with the tutorial. Except add the code in between session_start() and session_destroy(). I added the include_once 'connect.php'; command, and now I just get MySql Error

hallsofvallhalla wrote:no you are missing a player session, but it would look like

Code: Select all

$sql="INSERT INTO players (lastlogin)VALUES('$datetime') where name='$session(player)'";
$result=mysql_query($sql) or die("MySql Error");

$SQL="INSERT INTO players (lastlogin)VALUES('$datetime') where name='$lastlogin(player)'";  ///$session had an undefined index in $session///
$result=mysql_query($SQL) or die("MySql Error");

Torniquet wrote:im not sure about this... but i think where halls has put $session(player)

its ment to be $_SESSION(player)

repost all your code n we can have a look. because frankly all your different posting as editing without posting a new complete script is confusing :p

<?php
include_once 'connect.php';
  session_start();
  $lastlogin=$_POST['lastlogin'];
  $datetime=date("d/m/y h:i:s");

  $SQL="INSERT INTO players (lastlogin)VALUES('$datetime') where name='$_SESSION(player)'";
  $result=mysql_query($SQL) or die("MySql Error");

  session_destroy();
 
?>

hallsofvallhalla wrote:activate the player session before calling it. My original code will work but you must either make it like $_SESSION(as t suggested)

or make a variable $player = $_SESSION(player);

there is not 17 lines in your code

<?php
include_once 'connect.php';
  session_start();
  $player=$_SESSION(player);
  $lastlogin=$_POST['lastlogin'];
  $datetime=date("d/m/y h:i:s");

  $SQL="INSERT INTO players (lastlogin)VALUES('$datetime') where name='$_SESSION(player)'";
  $result=mysql_query($SQL) or die("MySql Error");

  session_destroy();

?>