Unexpected $end on line 17

Apixen

Delete Inventory:

<center><form action='deleteinventory_execute.php' method='post'>
Character:<br />
<input type='text' name='Account' /><br />
<input type='submit' name='Delete' value='Delete' />
</form></center>

Delete Inventory Execute.php

<?php
        $link = @mssql_connect("a", "b", "c") or die ("Server is down!");
        $db = @mssql_select_db('CHARACTER_01_DBF') or die ("Character table is missing!");
$getid = @mssql_query("SELECT m_idPlayer from [CHARACTER_TBL] where m_szName='$character'");
$getvalid = @mssql_fetch_array($getid);
if($getvalid) {
$deleteinventory = @mssql_query("DELETE FROM [INVENTORY_TBL] WHERE m_idPlayer='$getvalid';
}
else {
echo 'Character not found.';
}
if ($deleteinventory) {
echo 'Deleted Succcessfully';
} else {
echo 'Error Processing. Please try again';
}
?>

zypher11

first and foremost... delete your DB connection information from this post before someone decides to truncate your tables and piss you off lol...

and secondly close out $deleteinventory with ")

Apixen

I can't edit my post o-o

laserlight

I have made the edit for you. Anyway, the problem is that you forgot to end your string literal with a double quote on this line:

$deleteinventory = @mssql_query("DELETE FROM [INVENTORY_TBL] WHERE m_idPlayer='$getvalid';

You might want to use a text editor with syntax highlighting as it would allow you to more easily detect these kinds of mistakes. Furthermore, although it is good that you posted code in code tags, it would be even better to post PHP code in [noparse]

[/noparse] bbcode tags. You should also indent your code properly.

Apixen

Thanks for the replies. I appreciate it.

-Apixen

laserlight

You're welcome! If you have no further related questions, please mark this thread as resolved using the thread tools.

Apixen

I have a new problem <.<

<?php
include_once('./includes/config.inc.php');
include_once('./includes/functions.php');
if(@$_SESSION['Account2'])
{
$account = $_POST['Account'];
$block = $_POST['Block'];


$full = mssql_query("SELECT * FROM [ACCOUNT_TBL_DETAIL] WHERE account='$account'");
$num = mssql_num_rows($full);
if($num >= 1) {
$result = mssql_query("UPDATE [ACCOUNT_TBL_DETAIL] set BlockTime='$block' where account='$account'");
if($result)
{
echo 'Banned successfully!';
}
}
else
{
include('gamemaster.php');
}

?>

It's the same error too. But I see NOTHING wrong with my code. It looks completely fine.
It says Unexpected $end on line 24. Any help?

laserlight

You should indent your code properly, e.g.,

<?php
include_once('./includes/config.inc.php');
include_once('./includes/functions.php');
if(@$_SESSION['Account2'])
{
    $account = $_POST['Account'];
    $block = $_POST['Block'];

$full = mssql_query("SELECT * FROM [ACCOUNT_TBL_DETAIL] WHERE account='$account'");
$num = mssql_num_rows($full);
if($num >= 1) {
    $result = mssql_query("UPDATE [ACCOUNT_TBL_DETAIL] set BlockTime='$block' where account='$account'");
    if($result)
    {
        echo 'Banned successfully!';
    }
}
else
{
    include('gamemaster.php');
}

?>

Now, can you see that you have a missing closing brace?

Apixen

Ah, I see now, Thanks.