can someone tell me why this isnt updating?
<?php
if (($REQUEST_METHOD=='POST')) {
// remove tags
for(reset($HTTP_POST_VARS);
$key=key($HTTP_POST_VARS);
next($HTTP_POST_VARS))
{$this = addslashes($HTTP_POST_VARS[$key]);
$this = strtr($this, ">", " ");
$this = strtr($this, "<", " ");
$this = strtr($this, "|", " ");
$$key = $this;}
if ( name ) {
// query start
$query = "UPDATE `app_riders` WHERE `rider_id` = '$rider_id' SET `fname` = '$fname', `name` = '$name', `side` = '$side', `first` = '$first', `last` = '$last', `age` = '$age', `city` = '$city', `state` = '$state', `bike` = '$bike', `email` = '$email', `aim` = '$aim', `comments` = '$comments'";
mysql_pconnect("mysql.geocities.com","vsehldm","terrible")or die("Unable to connect to SQL server");
mysql_select_db("site") or die("Unable to select database");mysql_query($query) or die("Fuck somethings broken! email me <a href=\"mailto:scbmx@hotmail.com\">here</a> and tell me!");
} else {
$notall = 1;}}?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD></HEAD>
<BODY text=#777777 link=#FFFFFF bgColor=#FDFDFD><font face="verdana" size="1">
<?php
if ($notall == 1) {
?>
<P><font color="red">you missed a field</font></P>
<?php
}
?>
</font>
<?php
$query = "SELECT * FROM app_riders WHERE rider_id='$rider_id'";
mysql_pconnect("localhost","myusername","mypass")or die("Unable to connect to SQL server");
mysql_select_db("site") or die("Unable to select database");mysql_query($query) or die("Fuck somethings broken! email me <a href=\"mailto:scbmx@hotmail.com\">here</a> and tell me!");
$guests = mysql_query($query) or die("Select Failed!");
while ($guest = mysql_fetch_array($guests)) {
?>
<FORM METHOD="post" ACTION="editrider.php?rider_id=<?php echo $rider_id ?>"><input type="hidden" name="rider_id" value="<?php echo $rider_id?>"><input type="text" name="name" size="20" maxlength="50" value="<?php echo $name; ?><?php echo $guest['name']; ?>"> </font></font></td> </tr> <tr> <td class="windowbg2" bgcolor="#F8F8F8" width="54%" ><font face="verdana" size="1">name(without capsor spaces):</font></td> <td class="windowbg2" bgcolor="#F8F8F8" width="54%" ><font face="verdana" size="1"> <input type="text" name="fname" size="20" maxlength="50" value="<?php echo $fname; ?><?php echo $guest['fname']; ?>"> </font></td> </tr> <tr> <td class="windowbg2" bgcolor="#F8F8F8" width="54%" ><font face="verdana" size="1">side:</font></td> <td class="windowbg2" bgcolor="#F8F8F8" width="54%" ><font face="verdana" size="1"><select name="side" value="<?php echo $side; ?>"> <option value="1" selected name="1">left</option> <option value="2" name="2">right</option></select>
<input type="text" name="first" size="20" maxlength="50" value="<?php echo $first; ?><?php echo $guest['first']; ?>">
<input type="text" name="last" size="20" maxlength="50" value="<?php echo $last; ?><?php echo $guest['last']; ?>">
<input type="text" name="age" size="20" maxlength="50" value="<?php echo $age; ?><?php echo $guest['age']; ?>">
<input type="text" name="city" size="20" maxlength="50" value="<?php echo $city; ?><?php echo $guest['city']; ?>">
<input type="text" name="state" size="20" maxlength="50" value="<?php echo $state; ?><?php echo $guest['state']; ?>">
<input type="text" name="bike" size="20" maxlength="50" value="<?php echo $bike; ?><?php echo $guest['bike']; ?>">
<input type="text" name="email" size="20" maxlength="50" value="<?php echo $email; ?><?php echo $guest['email']; ?>">
<input type="text" name="aim" size="20" maxlength="50" value="<?php echo $aim; ?><?php echo $guest['aim']; ?>">
<input type="text" name="comments" size="20" maxlength="50" value="<?php echo $comments; ?><?php echo $guest['comments']; ?>"><INPUT TYPE="submit" VALUE="Add"></FORM></body></html>
<?php
}
?>
thanks
