Parse error: parse error, unexpected T

[dcjones]

Hi all,

Can anyone have a look at this script. When I run it it gives the following error.

SRCIPT

114. if (!mysql_select_db($databaseName, $connection))
     showerror();

118. // Create a query to insert the customer
119. $query = "INSERT INTO chandos_books
120. set isbn_hardback = NULL, " .
121. "isbn_paperback = \"" . $formVars["isbn_paperback"] . "\", " .
122. "isbn_hardback = \"" . $formVars["isbn_hardback"] . "\", " .
123. "booktitle = \"" . $formVars["booktitle"] . "\", " .
124. "author_name = \"" . $formVars["author_name"] . "\", " .
     125. "author_summary = \"" . $formVars["author_summary"] . "\", " .
125. "book_summary_short = \"" . $formVars["book_summary_short"] . "\", " .
126. "book_summary_long = \"" . $formVars["book_summary_long"] . "\", " .
127. "price_paperback = \"" . $formVars["price_paperback"] . "\", " .
128. "price_hardback = \"" . $formVars["price_hardback"] . "\", " .
129. "readership = \"" . $formVars["readership"] . "\", " .
130. "key_features = \"" . $formVars["key_features"] . "\", " .
131. "content = \"" . $formVars["content"] . "\", " .
132. "published_date = \"" . $formVars["published_date"] . "\", " .
133. "pages = \"" . $formVars["pages"] . "\", " .
134. "size = \"" . $formVars["size"] . "\", " .
     136.
135. // Run the query on the chandos_books table
136. if (!(@ mysql_query ($query, $connection)))
137. showerror();
     
     140.
     141.
138. if (!mysql_close ($connection))
139. showerror();

END SCRIPT

ERROR

Parse error: parse error, unexpected T_IF in /homepages/41/d43000764/htdocs/chandos/store/admin/insertrecord.php on line 138

END ERROR

Any help would be good.

Kind regards, keep safe and well.

Dereck

[bubblenut]

Look at line 135, the end of that line is a dot (.) which is the string concatination symbol in php, telling it that you want to add more text to the string. You then go and try to do an if which is obviously not what the parser is expecting and hence the parse error.

Always end a command with a semi-colon (😉

HTH
Bubble