View Full Version : PowerPanel help please
Jamieb
08-05-2008, 05:05 PM
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
08-05-2008, 05:12 PM
Post the code.
Jamieb
08-05-2008, 05:14 PM
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
08-05-2008, 05:23 PM
<?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
08-05-2008, 05:25 PM
Thanks +rep
Want to hide these adverts? Register an account for free!
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.