Защо не ми се изпълнява заявката

U

UmriWe

Registered
Намерих един lightbox и слагам тоя код в него и като цъкнеш "Change Realm" и се появява със тоя код въре. Обаче като си избереш реалм и дадеш "Change Realm" , не става нищо .. Помогнете ..
Код: 
<?php
ob_start();
session_start();
include "include/config.php";
if($_SESSION['username'])
{
if(isset($_POST['changeRealm']))
{
$change_realm = "UPDATE realmd_merged.account SET realm='$_POST[realm]' WHERE username='$_SESSION[username]'";
$change_realm2 = mysql_query($change_realm);
echo "<b><i>Realm has been changed successfully!</i></b>";
}
echo "
<form action='change-realm.php' method='POST'/>
<b>Select Realm:</b><br /><select name='realm'>";
mysql_select_db($sitedb);
$realms = mysql_query("SELECT * FROM icy_realms ORDER BY 'id' ASC");
while($realm_s = MySQL_Fetch_Array($realms)) 
{
echo ("<center><option value='$realm_s[id]'>$realm_s[name]</option>");
}
echo '</select>  <input type="submit" name="changeRealm" value="Change Realm"/></form><br />';

mysql_select_db("realmd_merged", $con);
$selectedr = "SELECT * FROM account WHERE username='$_SESSION[username]'";
$selectedr2 = mysql_query($selectedr) or die (mysql_error());
$selectedr3 = mysql_fetch_array($selectedr2);
$rrealm = $selectedr3['realm'];
if($rrealm == 1)
{
	$realm = "WinterFlames";
}
elseif($rrealm == 2)
{
	$realm = "ThunderDevil (PvP)";
}
elseif($rrealm == 3)
{
	$realm = "Vindicator";
}
echo "<b><i>Current Realm : ".$realm."</b></i><br />";
}
else
{
	echo "<span class='alert'>You must be logged in!</span>";
}
?>
 
Пробвай така

Код: 
	 <?php
ob_start();
session_start();
include "include/config.php";
if($_SESSION['username'])
{
if(isset($_POST['changeRealm']))
{
$change_realm = mysql_query("UPDATE realmd_merged.account SET `realm` = '$_POST[realm]' WHERE `username` = '$_SESSION[username]'") or die(mysql_error());
if ($change_realm)
{
echo "<b><i>Realm has been changed successfully!</i></b>";
}
else
{
echo "<b>Error !</б>";
}
}
echo "
<form action='change-realm.php' method='POST'/>
<b>Select Realm:</b><br /><select name='realm'>";
mysql_select_db($sitedb);
$realms = mysql_query("SELECT * FROM icy_realms ORDER BY 'id' ASC");
while($realm_s = MySQL_Fetch_Array($realms))
{
echo ("<center><option value='$realm_s[id]'>$realm_s[name]</option>");
}
echo '</select>  <input type="submit" name="changeRealm" value="Change Realm"/></form><br />';

mysql_select_db("realmd_merged", $con);
$selectedr = "SELECT * FROM account WHERE username='$_SESSION[username]'";
$selectedr2 = mysql_query($selectedr) or die (mysql_error());
$selectedr3 = mysql_fetch_array($selectedr2);
$rrealm = $selectedr3['realm'];
if($rrealm == 1)
{
   $realm = "WinterFlames";
}
elseif($rrealm == 2)
{
   $realm = "ThunderDevil (PvP)";
}
elseif($rrealm == 3)
{
   $realm = "Vindicator";
}
echo "<b><i>Current Realm : ".$realm."</b></i><br />";
}
else
{
   echo "<span class='alert'>You must be logged in!</span>";
}
?>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе