pleas help me.
i have some question about this code.
we have a program that it works with one row(p1-->group-->sub_group) that it work corectly.
now we want chnge it.
we want add 4 row in to this program that it will have(p2,3,4,5-->group-->sub_group).
we changed it but it dident work corectly.
and we want insert a id in the data bais tables for ech sub_groups.
Code: Select all
<?php
include("../config.php");
include("../jdf.php");
mysql_connect($db_server, $db_username, $db_password);
mysql_select_db($db_name);
$query = "SET NAMES 'utf8'";
mysql_query($query);
$query = "SELECT * FROM settings";
$result = mysql_query($query);
if (mysql_num_rows($result))
{
$row = mysql_fetch_array($result);
$site_name = $row['SiteName'];
$side_bar = $row['SideBar'];
}
$today = jdate("l");
$today .= " " . jdate("y/m/d");
$groups = get_groups();
$authorized = 1;
if ($authorized)
{
$ad_groups = get_groups2();
$ad_sub_groups = get_sub_groups();
$ad_types = get_types();
$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;
}
function get_types()
{
$query = "SELECT * FROM adtypes";
$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_durations()
{
$query = "SELECT * FROM durations";
$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;
}
?>
<html dir='ltr' xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"><header><META NAME='distribution' CONTENT=''> <meta http-equiv='Content-Language' content='fa'><meta http-equiv='Content-Type' content='text/html; charset=utf-8'><meta name='Author' content='Hadi Fanaee'><META NAME='robots' CONTENT='index, follow'><META NAME='revisit-after' CONTENT='1 days'><style>body{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma ;background-color:#FFFFFF;color:#llllll}
index_body{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma ;background-color:#FFFFFF;background-image:url('../images/00000000.txt')}
input{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
select{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
textarea{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
table{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
A:hover {COLOR: #FF0000; TEXT-DECORATION: none}
A { COLOR: #00008b; TEXT-DECORATION: none}
.text_small { font-size: 10px }
.text_big { font-size: 14pt }
.index_main{border-collapse: collapse; font-size: 10pt ; background-color:#FFFFFF;background-image:url('../images/bkpic000.gif'); color:#llllll}
.index_table{border-collapse: collapse; font-size:10pt ; background-color:#F0F0F0; color:}
.index_table_inner{border-collapse: collapse; font-size:10pt ;color:}
.index_table_title{color:; font-size:10pt ; text-align:center}
.button1{font-family: Tahoma; font-size: 10pt ; color: }
.input1{font-family: Tahoma; font-size: 10pt ; color: }
.index_table_button{font-family: Tahoma; font-size: 10pt ; color: }
.index_table_input{font-family: Tahoma; font-size: 10pt ; color: }
.index_header{color:; font-size:10pt ; text-align:center}
.index_menubar{background-image: url('../images/tmenubar.gif'); color:#384EA0; font-size:10pt ; text-align:center}
.text2 { color:#00008b }
.text3 { color:#0000ff }
.text4 { }
.hr{color:#0066CC}
.tblheaderbg{background-color:#F0F0F0;}
.tblheader{border:1px solid #F0F0F0; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma}
.block_title{color:#480580; font-size:10px ; text-align:Center}
.style13 {
background-color: #e20a19;
text-align: center;
color: #FFFFFF;
}
.style14 {
background-color: #018232;
text-align: center;
color: #FFFFFF;
}
.style15 {
background-color: #fc4e1b;
text-align: center;
color: #FFFFFF;
}
.style16 {
background-color: #0001fe;
color: #FFFFFF;
text-align: center;
}
.style17 {
background-color: #650103;
color: #FFFFFF;
text-align: center;
}
</style>
<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 calc_price()
{
type = document.newad.type.value;
duration = document.newad.duration.value;
stars = document.newad.stars.value;
jsel = document.createElement('script');
jsel.type = "text/javascript";
jsel.src = "calc_price.php?";
jsel.src += "type=" + type;
jsel.src += "duration=" + duration;
jsel.src += "stars=" + stars;
document.appendChild(jsel);
}
function validate()
{
valid_arr = new Array(6);
valid_arr[0] = document.newad.group.value;
valid_arr[1] = document.newad.sub_group.value;
valid_arr[2] = document.newad.sub_group2.value;
valid_arr[3] = document.newad.sub_group3.value;
valid_arr[4] = document.newad.sub_group4.value;
valid_arr[5] = document.newad.sub_group5.value;
for (i=0; i<6; i++)
if (valid_arr[i] == "")
{
isvalid = false;
alert("?? ???? ????? ?????? ?????? ???.");
return false;
}
return true;
}
</script>
<body onresize='buildsubmenus_horizontal();buildsubmenus()' background='../images/bg000000.gif' leftmargin='0' topmargin='0'><script language='JavaScript' src='../images/farsi000.js'></script><meta http-equiv='Content-Type' content='text/html; charset=utf-8'>
<link rel="stylesheet" type="text/css" href="../images/style000.css">
<div style="width: 980px; float: right;" dir="rtl">
<div align='center'><table dir='rtl' border='0' cellpadding='0' cellspacing='0' width='100%' class='index_main'><td width='4' valign='top'></td><td width='10' valign='top'></td><td dir='rtl' background='../images/bkpic000.gif' width='99%' class='index_main' align=center valign='top'><div align=center><table border='0' cellpadding='0' cellspacing='0' class='index_main' width='98%'><tr><td height='6' width='100%'></tr><tr><td width='100%'><title>...???? ????? ??????? ???????? ?????? ... </title><link rel='stylesheet' type='text/css' href='../images/style000.css'><DIV style="MARGIN-TOP: 3px; FLOAT: left; WIDTH: 100%">
<TABLE class=picc cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
</TR></TBODY></TABLE>
</div>
<form name="newad" method="post" action="add_new_ad.php" onsubmit="return validate()">
<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>
</tr>
<tr>
<td style="width: 121px; height: 29px;" class="style15">
<strong><span lang="en-us">p</span> 3</strong></td>
<td style="width: 1384px">
<span lang="en-us">
<input type="text" style="width: 50px" name="title3" size="20"> group:
<select name="group1" onchange="get_sub_groups(this.value)">
<?php echo $ad_groups; ?>
</select> sub_group:
<select name="sub_group1">
<?php echo $ad_sub_groups; ?>
</select></span> </td>
</tr>
<tr>
<td style="width: 121px" class="style16"><strong>
<span lang="en-us">p</span>
4</strong></td>
<td style="width: 1384px">
<span lang="en-us">
</span> <span lang="en-us"><input type="text" style="width: 50px" name="title4" size="20"> group:</span> <span lang="en-us"> <select name="group2" onchange="get_sub_groups(this.value)">
<?php echo $ad_groups; ?>
</select> sub_group:
<select name="sub_group2">
<?php echo $ad_sub_groups; ?>
</select></span>
</td>
</tr>
<tr>
<td style="width: 121px" class="style17"><strong>
<span lang="en-us">p</span>
5</strong></td>
<td style="width: 1384px">
<span lang="en-us">
</span> <span lang="en-us">
<input type="text" style="width: 50px" name="title5" size="20"></span>
<span lang="en-us">
group:</span> <span lang="en-us"> <select name="group3" onchange="get_sub_groups(this.value)">
<?php echo $ad_groups; ?>
</select> sub_group
<select name="sub_group3">
<?php echo $ad_sub_groups; ?>
</select></span>
</table>
</form>
</span></td></tr></table></div></td><td width='4' valign='top'></td></tr></table></center></div>
</body></html>
tanks.