Hello, I am still learning php and I have the following code
<?php
$name="{$_GET['name']}";
$city="{$_GET['city']}";
$country="{$_GET['country']}";
$email="{$_GET['email']}";
$pilotId="{$_GET['pilotId']}";
$password="{$_GET['password']}";
$activate="{$_GET['activate']}";
$time = date("m/d/y");
//change user and password to your mySQL name and password
mysql_connect("db5.awardspace.com","darko886_fsacars","");
//select which database you want to edit
mysql_select_db("darko886_fsacars");
$requete = "SELECT activate FROM nonpilots WHERE pilot_id=$pilotId";
$result = mysql_query ($requete);
$article =mysql_fetch_object($result);
mysql_free_result($result);
if ( $activate == "$requete" ) {
$result=mysql_query("INSERT INTO pilots (name,city,country,email,admission_date,status,password)".
"VALUES ('$name', '$city', '$country', '$email', '$time', 'Active', '$password')");
// last entered
$pilotIdone = mysql_insert_id();
//update pilot_num
$result = mysql_query("update pilots set pilot_num='INV$pilotIdone' where pilot_id=$pilotIdone");
echo "<meta http-equiv=\"refresh\" content=\"0;URL=http://www.you-bastards.net/pilot_finish.php?name=$name&city=$city&country=$country&email=$email&time=$time&password=$password&pilotId=$pilotIdone\">";
} else {
print "Not a valid activation code!";
}
?>
But when its executed the browser shows
"; } else { print "Not a valid activation code!"; } ?>
like there is a cutoff or something at the end of my echo.... What is going on?
Thanks
Darko
