[ckdoublenecks]

I have this program where I select specific records to update (apt). When I select, all matching records are displayed. So far, so good. Trouble is when I update any of the matching records, all of them end up the same. How can I update just the one ?

PHP Code:

<?php
mysql_connect(localhost,root,"");
mysql_select_db(test) or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
 $apt = $_POST['apt'];
 $query="SELECT * FROM testtable Where apt='$apt'";
 $result=mysql_query($query);
 if(mysql_num_rows($result))
 {
  echo "<form action='#' method='post'><b>Maintenance Update Test :<br /><br />
         <table border='1'>
          <tr>
          <th>apt</th>
          <th>name</th>
          <th>date received</th>
          <th>symptom</th>
          <th>action</th>
          <th>date completed</th>
          </tr>";
  while($row = mysql_fetch_assoc($result))
  {
   echo "<tr>
          <td><input type='text' name='apt' value='" . $row['apt'] . "'></td>
          <td><input type='text' name='name' value='" . $row['name'] . "'></td>
          <td><input type='text' name='datereceived' value='" . $row['datereceived'] . "'></td>
          <td><input type='text' name='symptom' value='" . $row['symptom'] . "'></td>
          <td><input type='text' name='action' value='" . $row['action'] . "'></td>
          <td><input type='text' name='datecomplete' value='" . $row['datecomplete'] . "'></td>
         </tr>";
   }
echo "</table>
<input type='submit' name='update' value='Update Record' />
echo</form>";
}  
 else{echo "No listing for appartment $apt.<br />Please select another.<br />";}
}
if(!empty($_POST["update"]))
{
$sql = "UPDATE maintdata SET
 apt = '" . mysql_real_escape_string($_POST['apt']) . "',
 name = '" . mysql_real_escape_string($_POST['name']) . "',
 datereceived = '" . mysql_real_escape_string($_POST['datereceived']) . "',
 symptom = '" . mysql_real_escape_string($_POST['symptom']) . "',
 action = '" . mysql_real_escape_string($_POST['action']) . "',
 datecomplete = '" . mysql_real_escape_string($_POST['datecomplete']) . "'
WHERE apt='".$_POST["apt"]."'";
 mysql_query($sql) or die("Update query failed.");
 echo "Record for appartment ".$_POST["apt"]." has been updated";
 }
?>
<form method="post" action="#">
 <br />
 <input type="text" name="apt"/> <p>
<input type="submit" name="submit" value="select apartment"/>
</form>

[maneetpuri]

Hi,

I assume that you have a unique ID for each record, pass it as the parameter to the edit script and define it in the where clause of the Update SQL and it will just update that record.

Hope this helps.

Cheers,

~Maneet

[ckdoublenecks]

yeah I figured as much but I haven't quite got it yet. I changed it to the below and got this error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' on line 24. I don't see it? Can someone give me some guidance?

PHP Code:

