Page 1 of 1

Can Someone Help me about add in database?

Posted: Mon Jun 22, 2009 2:28 am
by reza01
Hello...

We have a program that it works with one row(p1-->group-->sub_group) that it work correctly.
now we want change it. it's output: ($ad_sub_groups).


we want add another row in this program that it will have(p2-->group-->sub_group2).
how we can change it that it works correctly? that it's output be: ($ad_sub_groups).

for guide:
sub_group take this array:
valid_arr[1] = document.newad.sub_group.value;


we want add this variable ($ad_sub_groups2) to our database table.

and we want insert an id in the dataBase tables for each sub_groups.

Code: Select all

 
<head>
<style type="text/css">
table{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
input{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
select{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
</style>
</head>
 
<?php
  include("../config.php");
  include("../jdf.php");
 
  mysql_connect($db_server, $db_username, $db_password);
  mysql_select_db($db_name);
 
  $authorized = 1;
  if ($authorized)
    {
    $ad_groups = get_groups2();
    $ad_sub_groups = get_sub_groups();
 // $ad_sub_groups2 = ???????????????? i don now how fille it.
    $durations = get_durations();
    }
  else
    header("location:login.php");
 
  function check_authorization()
  {
    session_start();
    if (isset($_SESSION['uname']) && isset($_SESSION['upass']))
      return true;
    else
      return false;
  }
 
 function get_groups()
  {
    $query = "SELECT * FROM groups";
    $result = mysql_query($query);
 
    $groups_html = "";
    while (($row = mysql_fetch_array($result)))    
      {
      $name = $row['Name'];
      $id   = $row['ID'];
      $groups_html .= "<a href=\"../main_group.php?id=$id\"><img src=\%22../images/fbrows4R.gif\">&nbsp;$name</a><br>";
      }
 
    return $groups_html;
  }
 
  function get_groups2()
  {
    $query = "SELECT * FROM groups WHERE ParentID=0";
    $result = mysql_query($query);
 
    $groups_html = "";
    while (($row = mysql_fetch_array($result)))    
      {
      $name = $row['Name'];
      $id   = $row['ID'];
      $groups_html .= "<option value=\"$id\">$name</option>";
      }
 
    return $groups_html;
  }
 
  function get_sub_groups()
  {
    $query = "SELECT * FROM groups WHERE ParentID=0";
    $result = mysql_query($query);    
    if (mysql_num_rows($result))
      {
      $row = mysql_fetch_array($result);
      $pid = $row['ID'];
      }
 
    $query = "SELECT * FROM groups WHERE ParentID=$pid";
    $result = mysql_query($query);
 
    $groups_html = "";
    while (($row = mysql_fetch_array($result)))    
      {
      $name = $row['Name'];
      $id   = $row['ID'];
      $groups_html .= "<option value=\"$id\">$name</option>";
      }
 
    return $groups_html;
  }
 
  
 
 
?>
 
<script type="text/javascript">
 
  function get_sub_groups(group)
  {
    document.newad.sub_group.options.length = 0;
    jsel = document.createElement('script');
    jsel.type = "text/javascript";
    jsel.src = "get_sub_groups.php?grp=" + group;
    document.body.appendChild(jsel);
  }
 
 
  function validate()
  {
    valid_arr = new Array(3);
 
    valid_arr[0]  = document.newad.group.value;
    valid_arr[1]  = document.newad.sub_group.value;
    valid_arr[2]  = document.newad.sub_group2.value;
  
 for (i=0; i<3; i++)
      if (valid_arr[i] == "")
        {
        isvalid = false;
        alert("erroe.");
        return false;
        }
 
    return true;
  }
 
</script>
 
                </body>
 
                <table style="width: 100%">
                    <tr>
                        <td style="width: 121px">
        &nbsp;</td>
                        <td style="width: 1384px">
        &nbsp;</td>
                    </tr>
                    <tr>
        <span lang="en-us">
                        <td style="width: 121px" class="style13"><strong>
                        <span lang="en-us">p</span> 
                        1</strong></td>
        </span>
                        <td style="width: 1384px">
        <span lang="en-us">
                        &nbsp;&nbsp;&nbsp;
                            <input type="text" style="width: 50px" name="title" size="20"> 
        group:&nbsp;
                            <select name="group" onchange="get_sub_groups(this.value)">
                                <?php echo $ad_groups; ?>
                            </select>&nbsp;sub_group:
                            <select name="sub_group">
                                <?php echo $ad_sub_groups; ?>
                            </select></span>&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;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </td>
                    </tr>
        <span lang="en-us">
                    <tr>
                        <td style="width: 121px" class="style14"><strong>
                        <span lang="en-us">p</span> 
                        2</strong></td>
                        <td style="width: 1384px">
        <span lang="en-us">
                        &nbsp;</span>&nbsp;&nbsp; <span lang="en-us">
                            <input type="text" style="width: 50px" name="title2" size="20"> 
        group:&nbsp;
                            <select name="group0" onchange="get_sub_groups(this.value)">
                                <?php echo $ad_groups; ?>
                            </select>&nbsp;sub_group:
                            <select name="sub_group0">
                                <?php echo $ad_sub_groups; ?>
                            </select></span>&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;&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; </td>
                            &nbsp;</table>
        </span></html>