[Resolved] Update mysql

[fean0r]

Hiyas I keep getting this error:

You have an error in your SQL syntax near 'WHERE ID='2'' at line 7
with this code:

<?php
include("dbconnect.php");
include("acheck.php");
$sql = "UPDATE news SET
    ID='$ID',
    user='$user',
    date='$date',
    title='$title',
    post='$post'
    WHERE ID='$ID'";
if ($result = mysql_query($sql)) {
include ('head.php');
include ('banner.php');
include ('lmenu.php');
echo "<TABLE BORDER='0' WIDTH='70%' CELLPADDING='6' CELLSPACING='2' ALIGN='left'>";
echo "<TR><TH WIDTH='100%' ALIGN='left'>";
echo "<font color='#DEB887'>News Updated - Season 3</font><br><HR><BR>";
echo "Your changes have been saved<br><BR>";
echo "<a href=index.php>Back to the Main Page</a>";
echo "</TH></TR></TABLE>";
}
else {
    die(mysql_error());
}
?>

[YappyDog]

Could be because your ID column is a numeric and you have quotes around $ID. Try it without the quotes. Also you shouldn't be setting ID in the update if that is what you are using to reference the row, it's a waste of time.

$sql = "UPDATE news SET
user='$user',
date='$date',
title='$title',
post='$post'
WHERE ID=$ID";

[fean0r]

nopes still no luck I'm getting the same error 🙁

[YappyDog]

What does $sql contain after you build it?

echo it out and see if you can spot the error that way.

[fean0r]

UPDATE news SET user='fean0r1', date='Saturday 21st of June 2003', title='Test Title!', post=' XIII Trailer: Part 2 2 Muscle Car 3 Demo 3 The Sims Online 14-day trial 4 Charlies Angels Angel X 5 The Hulk Trailer ffff', WHERE ID='1'

[YappyDog]

You need to get rid of the comma right before the WHERE

Trailer ffff', WHERE ID='1'

so it would look like

Trailer ffff' WHERE ID='1'

Not sure how that is getting in there, but that is what is causing the problem.

[fean0r]

perfect thanks for your help