PHP Script for Database retrieval??

ajeetraina

Can anyone help me how can one retrieve usernames during the drop-down Box?
Say I added list of users through one option click.
When I click on display it should open up new window displaying all those names added in drop-down box?Pls Help

rulian

I'm not following what you are trying to do.
Are you suppling them with a list of names to choose in a drop down, or do you want the drop down to take the user's inputs?

ajeetraina

Lemme explain you what really I want?
My database Structure includes:
Database: petp
Table : Task
Attributes: list of task,Assigned to,Start Date,End Date,Completion Percent

Now I have created a webpage called pro32.php in which I have the following code:

File : pro32.php

<html>
<body>
<form name="form1" method="post" action="retrieve.php">
<p>Select Project


<select name="Project">
<option value="uone">uone</option>
<option value="psa">PSA</option>
<option value="gice">gice</option>
<option value="dice">dice</option>
</select>
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>

The above code is manually entered Right??
What I want is the drop-down list should take inputs from database.

I tried writing few code but failed to make it work.

Here my trial:

<table align="center" cellpadding=1 border=1 width="70%">
                <tr>
                        <td width=75%><b><font face=arial size=2><input Type="radio" name="optEngineers" value="ListOption" checked>Engineers</font></b></td>
                        <td >&nbsp;&nbsp;<Select Name ="cmbFixedBy" size="1" >
                        <Option value="NULL"> </option>
             <?php
                $con = mysql_connect("localhost","root","mysql123");
                     if (!$con)
                         {
                        die('Could not connect: ' . mysql_error());
                          }

                 mysql_select_db("my_db", $con);

                 $result = mysql_query("SELECT Project,List,Assigned,Start,End,Completion
                                     FROM task");


while($row = mysql_fetch_array($result))
  {
  <option value=". $row['Project'] ">  </option>
  <option value=". $row['List'] ">  </option>
 <option value=". $row['Assigned'] ">  </option>

 <option value=". $row['Start'] ">  </option>

 <option value=". $row['End'] ">  </option>

 <option value=". $row['Completion'] ">  </option>


   }
  mysql_close($con);
?>

                    </td>
            </tr>

Can you pliz help me with this??

rulian

$row will return each task's column information, which is not what I think you want. If you only want to select the project name you can do, you also either have to echo out or embed the <option tag somewhere PHP wont recognize it by itself.

<Select Name ="cmbFixedBy" size="1" >
                        <Option value="NULL"> </option>
<?PHP 
 $con = mysql_connect("localhost","root","mysql123");
if ($con)  mysql_select_db("my_db", $con);
else echo "Cannot Connect to Database"; 

$result = mysql_query("SELECT Project,List,Assigned,Start,End,Completion
                                         FROM task");

while($row = mysql_fetch_array($result))
  {
 echo "<option value='". $row['Project']."'>". $row['Project']."</option>";
  }

?>
</select>

This would list your project names under the dropdown, your previous code without errors would list everything in the database all in 1 drop down

ajeetraina

Great !!! Thanks Buddy.
One more help.Hope you will definitey help me with this too.
I have written a script for user input as follows:
File : pro31.php

<html>
<title>Project Management</title>
<body>
<h1>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp <u>Create New Project</u> &nbsp&nbsp&nbsp&nbsp</h1>

<form name="submit" action="addentry.php" method="post">
<table width="20%" border="1">

<tr>
<td width=45%><b><font face=arial size=2>Project </font></b></td>&nbsp&nbsp
<td><b><font face=arial size=2><input type="text" name= "project_name" value=""  >
</font>
</table>

<br>



<table width="100%" border="1">


<td><font size="-1"><b><font face="Arial,Helvetica,sans-serif">List</font></b></font></td>
<td><font size="-1"><b><font face="Arial,Helvetica,sans-serif">Assigned</font></b></font></td>
<td><font size="-1"><b><font face="Arial,Helvetica,sans-serif">Start</font></b></font></td>
<td><font size="-1"><b><font face="Arial,Helvetica,sans-serif">End</font></b></font></td>
<td><font size="-1"><b><font face="Arial,Helvetica,sans-serif"> Completion</font></b></font></body><body></td>

</tr>
   <tr>
<td><input type="text" name="list_of_task"></td>


<td>
<select name="assigned_to">
<option>Select</option>
<option>Abhinesh Sethumadhavan</option>
<option>Prabhu Hosmani</option>
</select></td>

<td><input type="text" name="start_date"></td>
<td><input type="text" name="end_date"></td>

<td><input type="text" name="completion_percent"></td>
  </tr>
</table>





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



</form>




</body></html>

Whenever a user supplies with the informations and click on Submit Button,the data base is updated and that is working for me.

But whenever I am trying to retrieve the database entry once I run the earlier code on the first thread(SEE above),it displays serially but not on the same format as Pro32.php.

Pls Help me with this.