Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

pull from mysql into drop down menu, keep state... 1

Status
Not open for further replies.
dal2

dal2

Technical User
May 16, 2005
34
US
I need to be able to add assignedto to a drop down menu if not null and update db after selection. I'm using a basic php echo currently.

<SELECT NAME='assignedto'>
<OPTION value="<?php echo $assignedto ?>"></OPTION>

But, the menu state changes and updates the db...
do I need a menu state holder??? sorry about my lack of lingo in this area...
Tia,
David
 
Sort by date Sort by votes
I'm offsite now but here's the pseudo code...

users fill out web form, updates db sends email
to mgr and task recipient.
mgr views add / edit form direct to db.
Question: How to read data from assignedto field
into drop down menu if not null? Standard php / mysql
call to db with basic html form...currently, echos
the data to the input text field...How do I echo to
the drop down menu if not null??? The mgr wants to
be the only one to make assignments...the value in the
menu is the person's email address so I am hoping to
make that an easy usability fix...also, if the mgr
has selected someone then changes another entry, how
to maintain the original input without overwriting?
Thanks,
David
 
Upvote 0 Downvote
Thanks for your help. My client changed their requirements.
Basically, I wanted a drop down menu that would pull from the assignedto field in the tsr table. If it was null then the mgr would select a new user if not null then the selected would change and not be overwritten unless the mgr chose to overwrite it...does that make sense?
I'm sure there's an easy solution for that but I've moved on...thanks again for your time and effort.
David Larew
 
Upvote 0 Downvote
What you wanted is easy.
You just have to let me know your sample code, before I work something out from there.
 
Upvote 0 Downvote
<html>
<title>Thanks in Advance...David</title>
<head>



