I had a code working fine that updates a users profile. I then added the echo function so that someone can see what is currently in their profile. For example if there phone number changes they can see their existing phone number and then change it to their new one.
However the update code no longer works. I must have changed it somehow.
This is the error it creates. But 'form_id' is not in the field list. Is it reading it twice from the submit function?
Any suggestions please. I thought it would be a simple job.
UPDATE users SET category = '', aboutcompany = '', firstname = '', surname = '', email = '', website = '', company = '', building = 'g', streetname = '', town = '', state = '', postcode = '', country = '', form_id = 'submit', submit = 'Submit' WHERE id=163An error occurred Unknown column 'form_id' in 'field list'
<?php
if(isset($_POST['form_id']))
{
$values = '';
foreach ($_POST as $key => $val)
{
if( isset($_POST['form_id']))
unset($_POST['form_id']);
{
$values .= "{$key} = '" . mysql_real_escape_string(trim($val)) . "', ";
}
}
$values = rtrim($values, ', ');
$error = "";
if($error == "")
{
$sql = "UPDATE users SET {$values} WHERE id=".$_SESSION['userID'];
echo $sql;
$result = mysql_query($sql) or die("An error occurred ".mysql_error());
}
}
?>
<div class="updateformleft">
<form class="form_id" class="appnitro" method="post" action="">
<?php if($error) echo "<span style=\"color:#ff0000;\">".$error."</span><br /><br />"; ?>
<ul >
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
Your Job Role:
</div>
<div id="forminputright">
<select class="element select medium" name="category" id="category" >
<option value="" selected="selected">Venue:</option>
<option value="Brand Marketer" >Brand Marketer</option>
<option value="Entertainment Promoter" >Entertainment Promoter</option>
<option value="Event Manager" >Event Manager</option>
<option value="Event Organiser" >Event Organiser</option>
<option value="Party Planner" >Party Planner</option>
<option value="Wedding Organiser" >Wedding Organiser</option>
</select>
</div>
</li>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['category'];
}
?>
</div>
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
About Your Company: <?php echo $row['category']; ?>
</div>
<div class="forminputright">
<textarea class="element_2" name="aboutcompany" class="element textarea medium" value="<?php if($_POST['aboutcompany']) echo $_POST['aboutcompany']; ?>"></textarea>
</div>
</li>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['aboutcompany'];
}
?>
</div>
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
First Name:
</div>
<div class="forminputright">
<input class="element_1" name="firstname" class="registerforminput" type="text" value="<?php if($_POST['firstname']) echo $_POST['firstname']; ?>" />
</div>
</li>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['firstname'];
}
?>
</div>
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
Surname:
</div>
<div class="forminputright">
<input class="element_1" name="surname" class="registerforminput" type="text" value="<?php if($_POST['surname']) echo $_POST['surname']; ?>" />
</div>
</li>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['surname'];
}
?>
</div>
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
Email:
</div>
<div class="forminputright">
<input class="element_1" name="email" class="registerforminput" type="text" value="<?php if($_POST['email']) echo $_POST['email']; ?>" />
</div>
</li>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['email'];
}
?>
</div>
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
Company Website:
</div>
<div class="forminputright">
www. <input class="element_1" name="website" class="registerforminput" type="text" value="<?php if($_POST['website']) echo $_POST['website']; ?>" />
</div>
</div>
</li>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['website'];
}
?>
</div>
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
Company Name:
</div>
<div class="forminputright">
<input class="element_1" name="company" type="text" class="registerforminput" value="<?php if($_POST['company']) echo $_POST['company']; ?>" />
</div>
</li>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['company'];
}
?>
</div>
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
Building Name/Number:
</div>
<div class="forminputright">
<input class="element_1" name="building" class="registerforminput" type="text" width="600" value="<?php if($_POST['building']) echo $_POST['building']; ?>" />
</div>
</li>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['building'];
}
?>
</div>
<div class="updateinputcell">
<div class="forminputleft">
Street Name:
</div>
<div class="forminputright">
<input class="element_1" name="streetname" class="registerforminput" type="text" maxlength="600" value="<?php if($_POST['streetname']) echo $_POST['streetname']; ?>" />
</div>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['streetname'];
}
?>
</div>
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
Town:
</div>
<div class="forminputright">
<input class="element_1" name="town" class="registerforminput" type="text" maxlength="600" value="<?php if($_POST['streetname']) echo $_POST['town']; ?>" />
</div>
</li>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['town'];
}
?>
</div>
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
State:
</div>
<div class="forminputright">
<input class="element_1" name="state" class="registerforminput" type="text" maxlength="600" value="<?php if($_POST['state']) echo $_POST['state']; ?>" />
</div>
</li>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['state'];
}
?>
</div>
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
Zip Code/Post Code:
</div>
<div class="forminputright">
<input class="element_1" name="postcode" class="registerforminput" type="text" maxlength="600" value="<?php if($_POST['postcode']) echo $_POST['postcode']; ?>" />
</div>
</li>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['postcode'];
}
?>
</div>
<div class="updateinputcell">
<li class="li_1" >
<div class="forminputleft">
Your Country:
</div>
<div class="forminputright">
<select class="element select medium" class="country" name="country">
<option value="" selected="selected">Your Country:</option>
<option value=” selected=’selected’>Select Country</option>
<option value="" selected="selected">Select a Country</option>
<option value="United States">United States</option>
</select>
</div>
</li>
</div>
<div class="updatecurrentcell">
<?php
$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['userID']);
while($row = mysql_fetch_array($query)) {
echo $row['country'];
}
?>
</div>
</div>
</div>
<div class="forminputright">
<li class="buttons">
<input type="hidden" name="form_id" value="submit" />
<div class="user-area">
<input type="submit" name="submit" value="Submit" class="submit-button" />
</div>
</li>
</ul>
</form>
</div>
</div>
</div>
<div class="registerinfobenefitsright">
</div>
</div>
<div class="aside">
</div>
