I know this might bee an “easy” question but i cant get it to work. I have a form that is in flash it then goes to our Mysql Database via php. I have display page to retrive the data. I need to put and update field for each of the records in that database how can this be done attached is my update code.
<input name="Zillow Estimate" type="text" value="<?php $query "INSERT INTO Invitation_Request (Zillow Eatimate) VALUES ( '$Zillow_Estimate' )" or die( mysql_error() );?>" />
and my page code
<script>
self.resizeTo(400,600);
</script>
<style type="text/css">
<!--
.style1 {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: bold;
color: #333333;
}
.style2 {
color: #990000;
font-size: 16px;
}
a:link {
color: #0000FF;
}
a:visited {
color: #0000FF;
}
a:hover {
color: #990000;
}
a:active {
color: #990000;
}
-->
</style>
<title>Display -Invitation Request</title>
<p class="style1 style2">Invitation Request (All) </p>
<p class="style1"><a href="xxx_Display_Invitation_Request_All.php">Refresh
<hr>
</a></p><?php
// Make a MySQL Connection
mysql_connect("expoships.com.phtemp.com", "xxxx", "xxxx") or die(mysql_error());
mysql_select_db("xxxx") or die(mysql_error());
// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM Invitation_Request ORDER BY ID_Number ASC" )
or die(mysql_error());
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
?>
<div id="width">
<div id="minwidth">
<div id="container">
<div id="banner">
<div id="logo"></div>
</div>
<div id="content" class="clearfix" accesskey="2">
<div id="home">
<form action="http://www.Zillow.com/Home,$search$SearchBar.formSearchBar.sdirect" method="post"" name="formSearchBar" target="_blank" id="formSearchBar","blank>
<div style="display:none;">
<input type="hidden" name="formids" value="inputAddrStrtHood,If,inputCityStateZip,If_0,If_1,If_2,If_3,applySearchFilter"/>
<input type="hidden" name="submitmode" value=""/>
<input type="hidden" name="submitname" value=""/>
<input type="hidden" name="If" value="F"/>
<input type="hidden" name="If_0" value="F"/>
<input type="hidden" name="If_1" value="T"/>
<input type="hidden" name="If_2" value="T"/>
<input type="hidden" name="If_3" value="F"/>
<input type="hidden" name="applySearchFilter" id="applySearchFilter" value="F"/>
</div>
<div id="inlinesearch">
<fieldset id="basic">
<legend>Value of <?php echo "<B> Home ID: </B>", $row['ID_Number'];?></legend>
<div class="first">
<label for="inputAddrStrtHood"><span><strong><br />
Address</strong> OR <strong>Street</strong> OR <strong>Neighborhood</strong></span></label>
<br />
<input type="text" name="inputAddrStrtHood" value="<?php echo $row['Address']; ?>" id="inputAddrStrtHood" tabindex="1" maxlength="100" accesskey="4"/>
<br />
</div>
<div>
<label for="inputCityStateZip"><span><strong><br />
City, State</strong> OR <strong>ZIP<br />
<input type="text" name="inputCityStateZip" value="<?php echo $row['Zip']; ?>" id="inputCityStateZip" tabindex="2" maxlength="100"/>
<br />
<br />
<input name="image" type="image" class="go" tabindex="3" src="http://www.zillow.com/static/images/btn_go.gif" alt="Go"/>
<br />
</strong></span></label>
<hr />
<p>
<input name="Zillow Estimate" type="text" value="<?php $query "INSERT INTO Invitation_Request (Zillow Eatimate) VALUES ( '$Zillow_Estimate' )" or die( mysql_error() );?>" />
</p>
<p>
<input name="Save" type="submit" id="Save" value="Save" />
</p><hr />
</div>
</fieldset>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
// Print out the contents of each row into a table
echo "<B>ID: </B>", $row['ID_Number'];
echo "<br>
";
echo "<B>Type: </B>", $row['Type'];
echo "<br>
";
echo "<B>First Name: </B>", $row['First_Name'];
echo "<br>
";
echo "<B>Last Name: </B>", $row['Last_Name'];
echo "<br>
";
echo "<B>Company: </B>", $row['Company'];
echo "<br>
";
echo "<B>Address: </B>", $row['Address'];
echo "<br>
";
echo "<B>City: </B>", $row['City'];
echo "<br>
";
echo "<B>State: </B>", $row['State'];
echo "<br>
";
echo "<B>Zip: </B>", $row['Zip'];
echo "<br>
";
echo "<B>Country: </B>", $row['Country'];
echo "<br>
";
echo "<B>Phone: </B>", $row['Phone'];
echo "<br>
";
echo "<B>E-Mail: </B>", $row['Email'];
echo "<br>
";
echo "<B>Ports of Interest: </B>", $row['Ports_of_Interest'];
echo "<br>
";
echo "<B>Collector Level: </B>", $row['Collector_Level'];
echo "<br>
";
echo "<B>Collector Type: </B>", $row['Collector_Type'];
echo "<br>
";
echo "<B>Designer Specialty: </B>", $row['Designer_Specialty'];
echo "<br>
";
echo "<B>Designer Preferences: </B>", $row['Designer_Preferences'];
echo "<br>
";
echo "<B>Designer Visit with Client: </B>", $row['Designer_Visit_with_Client'];
echo "<br>
";
echo "<B>Designer Preview: </B>", $row['Designer_Preview'];
echo "<br>
";
echo "<B>Designer Name to Dealers: </B>", $row['Designer_Name_to_Dealers'];
echo "<br>
";
echo "<B>Consultant Specialty: </B>", $row['Consultant_Specialty'];
echo "<br>
";
echo "<B>Consultant Type: </B>", $row['Consultant_Type'];
echo "<br>
";
echo "<B>Dealer Type: </B>", $row['Dealer_Type'];
echo "<br>
";
echo "<B>Dealer Fairs: </B>", $row['Dealer_Fairs'];
echo "<br>
";
echo "<B>Dealer Which Ones: </B>", $row['Dealer_Other'];
echo "<br>
";
echo "<B>Curator Title: </B>", $row['Curator_Title'];
echo "<br>
";
echo "<B>Press Title: </B>", $row['Press_Title'];
echo "<br>
";
echo "<B>Press Media Type: </B>", $row['Press_Media_Type'];
echo "<br>
";
echo "<B>Gallery Specialty: </B>", $row['Gallery_Specialty'];
echo "<br>
";
echo "<B>Gallery Handle: </B>", $row['Gallery_Handle'];
echo "<br>
";
echo "<B>Gallery Fairs: </B>", $row['Gallery_Fairs'];
echo "<br>
";
echo "<B>Gallery Which Ones: </B>", $row['Gallery_Other'];
echo "<br>
";
echo "<B>Artist Affiliation: </B>", $row['Artist_Affiliation'];
echo "<br>
";
echo "<B>Villow Estimate: </B>", $row['Zillow_Estimate'];
echo "<br>
";
echo "<B>Date: </B>", $row['Date'];
echo "<br><hr>
";
}
echo "</table>";
?>
<p class="style1"> </p>
<p class="style1"> </p>
<p>
</p>
