<?php
$host="localhost"; // Host name
$username=""; // Mysql username
$userpassword=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="adduser"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$userpassword")or die("Cannot connect to the Data Base");
mysql_select_db("$db_name")or die("Cannot select DB");


$sql="select concat(left(firstname,1),lastname) as username from adduser order by firstname;";
$result=mysql_query($sql)or die(mysql_error());

?>
<select size ="10" name="seluser" style="width:150" class=NormalFont>

            <option value="0">-Select User from List-</option>            
            <?php
            while ($row = mysql_fetch_array($result)) {
                //$count=mysql_num_rows($result);
               $username = $row["username"];
            ?>                  

                        <option value><?php echo "$username";?>
            <?php
            }
            ?>
            </option>

                  

                  </select>
<input type="submit" class="NormalButton"  value=" Delete " onClick="doSubmit(deluser)" id=button1 name=button1>

                 <input type="button" class="NormalButton" value=" Cancel " onClick="java script:location.href = './users.php'" id=button2 name=button2>

<script language="javascript">

  

  function doSubmit(frm)

  {

     if (deluser.seluser.selectedIndex < 0 )

     {

        alert("Select a User to delete");

     }

     else

     {

        frm.flag.value = 1;

        frm.action = "./userlist.php";

        //frm.submit();

        callVBconfirm()

     }    

  }

function nextPage()

{

     deluser.flag.value = 1;

     deluser.action = "./userlist.php";

     deluser.submit();

}  

</script>



<script language="VBScript">

function callVBconfirm()

ans = MsgBox("Are you sure want to delete this user account?",vbYesNo)

if (ans=6) then

nextPage()

end if

end function    

</script>