<?php 
mysql_connect(localhost,root,""); 
mysql_select_db(test) or die( "Unable to select database"); 
if(!empty($_POST["submit"])) 
{ 
 $apt = $_POST['apt']; 
 $query="SELECT * FROM testtable Where apt='$apt'"; 
 $result=mysql_query($query); 
 if(mysql_num_rows($result)) 
 { 
  echo "<form action='#' method='post'><b>Maintenance Update Test :<br /><br /> 
         <table border='1'> 
          <tr> 
          <th>apt</th> 
          <th>name</th> 
          <th>date received</th> 
          <th>symptom</th> 
          <th>action</th> 
          <th>date completed</th> 
          </tr>"; 
  while($row = mysql_fetch_array($result)) 
  { 
   echo "<tr>
<td align="center">".$id[]=$row['id']  $row['id']; ?></td>
<td><input type='text' name='apt' value='" . $row['apt'] . "'></td> 
          <td><input type='text' name='name' value='" . $row['name'] . "'></td> 
          <td><input type='text' name='datereceived' value='" . $row['datereceived'] . "'></td> 
          <td><input type='text' name='symptom' value='" . $row['symptom'] . "'></td> 
          <td><input type='text' name='action' value='" . $row['action'] . "'></td> 
          <td><input type='text' name='datecomplete' value='" . $row['datecomplete'] . "'></td> 
         </tr>"; 
   } 
echo "</table> 
<input type='submit' name='update' value='Update Record' /> 
echo</form>"; 
}   
 else{echo "No listing for appartment $apt.<br />
Please select another.<br />";} 
} 
if(!empty($_POST["update"])) 
{ 
for($i=0;$i<$count;$i++){
$sql1="UPDATE testtable SET apt='$apt[$i]', name='$name[$i]', 'datereceived='$'datereceived[$i]', 'symptom='$'symptom[$i]', 'action='$'action[$i]', 'datecomplete='$'datecomplete[$i]' WHERE id='$id[$i]'";
$result1=mysql_query($sql1) or die("Update query failed."); 
 echo "Record for appartment ".$_POST["apt"]."  has been updated"; 
 } 
?> 
<form method="post" action="#"><br /> 
 <input type="text" name="apt"/> <p> 
<input type="submit" name="submit" value="select apartment"/> 
</form>

[maneetpuri]

Hi,

This parse error is because you have used “ in the echo replace them with ‘ and also I noticed the concatenation operator was missing too in the same line.

Cheers,

[ckdoublenecks]

I'm trying to learn this but having trouble understanding everyone's suggestions. Below is my latest attempt but I get an error at the statement that's commented in. I hope someone can offer guidance ?

PHP Code:

<?php 
mysql_connect(localhost,root,""); 
mysql_select_db(test) or die( "Unable to select database"); 
if(!empty($_POST["submit"])) 
{ 
$apt = $_POST['apt']; 
$query="SELECT * FROM testtable Where apt='$apt'"; 
$result=mysql_query($query); 
if(mysql_num_rows($result)) 
{ 
echo "<form action='#' method='post'><b>Maintenance Update Test :<br /><br /> 
<table border='1'> 
<tr> 
<th>apt</th> 
<th>name</th> 
<th>date received</th> 
<th>symptom</th> 
<th>action</th> 
<th>date completed</th> 
</tr>"; 
while($row = mysql_fetch_array($result)) 
{ 
echo "<tr>
// *******************************************************
<td align='center'>".$id[]=$row['id'] $row['id'];</td>
// ********************************************************
<td><input type='text' name='apt' value='" . $row['apt'] . "'></td> 
<td><input type='text' name='name' value='" . $row['name'] . "'></td> 
<td><input type='text' name='datereceived' value='" . $row['datereceived'] . "'></td> 
<td><input type='text' name='symptom' value='" . $row['symptom'] . "'></td> 
<td><input type='text' name='action' value='" . $row['action'] . "'></td> 
<td><input type='text' name='datecomplete' value='" . $row['datecomplete'] . "'></td> 
</tr>"; 
} 
echo "</table> 
<input type='submit' name='update' value='Update Record' /> 
echo</form>"; 
} 
else{echo "No listing for apartment $apt.<br />
Please select another.<br />";} 
} 
if(!empty($_POST["update"])) 
{ 
for($i=0;$i<$count;$i++){
$sql1="UPDATE testtable SET apt='$apt[$i]', name='$name[$i]', 'datereceived='$'datereceived[$i]', 
'symptom='$'symptom[$i]', 'action='$'action[$i]', 'datecomplete='$'datecomplete[$i]' WHERE id='$id[$i]'";
$result1=mysql_query($sql1) or die("Update query failed."); 
echo "Record for apartment ".$_POST["apt"]." has been updated"; 
} 
?> 
<form method="post" action="#"><br /> 
<input type="text" name="apt"/> <p> 
<input type="submit" name="submit" value="select apartment"/> 
</form>

[ckdoublenecks]

my latest attempt - I select the 'apt' but entering change for either of the 2 selected 'apt' records in the database doesn't update record. I have been trying, along with several others from several forums, to solve this problem but for every good suggestion I get the bad. Is anyone good enough at PHP to see the problem?

PHP Code:

<?php 
mysql_connect(localhost,root,"");
mysql_select_db(test) or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
 $apt = $_POST['apt'];
 $query="SELECT * FROM testtable Where apt='$apt'";
 $result=mysql_query($query);
 if(mysql_num_rows($result))
 {
  echo "<form action='#' method='post'><b>Maintenance Update Test :<br /><br />
         <table border='1'>
          <tr>
          <th>apt</th>
          <th>name</th>
          <th>date received</th>
          <th>symptom</th>
          <th>action</th>
          <th>date completed</th>
          </tr>";
 while($row = mysql_fetch_assoc($result))
  {
   echo "<tr>
          <td><input type='text' name='apt' value='" . $row['apt'] . "'></td>
          <input type='hidden' name='id' value='".$row['id']."'>
          <td><input type='text' name='name' value='" . $row['name'] . "'></td>
          <td><input type='text' name='datereceived' value='" .$row['datereceived'] . "'></td>
          <td><input type='text' name='symptom' value='" . $row['symptom'] . "'></td>
          <td><input type='text' name='action' value='" . $row['action'] . "'></td>
          <td><input type='text' name='datecomplete' value='" .$row['datecomplete'] . "'></td>
          <td><input type='submit' name='update' value='Update Record'></form></td>
         </tr>";
   }
echo "</table>";
}else{echo "No listing for apartment $apt.<br />Please select another.<br />";}
}
if(!empty($_POST["update"]))
{
$sql = "UPDATE maintdata SET
apt = '" .mysql_real_escape_string($_POST['apt']) . "',
name = '" .mysql_real_escape_string($_POST['name']) . "',
datereceived = '" .mysql_real_escape_string($_POST['datereceived']) . "',
symptom = '" .mysql_real_escape_string($_POST['symptom']) ."',
action = '" .mysql_real_escape_string($_POST['action']) . "',
datecomplete = '" .mysql_real_escape_string($_POST['datecomplete']) . "'
WHERE id='".$_POST["id"]."'";
 mysql_query($sql);
 echo "Record for apartment ".$_POST["apt"]." has been updated";
 }
?>
<form method="post" action="#"><br />
 <input type="text" name="apt"/> <p>
<input type="submit" name="submit" value="select apartment"/>
</form>