Page 1 of 1

Updating mysql database with input fields

Posted: Fri May 08, 2009 3:08 pm
by tomsace
Hi,
I can't get this to work, I have been trying to update my mysql database by using the values entered in the input fields on the page. Also I have made it to receive the current data in the mysql database to automatically show in the input fields so I don't have to totally fill out the form if I ever need to edit a field.
I have come up with this but I keep getting the error 'Error: Query was empty'.
Can anyone help me out please?

Code: Select all

<?php include("header.php"); ?>
 
 
<?php
if (isset($_REQUEST['Submit'])) {
$result = mysql_query("UPDATE $db_table(idname, title, description, instructions, certification, author, authorwebsite, width, height, day, month, year, category, hits, gotw)
VALUES ('$_POST[idname]', '$_POST[title]', '$_POST[description]', '$_POST[instructions]', '$_POST[certification]', '$_POST[author]', '$_POST[authorwebsite]', '$_POST[width]', '$_POST[height]', '$_POST[day]', '$_POST[month]', '$_POST[year]', '$_POST[category]', '$_POST[hits]', '$_POST[gotw]')");
if($result = mysql_query($result ,$db)) {
echo '<center><h1>Thank you</h1>Your information has been updated';
} else {
echo "ERROR: ".mysql_error();
}}
else {
?>
<?php
$id=mysql_real_escape_string($_GET['id']);
// Performing SQL query
$query = ("SELECT * FROM games WHERE id = '$id'") or die(mysql_error()); 
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
 
// Printing results in HTML
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { ?>
 
<?php include("../templates/redtop.txt"); ?>
 
<h1><?php echo"$line[title]" ?></h1><center>
 
<form method="post" action="">
<table cellpadding="3" cellspacing="1" border="0" background="/images/space.gif"><tr><td>
ID Name:</td><td>
<input type="text" name="idname" class="input" size="29" value="<?php echo($line['idname']); ?>">
</td></tr><tr><td valign="top">
Title:</td><td>
<input type="text" name="title" class="input" size="29" value="<?php echo($line['title']); ?>">
</td></tr><tr><td valign="top">
Description: </td><td>
<textarea type="text" name="description" class="input" cols="22"><?php echo($line['description']); ?></textarea>
</td></tr><tr><td valign="top">
Instructions:</td><td>
<textarea type="text" name="instructions" class="input" cols="22"><?php echo($line['instructions']); ?></textarea>
</td></tr><tr><td valign="top">
Width:</td><td>
<input type="text" name="width" class="input" style="width:50px;" value="<?php echo($line['width']); ?>">
</td></tr><tr><td valign="top">
Height:</td><td>
<input type="text" name="height" class="input" style="width:50px;" value="<?php echo($line['height']); ?>">
</td></tr><tr><td valign="top">
Author:</td><td>
<input type="text" name="author" class="input" size="29" value="<?php echo($line['author']); ?>">
</td></tr><tr><td valign="top">
Author Website:</td><td>
<input type="text" name="author" class="input" size="29" value="<?php echo($line['authorwebsite']); ?>">
</td></tr><tr><td>
Certification:</td><td>
<select name="certification" class="input" style="width: 115px;"  value="<?php echo($line['certification']); ?>">
<option value="All Audiences" <?php if($line['certification'] == "All Audiences") print "selected"; ?>>All Audiences</option>
<option value="Mature Audiences" <?php if($line['certification'] == "Mature Audiences") print "selected"; ?>>Mature Audiences</option>
</select>
</td></tr><tr><td>
Category:</td><td>
<select name="category" class="input" style="width: 172px;">
<option value="action" <?php if($line['category'] == "action") print "selected"; ?>>Action</option>
<option value="adventure" <?php if($line['category'] == "adventure") print "selected"; ?>>Adventure</option>
<option value="puzzle" <?php if($line['category'] == "puzzle") print "selected"; ?>>Puzzle</option>
<option value="shooting" <?php if($line['category'] == "shooting") print "selected"; ?>>Shooting</option>
<option value="role playing" <?php if($line['category'] == "role playing") print "selected"; ?>>Role Playing</option>
<option value="sports" <?php if($line['category'] == "sports") print "selected"; ?>>Sports</option>
<option value="retro" <?php if($line['category'] == "retro") print "selected"; ?>>Retro</option>
<option value="fighting" <?php if($line['category'] == "fighting") print "selected"; ?>>Fighting</option>
<option value="racing" <?php if($line['category'] == "racing") print "selected"; ?>>Racing</option>
</select>
</td></tr><tr><td>
Date:</td><td>
<select name="day" class="input" style="width: 40px;">
<option value="1" <?php if($line['day'] == "1") print "selected"; ?>>1</option>
<option value="2" <?php if($line['day'] == "2") print "selected"; ?>>2</option>
<option value="3" <?php if($line['day'] == "3") print "selected"; ?>>3</option>
<option value="4" <?php if($line['day'] == "4") print "selected"; ?>>4</option>
<option value="5" <?php if($line['day'] == "5") print "selected"; ?>>5</option>
<option value="6" <?php if($line['day'] == "6") print "selected"; ?>>6</option>
<option value="7" <?php if($line['day'] == "7") print "selected"; ?>>7</option>
<option value="8" <?php if($line['day'] == "8") print "selected"; ?>>8</option>
<option value="9" <?php if($line['day'] == "9") print "selected"; ?>>9</option>
<option value="10" <?php if($line['day'] == "10") print "selected"; ?>>10</option>
<option value="11" <?php if($line['day'] == "11") print "selected"; ?>>11</option>
<option value="12" <?php if($line['day'] == "12") print "selected"; ?>>12</option>
<option value="13" <?php if($line['day'] == "13") print "selected"; ?>>13</option>
<option value="14" <?php if($line['day'] == "14") print "selected"; ?>>14</option>
<option value="15" <?php if($line['day'] == "15") print "selected"; ?>>15</option>
<option value="16" <?php if($line['day'] == "16") print "selected"; ?>>16</option>
<option value="17" <?php if($line['day'] == "17") print "selected"; ?>>17</option>
<option value="18" <?php if($line['day'] == "18") print "selected"; ?>>18</option>
<option value="19" <?php if($line['day'] == "19") print "selected"; ?>>19</option>
<option value="20" <?php if($line['day'] == "20") print "selected"; ?>>20</option>
<option value="21" <?php if($line['day'] == "21") print "selected"; ?>>21</option>
<option value="22" <?php if($line['day'] == "22") print "selected"; ?>>22</option>
<option value="23" <?php if($line['day'] == "23") print "selected"; ?>>23</option>
<option value="24" <?php if($line['day'] == "24") print "selected"; ?>>24</option>
<option value="25" <?php if($line['day'] == "25") print "selected"; ?>>25</option>
<option value="26" <?php if($line['day'] == "26") print "selected"; ?>>26</option>
<option value="27" <?php if($line['day'] == "27") print "selected"; ?>>27</option>
<option value="28" <?php if($line['day'] == "28") print "selected"; ?>>28</option>
<option value="29" <?php if($line['day'] == "29") print "selected"; ?>>29</option>
<option value="30" <?php if($line['day'] == "30") print "selected"; ?>>30</option>
<option value="31" <?php if($line['day'] == "31") print "selected"; ?>>31</option>
</select>
 
<select name="month" class="input" style="width: 76px;">
<option value="January" <?php if($line['month'] == "January") print "selected"; ?>>January</option>
<option value="February" <?php if($line['month'] == "February") print "selected"; ?>>February</option>
<option value="March" <?php if($line['month'] == "March") print "selected"; ?>>March</option>
<option value="April" <?php if($line['month'] == "April") print "selected"; ?>>April</option>
<option value="May" <?php if($line['month'] == "May") print "selected"; ?>>May</option>
<option value="June" <?php if($line['month'] == "June") print "selected"; ?>>June</option>
<option value="July" <?php if($line['month'] == "July") print "selected"; ?>>July</option>
<option value="August" <?php if($line['month'] == "August") print "selected"; ?>>August</option>
<option value="September" <?php if($line['month'] == "September") print "selected"; ?>>September</option>
<option value="October" <?php if($line['month'] == "October") print "selected"; ?>>October</option>
<option value="November" <?php if($line['month'] == "November") print "selected"; ?>>November</option>
<option value="December" <?php if($line['month'] == "December") print "selected"; ?>>December</option>
</select>
 
<select name="year" class="input" style="width: 50px;">
 
<option value="2009" <?php if($line['year'] == "2009") print "selected"; ?>>2009</option>
<option value="2010" <?php if($line['year'] == "2010") print "selected"; ?>>2010</option>
</select>
</td></tr><tr><td valign="top">
Hits:</td><td>
<input type="text" name="hits" class="input" style="width:55px;" value="<?php echo($line['hits']); ?>">
</td></tr><tr><td valign="top">
Game Of The Week:</td><td>
<input type="text" name="gotw" class="input" style="width:55px;" value="<?php echo($line['gotw']); ?>">
</td></tr><tr><td colspan="2" align="center">
 
<input type="image" src="/images/btn_send2.jpg" name="Submit" value="Submit">
</td></tr></table>
 
<?php include("../templates/redbot.txt"); ?>
 
<?php
}}
?>

Re: Updating mysql database with input fields

Posted: Fri May 08, 2009 4:04 pm
by infolock
it's because you're trying to execute a mysql_query on $result on the if($result = mysql_query($result)


This will never work as it's just a Resource ID..