PowerPanel help please

[Jamieb]

Hey!

When I try change Djsays I get this

Could not execute query error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Boulton'' at line 1

Whats up??

Thanks Jamieb

[Invent]

Post the code.

[Jamieb]

Hello there Invent..

Thanks for your help.. Here is the code..

<?php

$pp->session_check();

?>

<link href="css/inside.css" rel="stylesheet" type="text/css" />
<div id="content_title">Update DJ Says </div>
        
        <div id="content">On this page you are able to review the current DJ Says and update it.<br>
          <br>
          <strong>Current DJ Says:</strong>
<?php

$query = $db->query("SELECT * FROM `djsays`");

$rows = $db->fetch($query);

$djsays = $rows["message"];
$by = $rows["by"];
$level = $info["level"];

echo( $djsays );

?>
<br>
<strong>DJ Says Last Updated By: </strong>
<?php

if($level == "admin")
{

    $level = "Administrator";

}
elseif($level == "trialist")
{

    $level = "Trialist DJ";

}
elseif($level == "regular")
{

    $level = "Regular DJ";

}
elseif($level == "senior")
{

    $level = "Senior DJ";

}
else
{

    $level = "Could not detect user level! Fatal error";

}

echo( $by ." - <strong>". $level ."</strong>");

?>
<br>
<br><?php

if(isset($_POST['message']) && !empty($_POST['message'])) {

$message = $_POST['message'];
$message = $misc->clean($message);
$message = $misc->filter($message);

$username = $_SESSION['username'];

$query = $db->query("UPDATE djsays SET `message` = '$message', `by` = ".$_SESSION["username"]."'");

echo("The DJ Says has been <strong>Updated!</strong><br /><br /><div id='link'><a href='?page=djsays'>Go back</a></div>");
} elseif(isset($_POST['message']) && empty($_POST['message'])) {
echo("<strong>Error:</strong> A field was left empty!<br /><br /><div id='link'><a href='?page=djsays'>Go back</a></div>");
} else { ?>
<div id="djsays">
  <form method="post" action="">
    <label><strong>Message:</strong><br> 
    <input name="message" type="text" id="message">
      </label>
    <br>
    <br>
    <label>
    <input type="submit" name="Submit" value="Update">
    </label>
  </form><? } ?>
  </div>
</div>

[Invent]

<?php

$pp->session_check();

?>

<link href="css/inside.css" rel="stylesheet" type="text/css" />
<div id="content_title">Update DJ Says </div>
        
        <div id="content">On this page you are able to review the current DJ Says and update it.<br>
          <br>
          <strong>Current DJ Says:</strong>
<?php

$query = $db->query("SELECT * FROM `djsays`");

$rows = $db->fetch($query);

$djsays = $rows["message"];
$by = $rows["by"];
$level = $info["level"];

echo( $djsays );

?>
<br>
<strong>DJ Says Last Updated By: </strong>
<?php

if($level == "admin")
{

    $level = "Administrator";

}
elseif($level == "trialist")
{

    $level = "Trialist DJ";

}
elseif($level == "regular")
{

    $level = "Regular DJ";

}
elseif($level == "senior")
{

    $level = "Senior DJ";

}
else
{

    $level = "Could not detect user level! Fatal error";

}

echo( $by ." - <strong>". $level ."</strong>");

?>
<br>
<br><?php

if(isset($_POST['message']) && !empty($_POST['message'])) {

$message = $_POST['message'];
$message = $misc->clean($message);
$message = $misc->filter($message);

$username = $_SESSION['username'];

$query = $db->query("UPDATE djsays SET `message` = '$message', `by` = '".$_SESSION["username"]."'");

echo("The DJ Says has been <strong>Updated!</strong><br /><br /><div id='link'><a href='?page=djsays'>Go back</a></div>");
} elseif(isset($_POST['message']) && empty($_POST['message'])) {
echo("<strong>Error:</strong> A field was left empty!<br /><br /><div id='link'><a href='?page=djsays'>Go back</a></div>");
} else { ?>
<div id="djsays">
  <form method="post" action="">
    <label><strong>Message:</strong><br> 
    <input name="message" type="text" id="message">
      </label>
    <br>
    <br>
    <label>
    <input type="submit" name="Submit" value="Update">
    </label>
  </form><? } ?>
  </div>
</div>

[Jamieb]

Thanks +rep