> OK. This sounds great, but now I am getting a completely different
> error message.
> You have an error in your SQL syntax near '-sys) VALUES('sn4265-turner')'
> line 1
> Here is the INSERT statement:
> $query = "INSERT INTO accounts (id-sys) VALUES('".$accnts."')";
> Do I have to rename the column? I would rather not if I can avoid
> it. If I must, is this a problem with PHP or MySQL not understanding '-'
> a column name? Thanks again.
Try putting backtics (not single quotes) around the column name.
$query = "INSERT INTO accounts (`id-sys`) VALUES ('".$accnts."')";
if that don't work, you'll have to rename the column.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php