Mark Hensler — Wed, 17 Nov 2004 03:06:08 +0000

Does the new server have a different version of PHP? It may not have register_globals on.

Try:
$username = strtolower( $_POST['username'] );

Busy — Mon, 01 Nov 2004 10:13:44 +0000

put your session register variables below the listing of the database variables

$sid_user = $data->realname;
$sid_email = $data->email;
$curr = $data->currency;
session_start();
session_register( "sid_user" );
session_register( "sid_email" );
session_register( "curr" );

you can also do the session register with one variable: session_register("sid_user","sid_email","curr");

mizzy — Sun, 31 Oct 2004 20:01:45 +0000

I think the problem is with the way the session anf URL variables are being handled... I have tried to put actual data into the query
eg
$result = mysql_query( "select * from users where username='test' and password='test'");

It logs me in fine though it does not carry the session variables for the name and the like... any ideas what the problem could be?

Busy — Sat, 30 Oct 2004 21:25:41 +0000

break this down into two lines : $result = mysql_query( "select * from users where username='$username' and password='$password'");

something like:
$query = "select * from users where username='$username' and password='$password'";
$result = mysql_query($query);

then you can display the query: echo $query;

can also try:
$query = "select * from users where username='".$username."' and password='".$password."'";