[RESOLVED] Problem with my edit account

theprofession

For some reason it doesn't post the bio to the database can anyone help?

<?

include("include/session.php");
?>

<html>
<title>The lounge</title>
<body>

<?
/**
 * User has submitted form without errors and user's
 * account has been edited successfully.
 */
if(isset($_SESSION['useredit'])){
   unset($_SESSION['useredit']);

   echo "<h1>User Account Edit Success!</h1>";
   echo "<p><b>$session->username</b>, your account has been successfully updated. "
       ."<a href=\"main.php\">Main</a>.</p>";
}
else{
?>

<?
/**
 * If user is not logged in, then do not display anything.
 * If user is logged in, then display the form to edit
 * account information, with the current email address
 * already in the field.
 */
if($session->logged_in){
?>

<h1>User Account Edit : <? echo $session->username; ?></h1>
<?
if($form->num_errors > 0){
   echo "<td><font size=\"2\" color=\"#ff0000\">".$form->num_errors." error(s) found</font></td>";
}
?>
<form action="process.php" method="POST">
<table align="left" border="0" cellspacing="0" cellpadding="3">
<tr>
<td>Current Password:</td>
<td><input type="password" name="curpass" maxlength="30" value="
<?echo $form->value("curpass"); ?>"></td>
<td><? echo $form->error("curpass"); ?></td>
</tr>
<tr>
<td>New Password:</td>
<td><input type="password" name="newpass" maxlength="30" value="
<? echo $form->value("newpass"); ?>"></td>
<td><? echo $form->error("newpass"); ?></td>
</tr>
<tr>
<td>Email:</td>
<td><input type="text" name="email" maxlength="50" value="
<?
if($form->value("email") == ""){
   echo $session->userinfo['email'];
}else{
   echo $form->value("email");
}
?>">
</td>
<td><? echo $form->error("email"); ?></td>
</tr>
<tr>
<td valign="top">
Bio:
</td>
<td>
<textarea name="bio" cols="30" rows="10" value="<? echo $form->value("bio"); ?>"></textarea>
</td>
</tr>
<tr><td colspan="2" align="right">
<input type="hidden" name="subedit" value="1">
<input type="submit" value="Edit Account"></td></tr>
<tr><td colspan="2" align="left"></td></tr>
</table>
</form>

<?
}
}

?>

</body>
</html>

bradgrafelman

How are we supposed to know what the problem is when we don't know what process.php is doing (or not doing) to enter this info into the database?

NogDog

I don't see anything in the code you've provided where any kind of SQL interaction is performed with the database.

theprofession

it wont let me post the process.php

bradgrafelman

Why not? Is it too long? You could try posting only the relevant part that deals with the SQL database interaction.

NogDog

Presumably somewhere in the update processing code you have a mysql_query() command. You might start your debugging by making sure the SQL it is using is valid by using the following pattern:

$sql = "YOUR SQL UPDATE STATEMENT GOES HERE";
$result = mysql_query($sql) or die("Query failed: $sql - " . mysql_error());

(To be completely clear: replace the "YOUR SQL UPDATE STATEMENT GOES HERE" with whatever actual SQL your code is using at that point.)

theprofession

Ok i figured out the problem with updating the bio its just getting it to post to the page where I want it to go.