SQL data not passing to Form

Rwap

Hi,

I am making a address list that can add edit delete and print labels

i have the add and view part of it done and im working on the edit part.

The problem is Mysql isn't passing the data to the Form Fields right..

There are no errors

This is the code:

<?php
require('header.php');
$self = $_SERVER['PHP_SELF'];
$submit_1 = $_POST["submit_1"];
$submit_2 = $_POST["submit_2"];
$edit = $_POST['edit'];

$sql = "select * from address_list order by first_name desc";
$rs = $DB->Query( $sql ) or die(mysql_error());

echo '
<form action="'.$self.'"method="post">
<select size="1" name="edit">
	<option>Select One</option>';
while ($row_select =  $DB->FetchAssoc( $rs ) )
{
	echo '<option>'.$row_select["first_name"].' '.$row_select["last_name"].'</option>';
}
echo '
</select>
<input type="submit" value="Edit!" name="submit_1">
</form>';


//START OF FORM THAT ISNT WORKING RIGHT//

if($submit_1)
{
   $sql_edit = "select * from address_list where first_name='".$edit."'";
   $rs_edit = $DB->Query($sql_edit);
   $row =  $DB->FetchAssoc( $rs_edit );
  echo'
  <form action="'.$self.'" method="post">
First Name: <input type="text" name="first_name" size= "20" value="'.$row["first_name"].'">
<BR>
Middle Name: <input type="text" name="middle_name" size= "20" value="'.$row["middle_name"].'">
<br>
Last Name: <input type="text" name="last_name" size= "20" value="'.$row["last_name"].'">
<br>
Home Phone Number:<input type="text" name="area_code" size= "3" value="'.$row["area_code"].'">-
<input type="text" name="number_1" size= "3" value="'.$row["number_1"].'">-
<input type="text" name="number_2" size= "4" value="'.$row["number_2"].'">
<br>
Cell Phone Number:<input type="text" name="area_code_cell" size= "3" value="'.$row["area_code_cell"].'">-
<input type="text" name="number_1_cell" size= "3" value="'.$row["number_1_cell"].'">-
<input type="text" name="number_2_cell" size= "4" value="'.$row["number_2_cell"].'">
<BR>
Email Address: <input type="text" name="email" size= "30" value="'.$row["email"].'">
<br>
Street Address: <input type="text" name="street" size= "30" value="'.$row["street"].'">
<br>
City: <input type="text" name="city" size= "30" value="'.$row["city"].'">
<br>
State: <input type="text" name="state" size= "30" value="'.$row["state"].'">
<br>
Zip Code: <input type="text" name="zip" size= "30" value="'.$row["zip"].'">
<br>
Notes:
<textarea rows="10" name="notes" value="'.$row["notes"].'" cols="30"></textarea>
<br>
<input type="submit" name="submit_2" value= "Edit!">
</form>';
}
//END OF FORM//

require('footer.php');
?>

Help would be appreciated.

Thanks

bodzan

I might be wrong but it seems to me that your page doesn't get anything as a result after selecting a value in the first drop down. And the reason for it is because there is not one!
This part:

echo '<option>'.$row_select["first_name"].' '.$row_select["last_name"].'</option>';

should be like:

echo '<option value ='.$row_select["first_name"].'>'.$row_select["first_name"].' '.$row_select["last_name"].'</option>';

so that every option would send it's value to the second form because, if I'm not mistaken - you get no value for $edit like this.

Rwap

Just to let you know that was the error.

But because this is an address book and there may be several entries for 1 person i decided to re code it a bit..

Thanks for the help.. ill have to watch for stupid stuff like that..

Rwap

i am not getting a error but the form data isn't updating mysql..

this is the code..

<?php
require('header.php');
extract($_POST, EXTR_SKIP); 
$self = $_SERVER['PHP_SELF'];
$id = $_GET['id'];
$submit_1 = $_POST["submit_1"];
$edit = $_POST['edit'];

   $sql_edit = "select * from address_list where id='".$id."'";
   $rs_edit = $DB->Query($sql_edit);
   $row =  $DB->FetchAssoc( $rs_edit );
//START OF FORM
  echo'
  <form action="'.$self.'" method="post">
First Name: <input type="text" name="first_name" size= "20" value="'.$row["first_name"].'">
<BR>
Middle Name: <input type="text" name="middle_name" size= "20" value="'.$row["middle_name"].'">
<br>
Last Name: <input type="text" name="last_name" size= "20" value="'.$row["last_name"].'">
<br>
Home Phone Number:<input type="text" name="area_code" size= "3" value="'.$row["area_code"].'">-
<input type="text" name="number_1" size= "3" value="'.$row["number_1"].'">-
<input type="text" name="number_2" size= "4" value="'.$row["number_2"].'">
<br>
Cell Phone Number:<input type="text" name="area_code_cell" size= "3" value="'.$row["area_code_cell"].'">-
<input type="text" name="number_1_cell" size= "3" value="'.$row["number_1_cell"].'">-
<input type="text" name="number_2_cell" size= "4" value="'.$row["number_2_cell"].'">
<BR>
Email Address: <input type="text" name="email" size= "30" value="'.$row["email"].'">
<br>
Street Address: <input type="text" name="street" size= "30" value="'.$row["street"].'">
<br>
City: <input type="text" name="city" size= "30" value="'.$row["city"].'">
<br>
State: <input type="text" name="state" size= "30" value="'.$row["state"].'">
<br>
Zip Code: <input type="text" name="zip" size= "30" value="'.$row["zip"].'">
<br>
Notes:
<textarea rows="10" name="notes" cols="30">'.$row["notes"].'</textarea>
<br>
<input type="submit" name="submit_1" value= "Edit!">
</form>';
//END OF FORM
if($submit_1)
{
//START OF SQL UPDATE//
$sql_update = "UPDATE address_list SET first_name='$first_name', middle_name='$middle_name', last_name='$last_name', street='$street', city='$city', state='$state', zip='$zip', notes='$notes', area_code='$area_code', number_1='$number_1', number_2='$number_2', area_code_cell='$area_code_cell', number_1_cell='$number_1_cell', number_2_cell='$number_2_cell', email='$email' WHERE id='".$id."'";
//END OF SQL UPDATE
$rs_update = $DB->Query($sql_update);
}
if($rs_update)
{
echo' address updated';
}


require('footer.php');
?>

Rwap

I got it working.. Thanks again for the other help