PDA

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!