<script>
<!--
function land(ref, target)
{
lowtarget=target.toLowerCase();
if (lowtarget=="_self") {window.location=loc;}
else {if (lowtarget=="_top") {top.location=loc;}
else {if (lowtarget=="_blank") {window.open(loc);}
else {if (lowtarget=="_parent") {parent.location=loc;}
else {parent.frames[target].location=loc;};
}}}
}
function jump(menu)
{
ref=menu.choice.options[menu.choice.selectedIndex].value;
splitc=ref.lastIndexOf("*");
target="";
if (splitc!=-1)
{loc=ref.substring(0,splitc);
target=ref.substring(splitc+1,1000);}
else {loc=ref; target="_self";};
if (ref != "") {land(loc,target);}
}
//-->
</script>
<style type="text/css">
BODY { font-family: Verdana, Arial, San-Serif; font-size: 10px; color: #000000}
TD { font-family: Verdana, Arial, San-Serif; font-size: 10px; color: #000000}

A { font-family: Verdana, Arial, San-Serif; font-size: 10px; color: #000000; text-decoration: underline}
A:visited { font-family: Verdana, Arial, San-Serif; font-size: 10px; color: #000000; text-decoration: underline}
A:hover { font-family: Verdana, Arial, San-Serif; font-size: 10px; color: #ff0000; text-decoration: underline}


h1 { padding: 2px; padding-width: 100%; background-color: silver }
td, th { width: 20%; border: 1px solid silver; padding: 1px }
td:first-child, th:first-child { width: 10% }
table { width: 50% }
</style>


</head>
<body bgcolor="#c0c099">

<!--
date DATE NOT NULL,
requesteddate DATE NOT NULL,
duedate DATE NOT NULL,
last varchar(40) NOT NULL,
first varchar(20) NOT NULL,
requestedby varchar(255) NOT NULL,
aassignedto varchar(255) NOT NULL,
location varchar(20) NOT NULL,
phone varchar(20) NOT NULL,
mobile varchar(20) NOT NULL,
fax varchar(20) NOT NULL,
email1 varchar(255) NOT NULL,
email2 varchar(255) NOT NULL,
email3 varchar(255) NOT NULL,
url1 varchar(255) NOT NULL,
url2 varchar(255) NOT NULL,
url3 varchar(255) NOT NULL,
pic1 varchar(255) NOT NULL,
pic2 varchar(255) NOT NULL,
pic3 varchar(255) NOT NULL,
details1 varchar(255) NOT NULL,
details2 varchar(255) NOT NULL,
details3 varchar(255) NOT NULL,
details4 varchar(255) NOT NULL
-->

<ul><ul><h2><p> Add / Update A Record </h2><p>
<h4>For Example: Enter ?ID=(#) in url.. addedit.php?ID=80 </h4>
<?php
if($submit)
{
$db = mysql_connect("localhost", "username","pwd");
mysql_select_db("something",$db);

$sql = "INSERT INTO tsr_form (requesteddate, duedate, date, last, first, requestedby, aassignedto, location, phone, mobile, fax, email1, email2, email3, url1, url2, url3, pic1, pic2, pic3, details1, details2, details3, details4)
VALUES ('$requesteddate','$duedate','$date','$last','$first','$requestedby','$aassignedto','$location','$phone','$mobile','$fax','$email1','$email2','$email3','$url1','$url2','$url3','$pic1','$pic2','$pic3','$details1','$details2','$details3','$details4')";

$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
}
else if($update)
{
$db = mysql_connect("localhost", "username","pwd");
mysql_select_db("something",$db);
$sql = "UPDATE tsr_form SET requesteddate='$requesteddate', duedate='$duedate', date='$date', last='$last', first='$first',requestedby='$requestedby',aassignedto='$aassignedto',location='$location',phone='$phone',mobile='$mobile',fax=$fax',email1='$email1',email2='$email2',email3='$email3',url1='$url1',url2='$url2','$url3',pic1='$pic1',pic='$pic2',pic3='$pic3',details1='$details1',details2='$details2',details3='$details3',details4='$details4' WHERE ID=$ID";


$result = mysql_query($sql);
echo "Thank you! Information updated.\n";
}
else if($ID)
{
$db = mysql_connect("localhost", "username","pwd");
mysql_select_db("something",$db);
$result = mysql_query("SELECT * FROM tsr_form WHERE ID=$ID",$db);
$myrow = mysql_fetch_array($result);
?>


<br /><ul><ul>



<br />

<form method="post" action="<?php echo $PHP_SELF?>">
<input type="hidden" name="ID" value="<?php echo $myrow["ID"]?>">
<table>

<tr>
<td valign="middle" align="right" width="107"> Date :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="date" value="<?php echo $myrow["date"]?>"></td>
</tr>

<tr>
<td valign="middle" align="right" width="107"> requesteddate :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="requesteddate" value="<?php echo $myrow["requesteddate"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> duedate :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="duedate" value="<?php echo $myrow["duedate"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> last :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="last" value="<?php echo $myrow["last"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> first :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="first" value="<?php echo $myrow["first"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> requestedby :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="requestedby" value="<?php echo $myrow["requestedby"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> aassignedto :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="aassignedto" value="<?php echo $myrow["aassignedto"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> location :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="location" value="<?php echo $myrow["location"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> phone :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="phone" value="<?php echo $myrow["phone"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> mobile :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="mobile" value="<?php echo $myrow["mobile"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> fax :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="fax" value="<?php echo $myrow["fax"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> email1 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="email1" value="<?php echo $myrow["email1"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> email2 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="email2" value="<?php echo $myrow["email2"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> email3 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="email3" value="<?php echo $myrow["email3"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> url1 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="url1" value="<?php echo $myrow["url1"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> url2 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="url2" value="<?php echo $myrow["url2"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> url3 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="url3" value="<?php echo $myrow["url3"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> pic1 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="pic1" value="<?php echo $myrow["pic1"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> pic2 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="pic2" value="<?php echo $myrow["pic2"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> pic3 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="pic3" value="<?php echo $myrow["pic3"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> details1 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="details1" value="<?php echo $myrow["details1"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> details2 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="details2" value="<?php echo $myrow["details2"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> details3 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="details3" value="<?php echo $myrow["details3"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> details4 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="details4" value="<?php echo $myrow["details4"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"></td>
<td valign="middle" width="303"><input type="Submit" name="update" value="Update information"></form></td>
</tr>

</table>
<?
}
else
{
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<input type="hidden"name="ID" value="<?php echo $myrow["ID"]?>">
<table>
<tr>
<td valign="middle" align="right" width="107"> requesteddate :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="requesteddate"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> duedate :</td>
<td valign="middle" width="303"><input type="Text"size="40" name="duedate"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> Date:</td>
<td valign="middle" width="303"><input type="Text" size="40" name="date"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> last :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="last"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> first :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="first"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> requestedby :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="requestedby"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> assignedto :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="aassignedto"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> location :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="location"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> phone:</td>
<td valign="middle" width="303"><input type="Text" size="40" name="phone"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> mobile :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="mobile" value="<?php echo $myrow["mobile"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> fax :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="fax" value="<?php echo $myrow["fax"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> email1 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="email1" value="<?php echo $myrow["email1"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> email2 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="email2" value="<?php echo $myrow["email2"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> email3 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="email3" value="<?php echo $myrow["email3"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> url1 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="url1" value="<?php echo $myrow["url1"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> url2 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="url2" value="<?php echo $myrow["url2"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> url3 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="url3" value="<?php echo $myrow["url3"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> pic1 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="pic1" value="<?php echo $myrow["pic1"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> pic2 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="pic2" value="<?php echo $myrow["pic2"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> pic3 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="pic3" value="<?php echo $myrow["pic3"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> details1 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="details1" value="<?php echo $myrow["details1"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> details2 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="details2" value="<?php echo $myrow["details2"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> details3 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="details3" value="<?php echo $myrow["details3"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"> details4 :</td>
<td valign="middle" width="303"><input type="Text" size="40" name="details4" value="<?php echo $myrow["details4"]?>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="107"></td>
<td valign="middle" width="303"><input type="Submit" name="submit" value="Enter information"></td>
</tr>

</table>
</form>
<?
}
?>


<br /><br /><br />

</ul></ul>
</body>
</HTML>
 
Upvote 0 Downvote
Just to clarify, you said:
>> Basically, I wanted a drop down menu that would pull from the assignedto field in the tsr table

So, does it mean that if the user is not assignedto field (drop down), it will then ask the user to enter a new assignedto field (in the text box)?

 
Upvote 0 Downvote
assignedto is the mgr's choice... the user's fill out the tech support report then the mgr assigns the tasks...I'm trying to make it easy for the mgr to choose / re-choose or not choose...so no it isn't a required field...also, the text box is replaced by the drop down menu...
Thanks,
David
see these screen caps...
 
Upvote 0 Downvote
I still don't understand.

What's the first screen for?
And what is the second screen for?
How come the second screen has got the assigned to field as well?

Sorry, I need to understand first before I will write the code.

Thanks.

 
Upvote 0 Downvote
Code: 
<select name="assignedto">
<?php
if (isset($assignedto)) {
 echo "<option value=\"{$assignedto}\" selected=\"selected\"></option>\n";
}

Olav Alexander Mjelde
Admin & Webmaster
 
Upvote 0 Downvote
sorry, should say:
Code: 
<select name="assignedto">
<?php
if (isset($assignedto)) {
 echo "<option value=\"{$assignedto}\" selected=\"selected\">-- $assignedto --</option>\n";
}

Olav Alexander Mjelde
Admin & Webmaster
 
Upvote 0 Downvote
Thank you! DaButcher, I have a soap c# question if you're up for a new one.
David
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
import CSV file into MySql table in PhpMyAdmin
Replies
0
Views
583
SashaBuilder3
SashaBuilder3
R
  • Locked
  • Question
How Can I Use MySQL To Send Data To An Email
Replies
1
Views
430
Chris Miller
Chris Miller
P
  • Locked
  • Question
JPgraph - How to stop a line graph from dropping to zero?
Replies
2
Views
509
Chris Miller
Chris Miller
lexer
  • Locked
  • Question
Join two mysql tables for populate datatable
Replies
3
Views
382
spamjim
spamjim
ersatz
  • Locked
  • Question
How to send 2 select from mysql database in email like tables
Replies
5
Views
668
ersatz
ersatz

Part and Inventory Search

Sponsor

Back
Top