update !! help plz

3yoon_af

[FONT="Comic Sans MS"]
Hi all,

I have a problem in the update the data in the database ,,

I wrote the code and it will give me a msg "you success to update " if it is upate in the database..

the code give me this massage but the data doesn't change in the database !!

Can anyone help me and know where is the wrong ?

also, there are some account the success massage appears to them, but other they give them a massage:
Could not update your information becouse of either Syntax error or a database problem

Can u help, please ?

This is my code

This is some code from the form page ..
I can call the information from the database but I can't modify it ..[/FONT]

<?
session_start();
$SESSION['user_name']= $user_name;
$SESSION['Pass']= $Pass;
?>

<?php

include ("connect.php");
include ("redirect.php");

$sel= "SELECT * FROM student_info WHERE ( user_name = '".mysql_real_escape_string($user_name)."' ) ";
$result = mysql_query($sel)or die ("could Not execute query $sel");
$row=mysql_fetch_array($result);

echo "$user_name";

?>

<p dir="ltr"><b>user name: </b> 
<input type="text" name="user_name" size="20" value="<?echo $row['user_name'];?>"></p>
<p dir="ltr"><b>First name: </b> 
<input type="text" name="Student_f_name" size="20" value="<?echo $row['Student_f_name'];?>"></p>
<p><b>Last name: </b>  
<input type="text" name="Studnet_l_name" size="20" value="<?echo $row['Studnet_l_name'];?>"></p>
<p><b>ID:  </b> <input type="text" name="Studnet_ID" size="10" value="<?echo $row['Student_ID'];?>" ></p>
<p><b>Age:</b> 
<select size="1" name="Student_age" value="<?echo $row['Student_age'];?>">
<option value= "<?echo $row['Student_age'];?>"><?echo $row['Student_age'];?> </option>
<option>20_23</option>
<option>24_28</option>
<option>29_35</option>
<option>36 to up</option>
</select></p>

[FONT="Comic Sans MS"]the update engine[/FONT]

$i=0;

$sql= "UPDATE student_info SET
Student_f_name = '$Student_f_name',
Studnet_l_name = '$Studnet_l_name',
Student_ID = '$Student_ID',
Student_age = '$Student_age',
Student_gender = '$Student_gender',
Student_status = '$Student_status',
Student_child_b = '$Student_child_b',
Student_child_d = '$Student_child_d',
Student_city = '$Student_city',
Studnet_phon = '$Studnet_phon',
Studnet_mobile = '$Studnet_mobile',
Student_qual = '$Student_qual',
Student_major = '$Student_major',
Student_join = '$Student_join',
Student_graduate = '$Student_graduate',
Student_exp_y = '$Student_exp_y',
Student_exp_m = '$Student_exp_m',
email = '$email',
student_skill = '$student_skill',
user_name = '$user_name'
                          WHERE user_name = '$user_name' ";
$result= mysql_query($sql) or die ("Could not update your information becouse of either Syntax error or a database problem ?!");

redirect("succ_post_cv.htm");

[FONT="Comic Sans MS"]I need a help please because the work must be submit in the next week 🙁[/FONT]

halojoy

hello
my middle-east php friend

Try to change this, so you GET MySQL_error,
to see if mysql database can tell you what is wrong.
It might be your UPDATE query, that does not work.

More how you can and should use mysql_error()
is here:
http://docs.php.net/mysql_error

Regards 🙂
halojoy - north europe = Sweden!

<?php

$result = mysql_query($sql) 
        or die ( "Could not update your information 
                    becouse of either Syntax error or a database problem ?!" );

// Change to this:
$result = mysql_query($sql) 
        or die ( "Could not update:<br />" . mysql_error() );

?>

bradgrafelman

If the query never works, try adding a echo $sql; to the code so that you can copy and paste the query being sent to the DB in a post for us to see.
Where do you define $Student_f_Name? Or $Student_l_name? Or... (etc.)? If you never define them, then you are using non-existent variables. If you're attempting to use the data POST'ed via the form, then you should be using the $_POST superglobal array to get this data. More information about the superglobal arrays can be found here: [man]variables.predefined[/man].
If you say some queries give an error message, that must mean that the syntax errors depend on the user input. In other words, you're not sanitizing the input. User-supplied data should never be placed directly in a SQL query; instead, you must first sanitize it with a function such as [man]mysql_real_escape_string/man.