[RESOLVED] Parse error: syntax error, unexpected ';'

obbie

Hi!

When I try to run the code below I get this error-message:

Parse error: syntax error, unexpected ';' in /customers/naturgym.se/naturgym.se/httpd.www/phpsqlinfo_addrow.php on line 29

I don't really know what's wrong with it. I would appreciate if anyone of you know-how guys out there could give me a helping hand. 🙂

Thanks alot!
//Oscar

<?php
require("phpsqlinfo_dbinfo.php");


$description = $_GET['description'];
$lat = $_GET['lat'];
$lng = $_GET['lng'];


$connection = mysql_connect ("localhost", $username, $password);
if (!$connection) {
  die('Not connected : ' . mysql_error());
}


$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
}


$query = sprintf("INSERT INTO markers " .
         " (id, description, lat, lng ) " .
         " VALUES (NULL, '%s', '%s', '%s');",
         mysql_real_escape_string($description),
         mysql_real_escape_string($lat),
         mysql_real_escape_string($lng),

$result = mysql_query($query);

if (!$result) {
  die('Invalid query: ' . mysql_error());
}

?>

sneakyimp

You have a syntax error (meaning your screwed up while typing your code) so your PHP script cannot be parsed by the PHP engine. In your case, it's right before $result = mysql_query....

You end the code that defines $query with a comma instead of a semicolon.

This is pretty basic stuff. PHP told you which line to look at for the problem...you should usually start by sniffing around whatever line it reports.

obbie

Hey, thanks for replying. I still can't get it to work though.

When replacing the semicolon with a comma I get a syntaxerror on row 31 telling me that the last IF-statement is unexpected instead.

It should work with the semicolon, but it doesn't. Any other ideas?

Thanks,
Oscar

sneakyimp

Read my post again. You should not be replacing any semicolons with any commas. You should be replacing a comma with a semicolon. Basically, each statement needs to end with a semicolon. This one does not:

$query = sprintf("INSERT INTO markers " .
         " (id, description, lat, lng ) " .
         " VALUES (NULL, '&#37;s', '%s', '%s');",
         mysql_real_escape_string($description),
         mysql_real_escape_string($lat),
         mysql_real_escape_string($lng),

bradgrafelman

Nor is the '(' opening parenthesis in sprintf( closed at the end of that statement.

obbie

Just fixed it! Thanks guys, really appreciate your help.

//Oscar