Update single record updates all records

Hi,

I am hoping someone can spot where i am slipping up.
I am pulling my hair out with this one and no doubt it will be a simple error that for the life of me I cannot pinpoint

I have code that is meant to update a single record. The update page and form gets the record id from the url and although everything is being populated correctly, when I make any changes and hit "Submit" then ALL the records are changed. This despite the fact that I have echoed the id and it displays the correct id is being captured correctly. Have found some otehr items on the MySql forums but they all point ot a misshed "Where" in the update statement No so with my code and now am stumped.. Hope someone can help here..

My Code

<?php
 include '../dbfunctions.php';
 
 session_start();
 
 $link = dbConnect();

 checkVenueLogin();
 
 $rateid = $_GET['id'];
 echo $rateid;
 $rates = dbGetRows("rates", "id = '".$rateid."'");
 $rate = mysql_fetch_array($rates, MYSQL_ASSOC);
 
 $venues = dbGetRows("venues", "id = '".$_SESSION['venueid']."'");
 $venue = mysql_fetch_array($venues, MYSQL_ASSOC);
 if( isset($_POST['Submit']) ) {

 $query = "UPDATE rates SET `datefrom` = '".$_POST['datefrom']."', `dateto` = '".$_POST['dateto']."', `ratename` = '".$_POST['ratename']."', `single` = '".$_POST['single']."', `double` = '".$_POST['double']."', `child` = '".$_POST['child']."', `infant` = '".$_POST['infant']."', `base` = '".$_POST['base']."' WHERE '".$rate['id']."' = '".$rateid."'"; 
 var_dump($query); 
 $result = mysql_query($query) or die( "Error: " . mysql_error() );
 } 
 
 
 
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Modify Rate NO. <?PHP echo $rateid; ?></title>
<link href="../bb.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFF4DC"
<?php if(isset($_POST['Submit']) && $result) echo "onLoad=\"window.close(); opener.location.reload(true);\""; ?>>


<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
 <tr> 
 <td width="32"><img src="images/admin_03.gif"></td>
 <td width="0*" bgcolor="#FFFFFF" background="images/admin_04.gif" style="background-repeat: repeat-x;">&nbsp;</td>
 <td width="35"><img src="images/admin_07.gif" width="32" height="33"></td>
 </tr>
 <tr> 
 <td bgcolor="#FFFFFF" background="images/admin_15.gif" style="background-repeat: repeat-y;"></td>
 <td bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0" cellpadding="0" style="margin-left: 10px; margin-right: 10px;">
  <tr> 
   <td>
   <font size="3"><b><?php echo $venue['venuename']; ?> - MODIFY RATE</b></font><br>
   <br> 
   
   <form name="form1" method="post" action="editrates.php">
    <table width="449" border="0" cellspacing="0" cellpadding="2">
    <tr> 
    
     <td width="104"><b>Rate Name</b></td>
     <td width="235" valign="top"><input type="text" name="ratename" value="<?php echo $rate['ratename']; ?>"> 
         </td>
    </tr>
    <tr> 
     <td valign="top">&nbsp;</td>
     <td valign="top">&nbsp;</td>
    </tr>
    <tr>
     <td><strong>From Date</strong></td>
     <td><input type="text" name="datefrom" id="datefrom" size="10" readonly="true" value="<?php echo $rate['datefrom']; ?>"> 
    &nbsp;<img src="images/calendar01.gif" class="mxw_cld" onClick="return showCalendar('datefrom', 'yyyy-mm-dd', 'false');" style="cursor:pointer;"></td>
    </tr>
    <tr>
     <td><strong>To Date</strong></td>
     <td><input type="text" name="dateto" id="dateto" size="10" readonly="true" value="<?php echo $rate['dateto']; ?>"> 
    &nbsp; <img src="images/calendar01.gif" class="mxw_cld" onClick="return showCalendar('dateto', 'yyyy-mm-dd', 'false');" style="cursor:pointer;"></td>
    </tr>
    <tr> 
     <td>&nbsp;</td>
     <td>&nbsp;</td>
    </tr>
    <tr> 
     <td><b> Adults - Single</b></td>
     <td><label>
     <input type="text" name="single" value="<?php echo $rate['single']; ?>">
     </label></td>
    </tr>
    <tr> 
     <td><strong>Adults - Double</strong></td>
     <td><label>
     <input type="text" name="double" value="<?php echo $rate['double']; ?>">
     </label></td>
    </tr>
    <tr> 
     <td><strong>Child</strong></td>
     <td><label>
     <input type="text" name="child" value="<?php echo $rate['child']; ?>">
     </label></td>
    </tr>
    <tr> 
     <td><b>Infant</b></td>
     <td><label>
     <input type="text" name="infant" value="<?php echo $rate['infant']; ?>">
     </label></td>
    </tr>
    
     <td><strong>Base Rate</strong></td>
     <td><label></label>
     <label>
     <input type="text" name="base" value="<?php echo $rate['base']; ?>">
     </label></td>
    </tr>
    <tr> 
     <td colspan="2"><input type="Submit" name="Submit" value="Submit">
     .
     <input type="button" name="Cancel" value="Close Window" onClick="window.close();"></td>
    </tr>
    </table>
   </form>
  </table></td>
 <td bgcolor="#FFFFFF" align="right" background="images/admin_14.gif" style="background-position: right; background-repeat: repeat-y;"></td>
 </tr>
 <tr> 
 <td><img src="images/admin_21.gif" width="32" height="33"></td>
 <td bgcolor="#FFFFFF" background="images/admin_23.gif" style="background-position: bottom; background-repeat: repeat-x;"></td>
 <td><img src="images/admin_20.gif" width="32" height="33"></td>
 </tr>
</table>

</body>
</html>

Update single record updates all records

garwil

rocknbil

brotherhood of LAN

garwil

brotherhood of LAN

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week