I have a page that updates my database from a web form here is my code for the page:
[CODE]
<?
session_start();
include_once”config.php”;
if(!isset($_SESSION[‘username’]) || !isset($_SESSION[‘password’])){
header(“Location: login.php”);
}
else{
$fetch_users_data = mysql_fetch_object(mysql_query(“SELECT * FROM `members` WHERE username='”.$_SESSION[‘username’].”‘”));
}
?>
<html>
<head>
<title>Edit Member Account</title>
</head>
<body>
<?php
$name = $_POST[‘Business_Name’];
$address = $_POST[‘Business_Address’];
$city= trim($_POST[‘city’]);
$state= trim($_GET[‘state’]);
$zip= trim($_POST[‘zip’]);
$phone = $_POST[‘Phone’];
$fax = $_POST[‘Fax’];
$website = $_POST[‘website’];
$keywords = $_POST[‘Keywords’];
$user = $_SESSION[‘username’];
//Udates Information in the Database
$rc = mysql_affected_rows();
if ($name > ” && $address > ” && $phone > ”){
mysql_query(“UPDATE Chamber_Members SET Business_Name = ‘$name’, Business_Address = ‘$address’, City = ‘$city’, State = ‘$state’, Zip = ‘$zip’, Business_Phone = ‘$phone’, Business_Fax = ‘$fax’, Website = ‘$website’, Key_Words = ‘$keywords’ WHERE Username = ‘$user'”);}
if (mysql_query==false){
echo “Your Account Has Been Updated”;
}
else
{
echo “Your Account was not updated!”;
}
//Fills the form from the database
$query = (“select * FROM Chamber_Members WHERE Username=’$user'”);
$result=mysql_query($query) or die (‘Error: ‘.mysql_error ());
while($row = mysql_fetch_array($result))
{
//Displays current Information
$output .= “<h1>” . $row[‘Business_Name’] . “</h1>” . “<br />”;
$output .= $row[‘Business_Address’] . “<br />”;
$output .= $row[‘City’] . “,” . $row[‘State’] . “<br />”;
$output .= $row[‘Zip’] . “<br>”;
$output .= “Phone: ” . $row[‘Business_Phone’] . “<br />”;
$output .= “Fax: ” . $row[‘Business_Fax’] . “<br />”;
echo $output;
echo “<a href=” . trim($row[‘Website’]) . “” . “> ” . $row[‘Website’] . “</a>”;
}
?>
<form name=”form1″ method=”post” action=”<?php echo $_SERVER[‘PHP_SELF’];?>”>
<div align=”left”><a>Welcome, You are logged in as <? echo ” “.$fetch_users_data->username.” “;?>, Click here if this is not you or to </a><a href=”logout.php”>Logout</a></div>
<div align=”right”>
<? $result = mysql_query( “select * FROM Chamber_Members WHERE Username=’$user'” );
while( $row = mysql_fetch_array( $result ) ) {
?>
<label>
<div align=”justify”><br>
Business Name:
<input name=”Business_Name” type=”text” id=”Business_Name” value=”<?php echo $row[‘Business_Name’];?>” tabindex=”1″ size=”40″>
</div>
</label>
<p align=”justify”>
<label>Address:
<input type=”text” name=”Address” id=”Address” value=”<?php echo $row[‘Business_Address’];?>”>
</label>
</p>
<p align=”justify”>
<label>City:
<input type=”text” name=”City” id=”City” value=”<?php echo $row[‘City’];?>”>
</label>
<label>State:
<select name=”State” size=”1″ id=”state”>
<option selected> <?php echo $row[‘State’];?> </option>
<option value “AL” > AL</option>
<option value “AK” > AK</option>
<option value “AZ” > AZ</option>
<option value “AR” > AR</option>
<option value “CA” > CA</option>
<option value “CO” > CO</option>
<option value “CT” > CT</option>
<option value “DE” > DE</option>
<option value “DC” > DC</option>
<option value “FL” > FL</option>
<option value “GA” > GA</option>
<option value “HI” > HI</option>
<option value “ID” > ID</option>
<option value “IL” > IL</option>
<option value “IN” > IN</option>
<option value “IA” > IA</option>
<option value “KS” > KS</option>
<option value “KY” > KY</option>
<option value “LA” > LA</option>
<option value “ME” > ME</option>
<option value “MD” > MD</option>
<option value “MA” > MA</option>
<option value “MI” > MI</option>
<option value “MN” > MN</option>
<option value “MS” > MS</option>
<option value “MO” > MO</option>
<option value “MT” > MT</option>
<option value “NE” > NE</option>
<option value “NV” > NV</option>
<option value “NH” > NH</option>
<option value “NJ” > NJ</option>
<option value “NM” > NM</option>
<option value “NY” > NY</option>
<option value “NC” > NC</option>
<option value “ND” > ND</option>
<option value “OH” > OH</option>
<option value “OK” > OK</option>
<option value “OR” > OR</option>
<option value “PA” > PA</option>
<option value “RI” > RI</option>
<option value “SC” > SC</option>
<option value “SD” > SD</option>
<option value “TN” > TN</option>
<option value “TX” > TX</option>
<option value “UT” > UT</option>
<option value “VT” > VT</option>
<option value “VI” > VI</option>
<option value “VA” > VA</option>
<option value “WA” > WA</option>
<option value “WV” > WV</option>
<option value “WI” > WI</option>
<option value “WY” > WY</option>
</select>
</label>
</p>
<p align=”justify”>
<label>Zip: </label>
<input type=”text” name=”Zip” id=”Zip” value=”<?php echo $row[‘Zip’];?>”>
</p>
<p align=”justify”>
<label>Phone:
<input name=”Phone” type=”text” id=”Phone” value=”<?php echo $row[‘Business_Phone’];?>” tabindex=”3″ size=”13″ maxlength=”13″>
</label><label>Fax:
<input name=”Fax” type=”text” id=”Fax” value=”<?php echo $row[‘Business_Fax’];?>”tabindex=”4″ size=”13″ maxlength=”13″>
</label>
</p>
<p align=”justify”>
<label>Website:
<input name=”website” type=”text” id=”website” value=”<?php echo $row[‘Website’];?>”tabindex=”5″ size=”50″>
</label>
</p>
<p align=”justify”>
<label>Keywords:
<textarea name=”Keywords” id=”Keywords” cols=”45″ rows=”5″ tabindex=”6″ wrap=”physical”><?php echo $row[‘Key_Words’];?> </textarea>
</label>
</p>
<p align=”justify”>
<label>
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<p>
<input type=”submit” name=”Submit” id=”Submit” value=”Submit” tabindex=”7″>
</p>
</blockquote>
</blockquote>
</blockquote>
</form>
<?php
}
?>
</body>
</html>
The problem is when I added the city, state, and zip, it no longer will update my db my guess is I am not getting the state information from the listbox correctly. can anyone help me troubleshoot this?