elseif ....... if($submit) {

[Anon]

hi
im currently working on a php script. here is the code where the error lies...

if (!isset($mode))

include ("panel.inc");

elseif($mode=="edit") {

if ($submit) {

$sql = "UPDATE users SET first='$first',last='$last',address='$address',city='$city',state='$state',postcode='$postcode' WHERE cusername=$PHP_AUTH_USER");

$result = mysql_query($sql);

	echo "Information updated successfully!\n";

include ("header.inc");

echo "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";

echo "<tr><td><center><img src=\"images/edit_title.gif\"></center>\n";

echo "</td></tr><tr><td>\n";

echo "<center><font face=\"$font_type\" size=\"3\">&nbsp;</font><font face=\"$font_type\" size=\"1\"><br>\n";

echo "</font>\n";

echo "<table width=\"96%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";

echo "<tr><td><font face=\"$font_type\" size=\"2\">Below are your current details, modify them as you wish. Once you have finished,\n";

echo " click modify at the bottom!<br>&nbsp;<br>&nbsp;\n";

echo "</font></td></tr></table></center></td></tr></table><br>\n";

include ("edit_form.inc");

include ("footer.inc");

} else {

include ("header.inc");

echo "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";

echo "<tr><td><center><img src=\"images/edit_title.gif\"></center>\n";

echo "</td></tr><tr><td>\n";

echo "<center><font face=\"$font_type\" size=\"3\">&nbsp;</font><font face=\"$font_type\" size=\"1\"><br>\n";

echo "</font>\n";

echo "<table width=\"96%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";

echo "<tr><td><font face=\"$font_type\" size=\"2\">Below are your current details, modify them as you wish. Once you have finished,\n";

echo " click modify at the bottom!<br>&nbsp;<br>&nbsp;\n";

echo "</font></td></tr></table></center></td></tr></table><br>\n";

include ("edit_form.inc");

include ("footer.inc"); }

}
?>

Anyway, when the user goes to index.php?mode=edit, they get a form which shows the users information in text fields (from the mysql database). The user can then modify this information and once he/she has finished modifying, they click "modify". Once they click modify, their information is supposed to be updated.

However, this is what happens...

when they click MODIFY, the success message comes up saying "Information updated successfully!" however, nothing is actually updated.

can anyone help me?

Thanks!
Khilan

[Anon]

One thing that I am pretty sure is incorrect is that you have a close parenthesis at the end of you SQL modification statement:

$sql = "UPDATE users SET first='$first',last='$last',address='$address',city='$city',state='$state',postcode='$postcode' WHERE cusername=$PHP_AUTH_USER");

[Anon]

Hi,
i added '' to the $PHP_AUTH_USER variable and removed the bracked at the end but it still doesnt seem to update to the database.

any other ideas?

thanks,
khilan

[Anon]

I do not see this anywhere:

mysql_connect("$DBHost","$DBUser","$DBPass");

In my first quick look, I thought maybe that this function was in 'panel.inc' but maybe that is not the case, since the include is called only if $mode exists.

[Anon]

Hi,
ok how it works is this. index.php is a file that does all the authorization. it pops up a username / password box. the username variable is stored as $PHP_AUTH_USER and the password is stored as $PHP_AUTH_PASS. If the user successfully authorizes, then the file will include mode.inc (the file i pasted in) then mode.inc will include panel.inc (the main program).

it would not let me put $myrow = mysql_fetch_array($result); in the mode.inc file. I could only put it in the index.php file. Also, could the problem be because i have a isset inside a isset?

also, the mysql_connect is in index.php

Thanks,
khilan

[Anon]

Put mysql_connect(); into mode.inc above your modification statement and try that. I believe you need to reconnect, unless I am missing something.

[Anon]

hi,

do you think i should disconnect first from the mysql database "mydb" ?. if so, how would i go about disconnecting?

Thanks,

Khilan Gudka

[Anon]

I believe you will disconnect by default unless you use mysql_pconnect(); - but please check the mysql manual.