PHP - Delete A Mysql Row From A Drop-down Html Menu

The code is posted he http://codepad.org/Fck5s2zz
The attached file (delete_user.php) is the same as the code in the link above.
The same code is also posted below.

[text]
What I am trying to do is create a function that will allow me to delete a user from my mysql database.

I have an HTML select that outputs the username(s) using the function get_admin_username()
(The function is posted below)

There is also a HTML form I am using to make this happen.
(Also posted below)

In other words I would select the user I would like to delete, and click submit which will then delete the user from the database.

The problem I am having is I do not know how to pass values from the HTML select, or the form, or even use the submit button value.

I am not sure If I need to create a function to achieve this.
Basically I don't know what to do this at all for that matter.

I thought I might have gotten close but I thought wrong, and failed.
I was told (in the php irc) that my method was way off and wrong but was given no help after that.

I do have an example to show you of how I tried to accomplish this, but being told that I was wrong I did not feel that it was even worth posting it.

I am lost and have been at this for two days now.  I am a noobe but I do understand allot (I think).

Someone, anyone, please help.

Thank You,

Ryan
[/text]

Code:
Code: [Select]
<?php 

   // Session's Functions
   require_once("../includes/sessions/session.php");

   // Establish A Connection To The Database
   require_once("../includes/connection/connection.php");

   // User Defined Admin Functions
   require_once("includes/functions/admin_functions.php");

   // New User Functions
   //require_once("includes/users/delete_user.php");

   // Confirms If The User Is Logged In
   confirm_logged_in(); 

   // Document Header
   include("includes/templates/default/header.php"); 

?>


<?php
   // Gets The Admin Username
   function get_admin_username() 
      {
         global $connection;
         $query = "SELECT * FROM administration_users ";
         $query .= "ORDER BY username";
         $admin_user_set = mysql_query($query, $connection);
         confirm_query($admin_user_set);

         while ($admin_users = mysql_fetch_array($admin_user_set)) 
            {
               echo "<option value=\"username" . "\">" . $admin_users['username'] ."\n  ";
            } 
      }
?>


      <table id="structure">
         <tr>
            <td id="navigation">
               <a href="../staff.php">Return To Staff Menu</a>
               <a href="admin_content.php">Return To Admin Menu</a>
<br />
<br />
               <ul class="menu">
                  <li class="pages"><a id="page_menu" href="new_user.php">Add New User</a></li>
                  <li class="pages"><a href="edit_user.php">Edit User</a></li>
                  <li class="pages"><a href="list_users.php">List Users</a></li>
                  <li class="pages"><a href="delete_user.php">Delete User</a></li>
               </ul>
            </td>

            <td id="page">
               <h2>Remove User</h2>

<br />

               <form action="delete_user.php" name="delete_user" method="post">
                  <table>
                     <tr>
                        <th class="field_name field_padding_user_name">User Name: &nbsp;</th>

                        <td>
                           <select id="select_username" name="username_select">
                              <?php echo get_admin_username();?>
                           </select>
                        </td>
                     </tr>

                     <tr>
                        <td class="delete_user_submit" colspan="2"><input type="submit" name="submit" value="Delete User"
                             onclick="return confirm('Are You Sure You Want To Delete This User?');"/></td>
                     </tr>
                  </table>
               </form>
            </td>
         </tr>
      </table>


<?php 

   // Document Footer
   include("includes/templates/default/footer.php");

?>

MOD EDIT: [code] . . . [/code] tags added.

your MySQL server version:  5.1.36

Code: [Select]
SELECT * FROM game_weapons

Table: Picture Attached

the EXPLAIN output for your query, if applicable:
I wish to connect a drop down menu's selection of weapons with the correlated table information.

What do I want to happen:
Click on a drop down Menu and have a list of weapons, these weapons are associated with a set number in the database and passed onto the next screen.   (The larger number wins, this part I have figured out).

               <p>
               <select name="weapon2" style="font-size:20px;font-family:Arial;width:275px">
               <option value="power">Power</option>
               <option value="intelligence">Intelligence</option>
               <option value="speed">Speed</option>
               <option value="reserve">Reserve</option>
               </select>
               </p>


I do have the battle code figured out!  (This should be the last step).

Alright so I created a MySQL database that has 5 tables each named a brand of a dirt bike.

In each table their are 2 fields, one INDEX_ID and MODELS.

Under that for rows I have every model bike named.

A quick question before I get onto what I want to do:

Can data be added underneath the rows?

For example, users will be able to submit information about each bike model. If each bike model is a row, can there be a category past that row or do I need to make each field a model name and just have a ton of fields and have the rows be the information users submit.

To make it easier to understand I'll post the SQL code for the brand Honda:

