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> |
#2
|
|||
|
|||
RE: Can Someone Help me about add in database?
What program's code do you keep posting here? This code is NOT from any of our products and thus is not supported here.
|
|
|
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? |