STILL AT IT...Populating fields for an update...

[lukatchikm]

For those of you not knowing my previous situation, it is as follows:

An administrator selects an employee name from a drop-down menu, clicks 'Submit', and proceeds to the next page which does the following:

1. Finds the record for the particular employee selected from the drop-down menu

2. Takes that 1 record result (Only 1 row can match the 1 employee record chosen) and puts each of it's several values (id, f_name, l_name, title, dept, phone, fax, ext, email) into an array.

3. Echo's the array results in editing fields which, technically, will allow for record updating.
   [/list=1]

   Obviously, I know what has to happen, but my syntax isn't operating the way I had intended...Take a look...

   <?
   
   // Populates fields for updating
   
   foreach($_POST as $varname => $value)
   $formVars[$varname]=$value;
   
   // Connect to the database
   $db1=mysql_connect("localhost","michael","pass");
   
   // Select the correct database
   mysql_select_db("COUNTY_DIRECTORY");
   
   // Generate a result based on the query - choice was passed as the value of the employee from the drop-down menu
   $result= mysql_query("SELECT * FROM EMPLOYEE_INFO WHERE id = '" . $_POST['choice'] . "' ");
   
   // When a match is found, the result will equal one matching record row
   $row=mysql_fetch_row($result);
   
   // Put each of the several record values into an array - We'll print these later in the main body...
   $formVars = array();
   $formVars["id"]=$row["id"];
   $formVars["f_name"]=$row["f_name"];
   $formVars["l_name"]=$row["l_name"];
   $formVars["dept"]=$row["dept"];
   $formVars["title"]=$row["title"];
   $formVars["phone"]=$row["phone"];
   $formVars["ext"]=$row["ext"];
   $formVars["fax"]=$row["fax"];
   $formVars["email"]=$row["email"];
   
   ?>
   

   In the main body of my document, I want to take the values that were extracted from the database and print them to editing fields that will allow for updates. I am formatting this output in a table structure:

   <tr>
   <td>
   <b> ID field:</b>
   </td>
   <td>
   <input type="text" name="id"
   value="<? echo $formVars["id"]; ?>" size=4>
   </td>
   </tr>
   <tr>
   <td>
   <b>First Name:</b>
   </td>
   <td>
   <input type="text" name="f_name"
   value="<? echo $formVars["f_name"]; ?>"size=50>
   </td>
   </tr>
   <tr>

   ......And so forth for each remaining item left in the array...

   As it stands now, I do not understand why I am not able to pull in these values for editing. I am having mad troubles with this and I need a professional explanation...

   Thank you all for your help so far!!!

   Mike

[LordShryku]

Probably because you're using mysql_fetch_row, which creates an enumerated array. You'll probably want to switch that to mysql_fetch_array.

As a side note, creating the formVars array seems kind of pointless, since you'll already have an array with the same keys and values...

[lukatchikm]

Initially, I was using mysql_fetch_array, then I was referred to using mysql_fetch_row...

fetch_array seemed sensible to be, but I have been trying anything and everything to get this working...

I was forcing the record contents into an array, but I will give it a go without formVars[]

Thanks, Mike

[LordShryku]

Well, fetch row would work, just not the way you want. Since the array is numeric, you'd be saying $row[0] and $row[1] instead of $row['id'] and $row['f_name'].

[lukatchikm]

I am using mysql_fetch_array().

I do not understand why it is not pulling those values from the database and putting them into editing text fields...

In the past, I've used this script in a way that I passed a name from a form, searched for the record in the database, and all fields were populated with the correct record data in a snap.

This concept is similar in a way that I am looking for a match in the database where 'choice', which holds a numeric 'id' value, matches the 1 particular record in which the administrator has selected from the drop-down menu.

Since fetch_array puts items into an array automatically, there is no need to 'force' anything else into an array, as I previously did...

My current code is short and sweet:

$db1=mysql_connect("localhost","michael","xcrunner");
mysql_select_db("COUNTY_DIRECTORY");
$result= mysql_query("SELECT * FROM EMPLOYEE_INFO WHERE id = '" . $_POST['choice'] . "' "); 
$row=mysql_fetch_array($result);

and I want to echo the results of each element of that array in an editable field...

<b>First Name:</b></font>
<input type="text" name="f_name"
value="<? echo $row["f_name"]; ?>" size='50'>

I'm sorry this is so repetitive, but if it were possible, I'd take a Craftsman and drill the concept into my head...

Thanks so much LorkShryku

[LordShryku]

No worries. I have no problem helping people who try...

Lets try some basic debugging and see where it's going wrong. Give this a shot

if(!empty($_POST['choice'])) {
   # if choice exists, create the connection
   $db1 = mysql_connect("localhost", "michael", "xcrunner");
          mysql_select_db("COUNTY_DIRECTORY");
   $sql = "SELECT * 
             FROM EMPLOYEE_INFO 
            WHERE id = '".$_POST['choice']."'"; 
   $result = mysql_query($sql) or die(mysql_error());
   # the or die will make sure nothing's wrong with the sql statement
   if(mysql_num_rows($result) > 0) {
      # make sure rows were returned
      $row = mysql_fetch_array($result);
      # show the form
   }
   else {
      die("ID does not exist in the database");
   }
}
else {
   die("Invalid form selection");
}

[lukatchikm]

LordShryku,

I will expand on this idea, and I'll post if I need additional help.

Thanks, Mike