$_GET Problem

[RobRocker]

Howdy... I am having problems retrieveing information passed in the URL.

I have a simple variable passed named "id_eve". I want to get that information and use it to pass to another URL.

Here is my code.

<?php 
$id = ($_GET['id_eve']);
$page = ("calenderedit.php?id_eve=" . $id);
?>
<?php 
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['email'])) {
  $loginUsername=$_POST['email'];
  $password=$_POST['password'];
  $MM_fldUserAuthorization = "";
 $MM_redirectLoginSuccess = $page;
  $MM_redirectLoginFailed = "calender.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_calendar, $calendar);

  $LoginRS__query=sprintf("SELECT user_email, user_pass FROM rsCalendar_users WHERE user_email='%s' AND user_pass='%s'",
    get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); 

  $LoginRS = mysql_query($LoginRS__query, $calendar) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
     $loginStrGroup = "";

//declare two session variables and assign them
$_SESSION['MM_Username'] = $loginUsername;
$_SESSION['MM_UserGroup'] = $loginStrGroup;	      

if (isset($_SESSION['PrevUrl']) && false) {
  $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
}
header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>

When I upload that it doesnt work, I also tried to take out the () around the $_GET... Soo... Any suggestions? Thanks.

[NogDog]

What symptoms are telling you that the problem is that $GET variable? If that's where you think the problem is, have you tried some debugging by doing a print_r($GET) to see exactly what variables were received by the page?

[RobRocker]

Its not passing the variable from this page to the next page, I get the correct $_GET when I do the debug you suggested. It will not pass the variable through to the next page.

I get this error when I use this variable to try to pass.

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Here is the code I am pinpointing

$id = $_GET['id_eve'];
 $MM_redirectLoginSuccess = "calenderedit.php?id_eve=$id";