[Help] Problem with my PHP Script

[Darkco]

Hi,

I have tried to make a php script to change something in sql.

When I try to run it in internet browser I see this error:

My Error

Parse error: parse error, unexpected T_ELSE in C:\AppServ\www\travia\travia_do_account.php on line 44

My Travia_Config.php:

<?
//MSSQL settings
$user = 'MYUSERHERE';
$haslo = 'MYPASSWORDHERE';
$nazwabazy = "Game";
$hostbazy = "localhost";
?>

My travia_do_account.php:

<?php
include 'travia_config.php';
$tabelka = '<table>
<form action=travia_do_account.php method=post>
<tr><td>Charname</td><td><input type=text name=login value="'.$_POST['login'].'"></td></tr>
<tr><td>Class</td><td><input type=text name=pass></td></tr>
<tr><td><input type=submit value="Change Job"></td><td><input type=reset value="Clear fields"></td></tr>
</form>
</table>';

if($reg_open AND isset($_POST['login']))
{
$conn=@mssql_connect($hostbazy,$user,$haslo) or die("<b>Critical Error</b><br>MSSQL server is offline OR I can't Access to it !");
@mssql_select_db($nazwabazy, $conn) or die("<b>Critical Error</b><br>Database don't exists OR I can't Access to it !");

$login = $_POST['login'];
$pw = $_POST['pass'];

$login = trim($login);
$pw = trim($pw);

if(ereg("[^0-9a-zA-Z_-]", $login))
	{
	echo 'Please do use only 0-9 a-Z';
	echo '<br>'.$tabelka;
	}
elseif (ereg("[^0-9a-zA-Z_-]", $pw))
	{
	echo 'Please do use only 0-9 a-Z';
	echo '<br>'.$tabelka;
	}
elseif (empty($login) || empty($pw))
	{
	echo 'Please do use only 0-9 a-Z<br>'.$tabelka;
	}
else
	{
	$resultx = mssql_query("SELECT LOWER(UT_USERID) FROM CHARTABLE 
	WHERE LOWER(UT_USERID) = ('$login')") or die;
		}
		{
		echo 'No valed charname<br>'.$tabelka;
		}
	else 
		{
		mssql_query("INSERT INTO CHARTABLE (UT_USERID,CT_CLASS) VALUES ('".$login."','".$pw."',convert(binary,'".$login."');
		echo "Job Is Changed Succesfully";
		}
	}
?>
<BR>
<a><b>Created By: Darkco</b></a>
</BR>

My MSSQL Query script works fine Now I want this in PHP:

USE Game

UPDATE CHARTABLE
SET CT_CLASS = NUMBERHERE
WHERE ( CT_USERID = 'CHARNAMEHERE' )

Please help me

Thanks....

 

[Aidamina]

the line below these:
WHERE LOWER(UT_USERID) = ('$login')") or die;
}

You should add an if or something like that,
You open a codeblock there with {}
without some kind of expression and after that codeblock you use else,
how can the compiler guess what you want todo?

 

[Darkco]

now i got:

Parse error: parse error, unexpected T_STRING in C:\AppServ\www\travia\travia_do_account.php on line 46

 

[juice-drink]

now i got:

Parse error: parse error, unexpected T_STRING in C:\AppServ\www\travia\travia_do_account.php on line 46

What did you done? please put here the code for this new error

 

[Darkco]

WHERE LOWER(UT_USERID) = ('$login') or die;

I maked this of that line... then i got this error:

Parse error: parse error, unexpected T_STRING in C:\AppServ\www\travia\travia_do_account.php on line 46

 

[[N]asser]

Do you ppl know that there's a

 tag to highlight your code and make it a heck of alot easier to read?

[N]asser` ~ Out

 

[FragFrog]

Replace

else
	{
	$resultx = mssql_query("SELECT LOWER(UT_USERID) FROM CHARTABLE 
	WHERE LOWER(UT_USERID) = ('$login')") or die;
		}
		{
		echo 'No valed charname<br>'.$tabelka;
		}
	else 
		{
		mssql_query("INSERT INTO CHARTABLE (UT_USERID,CT_CLASS) VALUES ('".$login."','".$pw."',convert(binary,'".$login."');
		echo "Job Is Changed Succesfully";
		}
	}

With

else  {
  $resultx = mssql_query("SELECT LOWER(UT_USERID) FROM CHARTABLE 
                 WHERE LOWER(UT_USERID) = ('$login')") or die;
  if(mssql_num_rows($resultx) > 0)
	echo 'No valed charname<br>'.$tabelka;
  else  {
    $query = mssql_query("INSERT INTO CHARTABLE (UT_USERID,CT_CLASS) VALUES ('$login', '$pw', convert(binary,'$login'))");
  echo "Job Is Changed Succesfully";
  }
}