CREATE TABLE `Honda` (
  `INDEX_ID` int(3) NOT NULL auto_increment,
  `MODELS` varchar(20) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`INDEX_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=23 ;

--
-- Dumping data for table `Honda`
--

INSERT INTO `Honda` VALUES(1, 'CR85');
INSERT INTO `Honda` VALUES(2, 'CR125');
INSERT INTO `Honda` VALUES(3, 'CR250');
INSERT INTO `Honda` VALUES(4, 'CRF100');
INSERT INTO `Honda` VALUES(5, 'CRF150');
INSERT INTO `Honda` VALUES(6, 'CRF230');
INSERT INTO `Honda` VALUES(7, 'CRF250X');
INSERT INTO `Honda` VALUES(8, 'CRF250R');
INSERT INTO `Honda` VALUES(9, 'CRF450X');
INSERT INTO `Honda` VALUES(10, 'CRF450R');
INSERT INTO `Honda` VALUES(11, 'CRF50');
INSERT INTO `Honda` VALUES(12, 'CRF70');
INSERT INTO `Honda` VALUES(13, 'CRF80');
INSERT INTO `Honda` VALUES(14, 'XR650');
INSERT INTO `Honda` VALUES(15, 'CR500');
INSERT INTO `Honda` VALUES(16, 'XR100');
INSERT INTO `Honda` VALUES(17, 'XR200');
INSERT INTO `Honda` VALUES(18, 'XR250');
INSERT INTO `Honda` VALUES(19, 'XR400');
INSERT INTO `Honda` VALUES(20, 'XR50');
INSERT INTO `Honda` VALUES(21, 'XR70');
INSERT INTO `Honda` VALUES(22, 'XR80');

Anyway I still need to figure out how to have this under a form that a user can use to select the bike they want to submit information about. A code like this perhaps?:


<?
$connection = mysql_connect("localhost","user","pass");
$fields = mysql_list_fields("dbname", "table", $connection);
$columns = mysql_num_fields($fields);
echo "<form action=page_to_post_to.php method=POST><select name=Field>";
for ($i = 0; $i < $columns; $i++) {
echo "<option value=$i>";
echo mysql_field_name($fields, $i);
}
echo "</select></form>";
?>


Thanks.

Hi all

I need to combine these two scripts:

Firstly, the following decides which out of the following list is selected based on its value in the mySQL table:

<select name="pack_choice">
<option value="Meters / Pack"<?php echo (($result['pack_choice']=="Meters / Pack") ? ' selected="selected"':'') ?>>Meters / Pack (m2)</option>
<option value="m3"<?php echo (($result['pack_choice']=="m3") ? ' selected="selected"':'') ?>>Meters / Pack (m3)</option>
<option value="Quantity"<?php echo (($result['pack_choice']=="Quantity") ? ' selected="selected"':'') ?>>Quantity</option>
</select>

Although this works OK, I need it also to show dynamic values like this:

select name="category">
<?php
$listCategories=mysql_query("SELECT * FROM `product_categories` ORDER BY id ASC");
while($categoryReturned=mysql_fetch_array($listCategories)) {
echo "<option value=\"".$categoryReturned['name']."\">".$categoryReturned['name']."</option>";
}
?>
</select>

I'm not sure if this is possible?

Many thanks for your help.

Pete

I'm trying to set it so that it will delete an entire populated directory based upon a value in the database then after finishing that to go back and delete that row in the database.  my current code is

Code: [Select]
<?php $page_title = "Central Valley LLC | Photo Addition" ?>
<?php include("header.php"); ?>
<?php include("nav.html"); ?>
<div id="content">
<form action="delprod.php" method="post" enctype="multipart/form-data">
<label for="which">Choose A Product To Remove:</label>
<?php $con = mysql_connect("localhost","phoenixi_cv","centraladmin");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("phoenixi_cvproducts", $con);
$result = mysql_query("SELECT * FROM Products");
echo "<select name=\"which\">";
while($row = mysql_fetch_array($result))
   {
echo "<option ";
echo "value=\"" . $row['id'] . "\">";
echo $row['Name'] . "</option>";
}
echo "</select>";
mysql_close($con);
?>
<br />
<input type="submit" name="submit" value="Submit" />
</form>
</div><!--#content-->
<?php include("footer.html") ?>

and the delete script

Code: [Select]
<?php
$con = mysql_connect("localhost","phoenixi_cv","centraladmin");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("phoenixi_cvproducts", $con);
$result = mysql_query("SELECT id FROM Products WHERE id=$_POST['which']");
$row = mysql_fetch_array($result)


chdir('assets');
chdir('images');
$mydir = $row . '/';
$d = dir($mydir);
while($entry = $d->read())
{
if($entry!="." && $entry!="..")
{
unlink($_POST['which'] . '/' . $entry);
}
}
rmdir($mydir);
$result = mysql_query("DELETE * FROM Producs WHERE id=$_POST['which']");
?>
Thank you in advance for all your help.  any easier ways of approaching this will be welcome as well