Parse error: syntax error, unexpected '"', expecting T STRING or T VAR

PHP errors

[Robeysan]

I am getting this error when attempting to update my database with the qurey below.

Error Message:
Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /big/dom/xthelocalsounds/www/DEV/addshows.php on line 100

Line 100 of my code

//update db
$sql = "INSERT INTO `SHOWS` (`SHOW_ID`, `APPROVED`, `SHOW_NAME`, `DESCRIPTION`, `GENRE`, `SHOW_DATE`, `SHOW_TIME`, `HR`, `MIN`, `AMPM`, `CHARGE`, `AGE`, `POSTED_BY`, `COMMENTS`, `VENUE_NAME`, `ARTIST_NAME`, `TSF`, `LMN`, `LPI`, `LS`, `V`, `JB`, `SM`, `VIEWS`) VALUES (NULL, 'n', '$tittle', '$desc', '$genre', '$showDate', '$time', '$hr', '$min', '$ampm', '$cover', '$age', '$postedBy', '$comments', '$venueName', '$artistName', '$shonet['tsf']', '$shonet['lmn']', '$shonet['lpi']', '$shonet['ls']', '$shonet['v']', 'n', '$shonet['sm']', '0')";

[edited by: Robeysan at 10:35 pm (utc) on June 16, 2009]

[rocknbil]

Looks like you're okay up to here, try . . .

..... '$artistName', '".$shonet['tsf']."', '".$shonet['lmn']."', '".$shonet['lpi']."', '".$shonet['ls']."', '".$shonet['v']."', 'n', '".$shonet['sm']."', '0')";

or

$tsf = $shonet['tsf'];
$lmn = $shonet['lmn'];
$lpi = $shonet['lpi'];
$ls = $shonet['ls'];
$v = $shonet['v'];
$sm = $shonet['sm'];

... '$artistName', '$tsf', '$lmn', '$lpi', '$ls', '$v', 'n', '$sm', '0')";

[Robeysan]

Thanks... I find that I have more trouble with concantonation and tic marks when dealing with sql queries.
Thanks a lot