ello !
im currently workin on a script what allows members to change their profile. im runnin this code on ma localhost, but i have problems with my web hosting. there is no mysql error, everythin seems to work fine but all my variables are empty...
here is my code :
function edit_profile(){
global $member_id, $login, $password,$nom;
global $prenom, $email, $position, $age;
global $location, $pc_specs, $sensitivity;
global $connection, $pastclans, $interests;
global $fav_map, $fav_weapon, $config, $PHP_SELF;
$id_lien = db_connect($nomdb = \'\');
if(!$id_lien) error_message(sql_error());
$recherche = "SELECT * FROM utilisateurs WHERE (User_ID=\'$member_id\' AND login=\'$login\' AND password=\'$password\')";
$resultat = mysql_query($recherche);
if(!$resultat) error_message(sql_error());
$donnees_rech = mysql_fetch_array($resultat);
$nom = $donnees_rech["nom"];
$prenom = $donnees_rech["prenom"];
$email = $donnees_rech["email"];
$position = $donnees_rech["position"];
$age = $donnees_rech["age"];
$location = $donnees_rech["location"];
$pc_specs = $donnees_rech["pc_specs"];
$sensitivity = $donnees_rech["sensitivity"];
$connection = $donnees_rech["connection"];
$past_clans = $donnees_rech["past_clans"];
$interests = $donnees_rech["interests"];
$fav_map = $donnees_rech["fav_map"];
$fav_weapon = $donnees_rech["fav_weapon"];
$config = $donnees_rech["config"];
?>
<p><b><? echo $login ?></b> - Editing profile</p>
<form name="form" method="post" action="<?echo "$PHP_SELF?module=editprofile&action=submit" ?>" enctype="multipart/form-data">
<table width="90%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="100">first name</td>
<td>
<input type="text" name="prenom" value="<? echo $prenom ?>" class="border"></td>
</tr>
etc, etc .....
I tried everything... i thought there were a problem with ma global variables (?) so i cut the code and tried it out of the function, etc etc... but nothing worked, i always get the same problem :
the variables supposed to be displayed in the form are empty. the $login is the only one working cause i registered it in the session, but i cant take anything from the database....
the most strange thing is that it works perfectly on my localhost and the query result isnt empty ?!? :/
thank you for your help. I spent 4 hours on it, its time to go to bed :*(