MySQL Question

[Peter Shadeslayer]

More problems. T_T

//Insert an update
function inUpdate($title, $update)
{
$user = "Zack";
$query = "INSERT INTO updates (title, update, date, user)
values('" . $title . "', '" . $update . "', CURDATE(), '" . $user . "')";

mysql_query($query) or die(mysql_error());
}
?>

<?php
include("functions.php");
databaseConnect("mysql.owensvilleumc.com", "username", "******", "dbname");

$title = $_POST['title'];
$update = $_POST['update'];

if(isset($title))
{
cleanString($title);
$okay++;
}

else
{
echo "You left the title field blank! ";
}

if(strlen($title) > 50)
{
echo "Your title cannot be longer than fifty characters. ";
}

else
{
$okay++;
}

if(isset($update))
{
cleanString($title, $update, $_COOKIE['user']);
$okay++;
}

else
{
echo "You left the update field blank! ";
}

if(strlen($update) > 500)
{
echo "The length of an update cannot exceed 500 characters. ";
}

else
{
$okay++;
}

if($okay == 4)
{
inUpdate($title, $update);
}

else
{
echo "something's up...";
}
?>

<form action="cms.php" method="post"> 
<table> 
<tr> 
<td> 
Update Title:
</td> 
<td> 
<input type="text" name="title"> 
</td> 
</tr> 
 
<tr> 
<td> 
Update:
</td> 
<td> 
<textarea name="update"> 
 
</textarea> 
</td> 
</tr> 
 
<tr> 
<td> 
<input type="reset" value="Clear"> 
</td> 
<td> 
<input type="submit" value="Submit"> 
</td> 
</tr> 
 
</table> 
</form>

I don't think I really need to explain the purpose of the code... it's pretty direct. ;D

 

[1. Luftballon]

so what's the problem?

 

[Peter Shadeslayer]

My apologies.

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 'update, date, user) values('Title', 'Update ', CURDATE(), 'Zack')' at line 1

This is the page.

 

[Butterfree]

The word "update" is the problem, since it's a SQL keyword. How did you manage to even create a column named "update"? Shouldn't that return an error? Are you sure you actually named it that?

 

[Peter Shadeslayer]

phpMyAdmin lol, I never thought of that O.o

fail.

I'll change it to updates or something. Thanks, Butterfree!