reza01
06-20-2009, 04:25 AM
hi
i am a beginner in php.
i have problem with some codes.
In PHP new_ad.php and add_new_ad.php ther is some information
like( sub_group.sub_group2.sub_group3.sub_group4.sub_gro up5.title.
title2.title3.title4.title5.descr.text.name.tel.Ci ty.address.type.duration)
that i inserted them in new_add.php, but they don't inserted in to phpMyAdmin and Database.
new_ad.php:
<?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=1)
{
$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(18);
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;
valid_arr[6] = document.newad.title.value;
valid_arr[7] = document.newad.title2.value;
valid_arr[8] = document.newad.title3.value;
valid_arr[9] = document.newad.title4.value;
valid_arr[10] = document.newad.title5.value;
valid_arr[11] = document.newad.descr.value;
valid_arr[12] = document.newad.text.value;
valid_arr[13] = document.newad.name.value;
valid_arr[14] = document.newad.tel.value;
valid_arr[15] = document.newad.City.value;
valid_arr[16] = document.newad.address.value;
valid_arr[17] = document.newad.type.value;
valid_arr[18] = document.newad.duration.value;
valid_arr[19] = document.newad.link.value;
for (i=0; i<18; i++)
if (valid_arr[i] == "")
{
isvalid = false;
alert("file all");
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 bgcolor='#FFFFFF' width='150' 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>
<TD class=ghd colSpan="4"> <span lang="en-us">insert new</span></TD></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: 308px" 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>
<input name="Button1" type="button" value="product"></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: 308px" 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> <span lang="en-us">
<input name="Button2" type="button" value="product"></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: 308px" 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> <span lang="en-us">
<input name="Button3" type="button" value="product"></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: 308px" 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>
<span lang="en-us">
<input name="Button4" type="button" value="product"></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: 308px" 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>
<span lang="en-us">
<input name="Button5" type="button" value="product"></span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"><span lang="en-us">announce
text</span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"><span lang="en-us">
<textarea name="text" style="height: 175px; width: 365px" rows="1" cols="20"></textarea>
</span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> <span lang="en-us">name:</span>
<span lang="en-us">
<input type="text" style="width: 300px" name="name" size="20"></span> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> :
<span lang="en-us">
<input type="text" style="width: 300px" name="descr" size="20"></span>
</td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"><span lang="en-us">tel</span>: <span lang="en-us">
<input type="text" style="width: 300px" name="tel" size="20"></span></td>
</tr>
<tr>
<td style="width: 121px; height: 39px;"></td>
<td style="width: 1384px; height: 39px;"></td>
</tr>
<tr>
<td style="height: 26px; width: 121px;"> </td>
<td style="height: 26px; width: 1384px;">
<span lang="en-us">city</span>: <span lang="en-us">
<input type="text" style="width: 300px" name="city" size="20"></span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="height: 16px; width: 121px;"> </td>
<td style="height: 16px; width: 1384px;">
Address:
<span lang="en-us">
<input type="text" style="width: 300px" name="address" size="20"></span></td>
</tr>
<tr>
<td style="height: 16px; width: 121px;"> </td>
<td style="height: 16px; width: 1384px;"> </td>
</tr>
<tr>
<td style="height: 16px; width: 121px;"> </td>
<td style="height: 16px; width: 1384px;">
<span lang="en-us">link</span>:<span lang="en-us"><input type="text" style="width: 300px" name="link" size="20">//:http</span></td>
</tr>
<tr>
<td style="height: 16px; width: 121px;"> </td>
<td style="height: 16px; width: 1384px;"> </td>
</tr>
<tr>
<td style="height: 26px; width: 121px;"> </td>
<td style="height: 26px; width: 1384px;">
<span lang="en-us">type</span>: <span lang="en-us">
</span> <span lang="en-us">
<select name="type" onclick="calc_price()">
<option selected="" value="free">free</option>
<option value="express">??????</option>
</select>
</span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px">Duration:
<span lang="en-us">
<select name="duration" onclick="calc_price()">
<?php echo $durations; ?>
</select>
</span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px">Stars: <span lang="en-us">
<select name="stars" style="width: 32px" onclick="calc_price()">
<option>0</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
</select></span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"><span lang="en-us">
<input type="submit" value="send">
</span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
</table>
</form>
</span><td width='10' valign='top'></td></td></tr></table></div></td><td bgcolor='#FFFFFF' width='150' valign='top' align=center><p align=center></td><td width='4' valign='top'></td></tr></table></center></div>
</body></html>
add_new_ad.php:
<?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 = check_authorization();
if ($authorized)
{
$title = "";
$text = "";
add_new_ad();
}
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 add_new_ad()
{
$group = $_POST['group'];
$sub_group = $_POST['sub_group'];
$sub_group2 = $_POST['sub_group2'];
$sub_group3 = $_POST['sub_group3'];
$sub_group4 = $_POST['sub_group4'];
$sub_group5 = $_POST['sub_group5'];
$title = trim($_POST['title']);
$title2 = trim($_POST['title2']);
$title3 = trim($_POST['title3']);
$title4 = trim($_POST['title4']);
$title5 = trim($_POST['title5']);
$title5 = trim($_POST['title5']);
$descr = trim($_POST['descr']);
$text = $_POST['text'];
$name = $_POST['name'];
$tel = $_POST['tel'];
$city = $_POST['city'];
$address = $_POST['address'];
$type = $_POST['type'];
$duration = $_POST['duration'];
$link = $_POST['link'];
$stars = $_POST['stars'];
$uname = $_SESSION['uname'];
$price = calc_price();
$date = jdate("ymd");
$query = "SELECT Balance, ID FROM users WHERE Username='$uname'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$balance = $row['Balance'];
if ($price > $balance)
{
$GLOBALS['msg'] = "??? ?????? ???? ???? ??? ??? ???? ??????.";
return;
}
else
{
$userid = $row['ID'];
$query = "INSERT INTO ads ('ID', 'UserID', 'GroupID', 'GroupID2', 'GroupID3', 'GroupID4', 'GroupID5', 'Title', 'Title2', 'Title3', 'Title4', 'Title5', 'Descr', 'Text', 'Name','Email','Tel','City' , 'Address', 'Type', 'Duration', 'Date','ExpireDate','SpecialFrom','Stars' ,'Status','Views','Image','mode','Link') ";
$query .= "VALUES (NULL,'$userid', '$sub_group', '$sub_group2', '$sub_group3', '$sub_group4', '$sub_group5', '$title','$title2','$title3','$title4','$title5',' $descr', '$text', '$name', $tel , $City , $address ,'$type', '$duration', '$date', NULL ,'$stars', '1', 0 , NULL , 1 , $link )";
mysql_query($query);
$GLOBALS['title'] = $title;
$GLOBALS['text'] = $text;
$GLOBALS['text'] = str_replace("\n", "<br>", $GLOBALS['text']);
$GLOBALS['msg'] = "Registered your announce";
}
}
function calc_price()
{
$type = $_POST['type'];
$duration = $_POST['duration'];
$stars = $_POST['stars'];
$price = 0;
$query = "SELECT Fee FROM durations WHERE AdType=$type and ID=$duration";
$result = mysql_query($query);
if (mysql_num_rows($result))
{
$row = mysql_fetch_array($result);
$price = $row['Fee'];
}
$query = "SELECT Fee FROM stars WHERE Star=$stars";
$result = mysql_query($query);
if (mysql_num_rows($result))
{
$row = mysql_fetch_array($result);
$price += $row['Fee'];
}
return $price;
}
?>
<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}
.style7 {
color: #FF0000;
}
</style>
<script type="text/javascript">
<?php echo $js; ?>
</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 bgcolor='#FFFFFF' width='150' 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>
<TD class=ghd colSpan="4">users control panel</TD></TR></TBODY></TABLE>
<table style="width: 100%">
<tr>
<td> </td>
</tr>
<tr>
<td class="style7"><span lang="en-us"><?php echo $msg; ?></span></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><span lang="en-us">
<font color="red"><?php echo $title; ?></font>
</span></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><span lang="en-us">
<?php echo $text; ?>
</span></td>
</tr>
</table>
</div>
<td width='10' valign='top'></td></td></tr></table></div></td><td bgcolor='#FFFFFF' width='150' valign='top' align=center><p align=center></td><td width='4' valign='top'></td></tr></table></center></div>
</body></html>
my field in the ads table is the same as:
('ID','UserID','GroupID','GroupID2','GroupID3','Gr oupID4','GroupID5',
'Title','Title2','Title3','Title4','Title5','Descr ','Text','Name','Email'
,'Tel','City','Address','Type','Duration','Date',' ExpireDate','SpecialFrom'
,'Stars','Status','Views','Image','mode','Link').
I will be glad if you answer.
tanks.
i am a beginner in php.
i have problem with some codes.
In PHP new_ad.php and add_new_ad.php ther is some information
like( sub_group.sub_group2.sub_group3.sub_group4.sub_gro up5.title.
title2.title3.title4.title5.descr.text.name.tel.Ci ty.address.type.duration)
that i inserted them in new_add.php, but they don't inserted in to phpMyAdmin and Database.
new_ad.php:
<?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=1)
{
$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(18);
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;
valid_arr[6] = document.newad.title.value;
valid_arr[7] = document.newad.title2.value;
valid_arr[8] = document.newad.title3.value;
valid_arr[9] = document.newad.title4.value;
valid_arr[10] = document.newad.title5.value;
valid_arr[11] = document.newad.descr.value;
valid_arr[12] = document.newad.text.value;
valid_arr[13] = document.newad.name.value;
valid_arr[14] = document.newad.tel.value;
valid_arr[15] = document.newad.City.value;
valid_arr[16] = document.newad.address.value;
valid_arr[17] = document.newad.type.value;
valid_arr[18] = document.newad.duration.value;
valid_arr[19] = document.newad.link.value;
for (i=0; i<18; i++)
if (valid_arr[i] == "")
{
isvalid = false;
alert("file all");
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 bgcolor='#FFFFFF' width='150' 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>
<TD class=ghd colSpan="4"> <span lang="en-us">insert new</span></TD></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: 308px" 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>
<input name="Button1" type="button" value="product"></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: 308px" 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> <span lang="en-us">
<input name="Button2" type="button" value="product"></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: 308px" 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> <span lang="en-us">
<input name="Button3" type="button" value="product"></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: 308px" 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>
<span lang="en-us">
<input name="Button4" type="button" value="product"></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: 308px" 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>
<span lang="en-us">
<input name="Button5" type="button" value="product"></span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"><span lang="en-us">announce
text</span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"><span lang="en-us">
<textarea name="text" style="height: 175px; width: 365px" rows="1" cols="20"></textarea>
</span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> <span lang="en-us">name:</span>
<span lang="en-us">
<input type="text" style="width: 300px" name="name" size="20"></span> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> :
<span lang="en-us">
<input type="text" style="width: 300px" name="descr" size="20"></span>
</td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"><span lang="en-us">tel</span>: <span lang="en-us">
<input type="text" style="width: 300px" name="tel" size="20"></span></td>
</tr>
<tr>
<td style="width: 121px; height: 39px;"></td>
<td style="width: 1384px; height: 39px;"></td>
</tr>
<tr>
<td style="height: 26px; width: 121px;"> </td>
<td style="height: 26px; width: 1384px;">
<span lang="en-us">city</span>: <span lang="en-us">
<input type="text" style="width: 300px" name="city" size="20"></span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="height: 16px; width: 121px;"> </td>
<td style="height: 16px; width: 1384px;">
Address:
<span lang="en-us">
<input type="text" style="width: 300px" name="address" size="20"></span></td>
</tr>
<tr>
<td style="height: 16px; width: 121px;"> </td>
<td style="height: 16px; width: 1384px;"> </td>
</tr>
<tr>
<td style="height: 16px; width: 121px;"> </td>
<td style="height: 16px; width: 1384px;">
<span lang="en-us">link</span>:<span lang="en-us"><input type="text" style="width: 300px" name="link" size="20">//:http</span></td>
</tr>
<tr>
<td style="height: 16px; width: 121px;"> </td>
<td style="height: 16px; width: 1384px;"> </td>
</tr>
<tr>
<td style="height: 26px; width: 121px;"> </td>
<td style="height: 26px; width: 1384px;">
<span lang="en-us">type</span>: <span lang="en-us">
</span> <span lang="en-us">
<select name="type" onclick="calc_price()">
<option selected="" value="free">free</option>
<option value="express">??????</option>
</select>
</span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px">Duration:
<span lang="en-us">
<select name="duration" onclick="calc_price()">
<?php echo $durations; ?>
</select>
</span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px">Stars: <span lang="en-us">
<select name="stars" style="width: 32px" onclick="calc_price()">
<option>0</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
</select></span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"><span lang="en-us">
<input type="submit" value="send">
</span></td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
<tr>
<td style="width: 121px"> </td>
<td style="width: 1384px"> </td>
</tr>
</table>
</form>
</span><td width='10' valign='top'></td></td></tr></table></div></td><td bgcolor='#FFFFFF' width='150' valign='top' align=center><p align=center></td><td width='4' valign='top'></td></tr></table></center></div>
</body></html>
add_new_ad.php:
<?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 = check_authorization();
if ($authorized)
{
$title = "";
$text = "";
add_new_ad();
}
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 add_new_ad()
{
$group = $_POST['group'];
$sub_group = $_POST['sub_group'];
$sub_group2 = $_POST['sub_group2'];
$sub_group3 = $_POST['sub_group3'];
$sub_group4 = $_POST['sub_group4'];
$sub_group5 = $_POST['sub_group5'];
$title = trim($_POST['title']);
$title2 = trim($_POST['title2']);
$title3 = trim($_POST['title3']);
$title4 = trim($_POST['title4']);
$title5 = trim($_POST['title5']);
$title5 = trim($_POST['title5']);
$descr = trim($_POST['descr']);
$text = $_POST['text'];
$name = $_POST['name'];
$tel = $_POST['tel'];
$city = $_POST['city'];
$address = $_POST['address'];
$type = $_POST['type'];
$duration = $_POST['duration'];
$link = $_POST['link'];
$stars = $_POST['stars'];
$uname = $_SESSION['uname'];
$price = calc_price();
$date = jdate("ymd");
$query = "SELECT Balance, ID FROM users WHERE Username='$uname'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$balance = $row['Balance'];
if ($price > $balance)
{
$GLOBALS['msg'] = "??? ?????? ???? ???? ??? ??? ???? ??????.";
return;
}
else
{
$userid = $row['ID'];
$query = "INSERT INTO ads ('ID', 'UserID', 'GroupID', 'GroupID2', 'GroupID3', 'GroupID4', 'GroupID5', 'Title', 'Title2', 'Title3', 'Title4', 'Title5', 'Descr', 'Text', 'Name','Email','Tel','City' , 'Address', 'Type', 'Duration', 'Date','ExpireDate','SpecialFrom','Stars' ,'Status','Views','Image','mode','Link') ";
$query .= "VALUES (NULL,'$userid', '$sub_group', '$sub_group2', '$sub_group3', '$sub_group4', '$sub_group5', '$title','$title2','$title3','$title4','$title5',' $descr', '$text', '$name', $tel , $City , $address ,'$type', '$duration', '$date', NULL ,'$stars', '1', 0 , NULL , 1 , $link )";
mysql_query($query);
$GLOBALS['title'] = $title;
$GLOBALS['text'] = $text;
$GLOBALS['text'] = str_replace("\n", "<br>", $GLOBALS['text']);
$GLOBALS['msg'] = "Registered your announce";
}
}
function calc_price()
{
$type = $_POST['type'];
$duration = $_POST['duration'];
$stars = $_POST['stars'];
$price = 0;
$query = "SELECT Fee FROM durations WHERE AdType=$type and ID=$duration";
$result = mysql_query($query);
if (mysql_num_rows($result))
{
$row = mysql_fetch_array($result);
$price = $row['Fee'];
}
$query = "SELECT Fee FROM stars WHERE Star=$stars";
$result = mysql_query($query);
if (mysql_num_rows($result))
{
$row = mysql_fetch_array($result);
$price += $row['Fee'];
}
return $price;
}
?>
<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}
.style7 {
color: #FF0000;
}
</style>
<script type="text/javascript">
<?php echo $js; ?>
</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 bgcolor='#FFFFFF' width='150' 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>
<TD class=ghd colSpan="4">users control panel</TD></TR></TBODY></TABLE>
<table style="width: 100%">
<tr>
<td> </td>
</tr>
<tr>
<td class="style7"><span lang="en-us"><?php echo $msg; ?></span></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><span lang="en-us">
<font color="red"><?php echo $title; ?></font>
</span></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><span lang="en-us">
<?php echo $text; ?>
</span></td>
</tr>
</table>
</div>
<td width='10' valign='top'></td></td></tr></table></div></td><td bgcolor='#FFFFFF' width='150' valign='top' align=center><p align=center></td><td width='4' valign='top'></td></tr></table></center></div>
</body></html>
my field in the ads table is the same as:
('ID','UserID','GroupID','GroupID2','GroupID3','Gr oupID4','GroupID5',
'Title','Title2','Title3','Title4','Title5','Descr ','Text','Name','Email'
,'Tel','City','Address','Type','Duration','Date',' ExpireDate','SpecialFrom'
,'Stars','Status','Views','Image','mode','Link').
I will be glad if you answer.
tanks.