[Resolved] An odd problem with an update script

[badgoat]

Hi!

The script below works strange.. I can edit the variables just fine, except for the 'cpny_name' variable. For this one, if I edit anything on the page, the 'cpny_name' variable becomes unset. But if I go back, I can change it.

Also, If I do not change anything, but hit 'Update', the 'cpny_name' variable disappears. What am I doing wrong?

code:

<?php
    // Connect to database
$connect= mysql_connect("localhost","root")
   or die("Could not connect to database in localhost !");
mysql_select_db("testdiw")
   or die("Could not select that database !");



if(!empty($_REQUEST['action']) && $_REQUEST['action'] == 'update')
{
        $name_id = $_REQUEST['name_id'];
        $_GET['name_id'] = $name_id;
        $query = "UPDATE `part_name` SET name = '".$_REQUEST['new_name']."', RelCompID ='".$_REQUEST['newRelCompID']."', phone_num ='".$_REQUEST['newphone_num']."', email_addr ='".$_REQUEST['newemail_addr']."', password ='".$_REQUEST['newpassword']."' WHERE name_id='$name_id'";
        $result = mysql_query($query) or die("<b>mySQL Error:</b>".mysql_errono()."<br>".mysql_error());
        if(!$result)
        {
            echo 'Error processing request.';
        }
        else
        {
            echo '<B>The Record has been successfully updated!</B>';
        }
    }

$name_id = $_GET['name_id'];
// The ID is passed through the URL to specify the row,
// Or it is set in the previous script.

$query = "SELECT * FROM part_name WHERE name_id = '$name_id'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

    $cpny_id = $row['RelCompID'];

    $sqlquery1 = "SELECT * from part_company WHERE cpny_id = '$cpny_id'";
    $query1 = mysql_query($sqlquery1) or die (mysql_error());
    $row1 = mysql_fetch_array($query1);

echo '<form name="update1" method="post">
    <input type="hidden" value="update" name="action">
    <input type="hidden" name="name_id" value="'.$name_id.'">
<TABLE>

<TR>
	<TD>Participant ID</TD>
	<TD>'.$row['name_id'].'</TD>
</TR>
<TR>
	<TD> Name:</TD>
	<TD><input type="text" name="new_name" size="40" value="'.$row['name'].'"></TD>
</TR>
<TR>
	<TD>Company:</TD>
    <TD><select name="newRelCompID" tabindex="4"><option value="'.$row1['cpny_name'].'">'.$row1['cpny_name'].'</option>  ';

                    //--- CREATE ParticipantCompany SELECT ---
                    $sql = "SELECT DISTINCT cpny_id, cpny_name FROM part_company ORDER BY cpny_name";
                    $cpny_name = mysql_query($sql) or die($sql . '<br />' . mysql_error());
                    while ($row1 = mysql_fetch_array($cpny_name)) {
                    echo '<option value="' . $row1['cpny_id'] . '">' . $row1['cpny_name'] . '</option>';
                    }
       ;

$query = "SELECT * FROM part_name WHERE name_id = '$name_id'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);


echo '	</TD>
	</TR>
    <TR>
		<TD>Phone Number:</TD>
		<TD><input type="text" name="newphone_num" size="30" value="'.$row['phone_num'].'"></TD>
	</TR>
    <TR>
		<TD>Email Address:</TD>
		<TD><input type="text" name="newemail_addr" size="30" value="'.$row['email_addr'].'"></TD>
	</TR>
        <TR>
		<TD>Password:</TD>
		<TD><input type="text" name="newpassword" size="5" value="'.$row['password'].'"></TD>
	</TR>
    <TR>
	<TD><input type="submit" value="Update"></TD
	</TR>
    </TABLE>    ';
    ?>
    </BODY>
</HTML>

[badgoat]

fixed by changing

<TD><select name="newRelCompID" tabindex="4"><option value="'.$row1['cpny_name'].'">'.$row1['cpny_name'].'</option>  ';

                    //--- CREATE ParticipantCompany SELECT ---
                    $sql = "SELECT DISTINCT cpny_id, cpny_name FROM part_company ORDER BY cpny_name";
                    $cpny_name = mysql_query($sql) or die($sql . '<br />' . mysql_error());
                    while ($row1 = mysql_fetch_array($cpny_name)) {
                    echo '<option value="' . $row1['cpny_id'] . '">' . $row1['cpny_name'] . '</option>';
                    }
       ; 

to:

<TD><select name="newRelCompID" tabindex="4"><option value="'.$row1['cpny_id'].'">'.$row1['cpny_name'].'</option>  ';

                    //--- CREATE ParticipantCompany SELECT ---
                    $sql = "SELECT DISTINCT cpny_id, cpny_name FROM part_company ORDER BY cpny_name";
                    $cpny_name = mysql_query($sql) or die($sql . '<br />' . mysql_error());
                    while ($row1 = mysql_fetch_array($cpny_name)) {
                    echo '<option value="' . $row1['cpny_id'] . '">' . $row1['cpny_name'] . '</option>';
                    }
       ;