HTML Forum

**jim.thornton** · 11-25-2005, 12:01 AM

I have created a database using mysql & php. However, I have run in to a road block... I want to create an edit screen, where the "addclient" form will open and populates each element's value with the mysql variables.

I can populate the text fields without a problem but how do I change the value of radio buttons and combo boxes.

Here is what I have... Which doesn't work.

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
	How is your mood?
	<select name="Mood">
				<option>Happy</option>
				<option>Sad</option>
				<option>Neutral</option>
			</select>
	<script type="text/javascript" language="javascript">
		document.getElementById("Mood").value = "Sad";
	</script>
</body>
</html>

Can anyone help me?

Zinc.

**RoLLiNLoW54** · 11-25-2005, 12:48 AM

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
	How is your mood?
	<select name="Mood">

<?php

$db = mysql_connect("yourDbHost", "yourDbUser", "yourDbPass");
mysql_select_db("yourDbName",$db);

result = mysql_query("SELECT * FROM someTable",$db);

if ($myrow = mysql_fetch_array($result))
     do {
          print("<option name=\"$myrow[value]\" value=\"$myrow[value]\">$myrow[value]</option>");
          }
     while ($myrow = mysql_fetch_array($result));
}

?>

	</select>
	<script type="text/javascript" language="javascript">
		document.getElementById("Mood").value = "Sad";
	</script>
</body>
</html>

something like this?

**eburza** · 11-25-2005, 02:54 AM

you don't need name=\"$myrow[value]\" under <option> tag!

Quote:

Originally Posted by RoLLiNLoW54

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
	How is your mood?
	<select name="Mood">

<?php

$db = mysql_connect("yourDbHost", "yourDbUser", "yourDbPass");
mysql_select_db("yourDbName",$db);

result = mysql_query("SELECT * FROM someTable",$db);

if ($myrow = mysql_fetch_array($result))
     do {
          print("<option name=\"$myrow[value]\" value=\"$myrow[value]\">$myrow[value]</option>");
          }
     while ($myrow = mysql_fetch_array($result));
}

?>

	</select>
	<script type="text/javascript" language="javascript">
		document.getElementById("Mood").value = "Sad";
	</script>
</body>
</html>

something like this?

**Kyrnt** · 11-25-2005, 02:00 PM

Quote:

Originally Posted by zincoxide

I can populate the text fields without a problem but how do I change the value of radio buttons and combo boxes.

.

Zinc, to mark any option within a combo box as being the current value, give it a selected="selected" attribute. For example, say you wanted "Sad" to be the selected value,

HTML Code:

<option selected="selected">Sad</option>

**RoLLiNLoW54** · 11-25-2005, 02:01 PM

whoop, sorry bout the name thing

**TrentonD** · 11-25-2005, 04:45 PM

Quote:

Originally Posted by Kyrnt

Zinc, to mark any option within a combo box as being the current value, give it a selected="selected" attribute. For example, say you wanted "Sad" to be the selected value,

HTML Code:

<option selected="selected">Sad</option>

Yea, but if you want to show something that has been submitted by a form, you should use this code, in PHP of course:

PHP Code:


			
<option value="0" <?php if($ql_category == 0){ echo "SELECTED"; }?>>Option 1
<option value="1" <?php if($ql_category == 1){ echo "SELECTED"; }?>>Option 2

But of course, you will need to post the variables to this page, and also set them as variables.

**eburza** · 11-26-2005, 01:59 PM

just a tip ....

if u using xhtml use selected="selected" instead of SELECTED ...

**jim.thornton** · 12-06-2005, 10:35 PM

Thank you for your help.

HTML Forum

Find a Professional HTML Freelancer!

FREE Outsourcing eBook!