Home Community Mys-Script Creative Off-Topic |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can Someone Help me about add in database?
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:
<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\"> $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"> </td> <td style="width: 1384px"> </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"> <input type="text" style="width: 50px" name="title" size="20"> group: <select name="group" onchange="get_sub_groups(this.value)"> <?php echo $ad_groups; ?> </select> sub_group: <select name="sub_group"> <?php echo $ad_sub_groups; ?> </select></span> </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"> </span> <span lang="en-us"> <input type="text" style="width: 50px" name="title2" size="20"> group: <select name="group0" onchange="get_sub_groups(this.value)"> <?php echo $ad_groups; ?> </select> sub_group: <select name="sub_group0"> <?php echo $ad_sub_groups; ?> </select></span> </td> </table> </span></html> |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Database functions? | Infernette | Questions and Supports | 8 | 07-10-2013 12:13 PM |
Database | SilverDragonTears | Questions and Supports | 1 | 11-01-2012 10:33 AM |
No tables in database? | Fangs | Questions and Supports | 1 | 02-28-2012 11:26 AM |
Need help with MySQL Database | MirandaLK | Questions and Supports | 13 | 07-29-2010 09:01 PM |
Database help | Weretemplar | Questions and Supports | 20 | 01-01-2009 03:19 PM |
What's New? |
What's Hot? |
What's Popular? |