checkboxes and selects

[porco]

Hi, I have a form that takes members details and puts them in a members table in mysql. I then have a second form for altering this information with an update query. I have 2 questions which would help me work out where to go next.

On submitting the update, for some reason, the drop down select menu fields are overwritten with empty fields.

1. How do I repopulate the checkboxes to show ticks for the right boxes.

2. How do I make the form not overwrite the values from select menus with blank entries.

Thanks for any ideas.

[Kudose]

Cant do much code fixing blind.

We need to seem some code.

[leatherback]

Hi,

In general:
Use the keyword "checked" to have a checkbox xhecked:
<input type="checkbox" name="MyBox" checked>
and "Selected" for a list item

So check the record for which items shoulb be checked / selected, and add the keywords to the appropriate elements on the second form.

For more detailed help you should post some code & explain where you are stuck/

J.

[porco]

Here is the code for the table... (sorry server was down all day)

echo "<p>Select Interests";
echo "<input class=\"interests\" type=\"checkbox\" name=\"interests[]\" value=\"technology\">Technology";
echo "<input type=\"checkbox\" name=\"interests[]\" value=\"enterprise\">Enterprise";
echo "<input type=\"checkbox\" name=\"interests[]\" value=\"research\">Research";
echo "<input type=\"checkbox\" name=\"interests[]\" value=\"government\">Government";
echo "<input type=\"checkbox\" name=\"interests[]\" value=\"people\">People";
echo "<input type=\"checkbox\" name=\"interests[]\" value=\"lifestyle\">Life Style";
echo "<input type=\"checkbox\" name=\"interests[]\" value=\"opinion\">Opinion</p>\n";

and here is the code for repopulating the form from mysql...

//Populate the from from members table in the database

include ("phpmodules/dbfuncs.inc");
$link = connectToDatabase();
if(!$link)
{
print "database connection error";
mysql_close($link);
exit();
}

	 $query = "select * from members where loginname='$loginname'";
	 $result = mysql_query($query) or die(mysql_error());
   mysql_close($link);


		// populate the form fields
	  while($myrow = mysql_fetch_array($result))
	  {
		      $loginname = $myrow['loginname'];
				  $password = $myrow['password'];
			  	$password2 = $myrow['password2'];
					$fname = $myrow['fname'];
					$lname = $myrow['lname'];
					$address = $myrow['address'];
					$city = $myrow['city'];
					$state = $myrow['state'];
					$country = $myrow['country'];
					$email = $myrow['email'];
				  $interests = $myrow['interests'];
		  		$question = $myrow['question'];
					$answer = $myrow['answer'];
	  }