form

[harkly]

I am working on creating a form that updates a table. I need to be able to pull some info from another table as a select option. I got it working to where I can pull the info but cannot update it.

//display the form

   echo "<table border=0>";
   echo "<tr><td><img src='../image/$artid/$artid.jpg' border=0></td>\n";
   echo "<tr><td valign=top><form method='post' action='updateArtist.php'><h5>Artist Id --</b><input type='text' name='artid' value='$artid'></td></tr>\n";

   echo "<tr><td><h5>Name(s) --</b></td></tr>  \n";
   echo "<tr><td><h2>First</td>  <td>Middle</td>  <td>Last</td></tr><tr>  \n";
   echo "<tr><td><input type='text' name='firstName' value='$firstName'></td><td><input type='text' name='middleName' value='$middleName'></td><td><input type='text' name='lastName' value='$lastName'></td></tr>\n";
   echo "<tr><td><h2>Full Name </td><td>Other Name --</td><td><h2>Called</td></tr>\n";
   echo "<tr><td><input type='text' name='fullName' value='$fullName'></td><td><input type='text' name='called' value='$called'></td><td><input type='text' name='otherName' value='$otherName'></td></tr>\n";


   echo "<tr><td colspan=3><h5>DOB/DOD --</b></td></tr>  \n";
   echo "<tr><td><h2>DOB Extra</td><td><h2>Date of Birth</td><td><h2>DOD Extra</td><td><h2>Date of Death</td></tr>\n";
   echo "<tr><td><input type='text' name='dob_xt' value='$dob_xt'></td><td><input type='text' name='dob' value='$dob'></td><td><input type='text' name='dod_xt' value='$dod_xt'></td><td><input type='text' name='dod' value='$dod'></td></tr>\n";



   echo "<tr><td><h5>Art Form --</td></tr><tr><td><input type='text' name='artform' value='$artform'></td></tr>\n";


   echo "<tr><td colspan=3><h5>Movements Associated to --</b></td></tr>  \n";
   echo "<tr><td><h2>1</td> <td><h2>1</td><td><h2>3</td</tr>\n";
   echo "<tr><td><input type='text' name='movid_1' value='$movid_1'></td><td><input type='text' name='movid_2' value='$movid_2'></td><td><input type='text' name='movid_3' value='$movid_3'></td></tr>\n";



   echo "<tr><td colspan=3><h5>Mediums Associated to --</b></td></tr>  \n";
   echo "<tr><td>1</td><td>2</td><td>3</td></tr>\n";
   echo "<tr><td><input type='text' name='medid_1' value='$medid_1'><td><input type='text' name='medid_2' value='$medid_2'></td><td><input type='text' name='medid_3' value='$medid_3'></td></tr>\n";



// **** THIS IS WHERE I HAVE MODIFIED THE CODE TO GET A DROP DOWN BUT I NEED TO BE ABLE TO UPDATE THE TABLE AND ITS NOT WORKING ****



  echo "<tr><td>  \n";

echo "<b>Medium</b> <br><br>";	
$result = mysql_query("SELECT * FROM medium order by medName") or die(mysql_error());
$num_rows=mysql_num_rows($result);

  if ($num_rows != "0")
    {

            echo "<form method='post' action='updateArtist.php'>";
            echo "<select name='medium'>";

        while ($r=mysql_fetch_array($result))
          {	
            $medName=$r["medName"];
            $medid=$r["medid"];
            $description=$r["description"];
            $keywords=$r["keywords"];
            $notes=$r["notes"];


            echo "<option value='$medid_1' selected>$medName</option>";


          }
            echo "</select>";
            echo "<input type='hidden'>";
            echo "</form>";
    }


  echo "</td></tr>\n";


   echo "<tr><td colspan=3><h5>Genres Associated to --</b></td></tr>  \n";
   echo "<tr><td><h2>1</td><td>2</td><td>3</td></tr>\n";
   echo "<tr><td><input type='text' name='genid_1' value='$genid_1'></td><td><input type='text' name='genid_2' value='$genid_2'></td><td><input type='text' name='genid_3' value='$genid_3'></td></tr>\n";


   echo "<tr><td colspan=3><h5>Period Assocaited with --</b></td><td>  \n";
   echo "<tr><td><input type='text' name='perid' value='$perid'></td></tr>\n";

   echo "<tr><td><h5>Bio --</td><td><textarea rows='5' cols='20' wrap='physical' name='bio' value='$bio'>
        $bio</textarea></td></tr>\n";

   echo "<tr><td><h5>Keywords --</td><td><textarea rows='5' cols='20' wrap='physical' name='keywords' value='$keywords'>
        $keywords</textarea></td></tr>\n";

   echo "<tr><td><h5>Notes --</td><td><textarea rows='5' cols='20' wrap='physical' name='notes' value='$notes'>
        $notess</textarea></td></tr>\n";

   if ($verified)
      echo "<tr><td><h5>Verified</h3></td><td><input type='checkbox' name='verified' value='1' checked></td></tr>\n";
   else
      echo "<tr><td><h5>Verified</h3></td><td><input type='checkbox' name='verified' value='1'></td></tr>\n";

   echo "<tr><td><input type='submit' name='button' value='Update'></td></tr>\n";
   echo "</form>\n";
   echo "</table>";

Can any help me??

[vronsky]

pls... try to explain better? Which table you have to update and with what??

[harkly]

I have a form that will update a table(artist) with new information. Currently every field needs to be typed. This form works and will update.

Now there are at least 6 fields that I want to pull the info from different tables but only update the artist table with that information so they can be associated together.

tables:
Artist
Genre
Medium

My form :
Name: __________
ID:__________
Genre 1 _______
Genre 2________
Medium 1_______
Medium 2__________

I want the Genres and the Mediums to pull there info from there own tables, because there will be a set list to be chosen from, and then update the artist table with that information.

Does this makes sense?

[djjjozsi]

Name: __________
ID:__________
Genre 1 _______
Genre 2________
Medium 1_______
Medium 2__________

Does this makes sense?

Yes, and how about a function to do that?

make the fextfields to the other inputs, then use the function to make these dropdowns:
where:
-$id - this is the name of your table's id field
-$label - Before the dropdown it shows a text
-$var - this will be your dropdown's variable name
-$table - the table's name
-$field - which field you want to print as an option
-$selected - lets add the actual value of this 'row', and this option will be selected as default

<?php

/*
sample
make_list($id,           $label,        $var,        $table,  $field,    $selected) ;
*/
make_list("genre_id","Genre 1","Genre1","Genre","genre", $row["genre_id_1"]);
make_list("genre_id","Genre 2","Genre2","Genre", "genre", $row["genre_id_2"]);
make_list("med_id","Medium 1","Medium1","Medium","medium", $row["medium_id_1"]);
make_list("med_id","Medium 2","Medium2","Medium","medium", $row["medium_id_2"]);


/*...  take this function on the beggining of your code...*/
	function make_list($id,$label,$var,$table,$field,$selected)
	{

	$sql="SELECT $field,$id FROM $table ORDER BY $field";
	print "$label: ";

	print "<select name=\"$var\">";
	print "<option value=\"\"></option>";

	$res=mysql_query("$sql");

	while( $row = mysql_fetch_assoc( $res))
	{
		if($selected==$row["$id"])
			print "<option value=\"".$row["$id"]."\" SELECTED>". htmlspecialchars(stripslashes($row["$field"]))."</option>\r";
		else
			print "<option value=\"".$row["$id"]."\">". htmlspecialchars(stripslashes($row["$field"]))."</option>\r";
	}
	print "</select>";
}

?>