Query works in phpmyadmin but not in PHP

[crillegs]

Hi Coders!

I have the following script in combination of MySQL and PHP which really doesn't want to work. Well, it works in Phpmyadmin, but when I run it on my website I get the following error:

Parse error: syntax error, unexpected T_STRING in /customers/mocs.dk/mocs.dk/httpd.www/projekt_rediger_mysql.php on line 16

The Code is as follows:

<?php

$projekt = $_POST['projekt'];
$bygherre = $_POST['bygherre'];
$tid = $_POST['tid'];
$partnere = $_POST['partnere'];
$tekst = $_POST['tekst'];
$gruppe = $_POST['gruppe'];

include('config.php');

con_db();

$query = "UPDATE projekter SET projekt = '$projekt', bygherre='$bygherre', tid='$tid', partnere='$partnere', tekst='$tekst' WHERE gruppe = '$gruppe'";
mysql_query("$query") or die mysql_error();

?>

P.S. Dont mind the weird language, it's danish.

Best Regards

Crillegs

[nemonoman]

mysql_query("$query") or die (mysql_error());

Note parens after die()

[bradgrafelman]

Also note that your script is vulnerable to SQL injection attacks. User-supplied data should never be placed directly into a SQL query; instead it should first be sanitized with a function such as [man]mysql_real_escape_string/man.