MSQL query

[Roca]

hi folks!

i'm a php/mysql newbie and have a problem with the following command:

[i]$query = "select dev_name, inv_nr from devices, dev_det where dev_key = '" . $_GET["id"] . "' and dev_det_key_sec = '" . $_GET["id"] . "' and komp_typ = "Hauptkomponente";[/i]

as a result i get this:

[b]Parse error: parse error, unexpected T_STRING in /server/apache/htdocs/mysql_test.php on line 2908
[/b] and line 2908 is what i've written above.

is it possible that i have to use [b]\[/b] in front of a [b]"[/b]? can someone tell me whats wrong with the string?

thx n cheers
roca

[.josh]

[code]
$query = "select dev_name, inv_nr from devices, dev_det where dev_key = '" . $_GET["id"] . "' and dev_det_key_sec = '" . $_GET["id"] . "' and komp_typ = 'Hauptkomponente'";
[/code]

[Roca]

thx for the quick answer...it works! :)

cheers