Create a select menu in a script

[hbradshaw]

Hello:

I have a script which allows me to edit information and update the database. Right now, the script creates grabs everyone in the table and has a link to edit that person.

Instead, I would like to incorporate a select menu so instead of seeing everyone in the table, the person can select the person they want.

Can anyone point me in the right direction as to how I can modify that portion of the script to include a select menu?

This is the portion of the script that grabs everyone from the table:

if(!isset($choice)) 
{
//display all the customers
$result = mysql_query("select * from customer order by id"); 

//run the while loop that grabs all the news scripts
while($r=mysql_fetch_array($result)) 
{ 
//grab the title and the ID of the news
$fname=$r["fname"];
$lname=$r["lname"];
$id=$r["id"];

$fullname = $fname . " " . $lname;

//make the title a link
echo "$fullname <a href='edit.php?choice=edit&id=$id'>Edit</a>";
echo "<br>";
}
}
?>
[code=php]

The line that actually displays the names with the edit link is the following:

echo "$fullname <a href='edit.php?choice=edit&id=$id'>Edit</a>";

Instead of the above line, I would like it to be a select menu.

I hope someone can help. 

Thank you.

[devinemke]

echo '
<form action="edit.php?choice=edit" method="POST">
choose record to edit:
<select name="choice">
';

$result = mysql_query("SELECT * FROM CUSTOMER ORDER BY id");
while ($row = mysql_fetch_assoc($result))
{ 
	echo '<option value="' . $row['id'] . '">' . $row['fname'] . ' ' . $row['lname'] . "\n";		
}

echo '
</select><br>
<input type="submit" name="submit" value="edit">
</form>
';

then in edit.php you'll have a variable called $_POST['id'] which is the record that the user chose to edit

[hbradshaw]

Hi,

Thanks for your reply. I used what you suggested and it works partially.

When I run the script, I get a screen that says, choose record to edit:. The problem is that there is nothing to choose. The drop down box appears empty.

Any ideas? Any help is greatly appreciated. I'm trying to learn PHP and I've been staring at this thing for a while. A fresh pair of eyes can help.

Here's the script:

<?
$conn = mysql_connect("mysql.addr.com", "summitweb", "summitdb") or die(mysql_error());
mysql_select_db("summitweb",$conn) or die(mysql_error());

//If choice has not been initialized
if(!isset($choice))
{
echo '
<form action="edit.php?choice=edit" method="POST">
choose record to edit:
<select name=\"id\">';

$result = mysql_query("SELECT * FROM CUSTOMER ORDER BY id");
while ($row = mysql_fetch_assoc($result))
{

echo '<option value="' . $row['id'] . '">' . $row['fname'] . ' ' . $row['lname'] . "\n";

}

echo '
</select><br>
<input type="submit" name="submit" value="edit">
</form>';
}
?>
<?
if($GET["choice"]=="edit" || $POST["choice"]=="edit")
{
if (!isset($POST["submit"]))
{
$id = $GET["id"];
$sql = "SELECT * FROM customer WHERE id=$id";
$result = mysql_query($sql);

$myrow = mysql_fetch_array($result);
?>

  <form action="edit.php" method="post">
  <input type=hidden name="id" value="<?php echo $myrow["id"] ?>">

  First Name:<INPUT TYPE="TEXT" NAME="fname" VALUE="<?php echo $myrow["fname"] ?>" SIZE=30><br>
  Last Name:<INPUT TYPE="TEXT" NAME="lname" VALUE="<?php echo $myrow["lname"] ?>" SIZE=30><br>
  Company:<INPUT TYPE="TEXT" NAME="company" VALUE="<?php echo $myrow["company"] ?>" SIZE=30><br>
  Address:<INPUT TYPE="TEXT" NAME="address" VALUE="<?php echo $myrow["address"] ?>" SIZE=30><br>
  City:<INPUT TYPE="TEXT" NAME="city" VALUE="<?php echo $myrow["city"] ?>" SIZE=30><br>   
  State:<INPUT TYPE="TEXT" NAME="state" VALUE="<?php echo $myrow["state"] ?>" SIZE=3><br>
  Zip Code:<INPUT TYPE="TEXT" NAME="zipcode" VALUE="<?php echo $myrow["zipcode"] ?>" SIZE=10><br>
  Home Phone:<INPUT TYPE="TEXT" NAME="homephone" VALUE="<?php echo $myrow["homephone"] ?>" SIZE=25><br>
  Work Phone:<INPUT TYPE="TEXT" NAME="workphone" VALUE="<?php echo $myrow["workphone"] ?>" SIZE=25><br>
  Primary Email Address:<INPUT TYPE="TEXT" NAME="primaryemail" VALUE="<?php echo $myrow["primaryemail"] ?>" SIZE=70><br> 
  Secondary Email Address:<INPUT TYPE="TEXT" NAME="secondaryemail" VALUE="<?php echo $myrow["secondaryemail"] ?>" SIZE=70><br>

  <input type="hidden" name="choice" value="edit">

  <input type="submit" name="submit" value="submit">

  </form>

<? } ?>
<?
if ($POST["$submit"])
{
$fname = $POST["fname"];

  $sql = "UPDATE customer SET fname='$fname', lname='$lname', company='$company', address='$address',
            city='$city', state='$state', zipcode='$zipcode', homephone='$homephone', workphone='$workphone',
            primaryemail='$primaryemail', secondaryemail='$secondaryemail' WHERE id=$id";
  //replace news with your table name above
  $result = mysql_query($sql);
  echo "Thank you! Information updated.";
}

}
?>

Thank you for the help.

[gufmn]

I could be totally off here but, I've never used <option> without </option>. Haven't tested it but will it work without the closing tags. Or is this maybe what's missing here?

[hbradshaw]

Hi,

Placing the </option> tag didn't help either.

Thanks for trying.