MySQL Error

[Mod-Jay]

I dont know whats wrong

 

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '::1, 3, , now())' at line 1

 

Error Line:

                mysql_query('INSERT INTO `'. $db .'`.`votes` (`ip`, `serverId`, `ownerId`, `date`) VALUES ('. $ip .', '. $serverId .', '. $ownerId .', now())') or die(mysql_error());

[JD*]

Put this on the line above your mysql query:

 

die('INSERT INTO `'. $db .'`.`votes` (`ip`, `serverId`, `ownerId`, `date`) VALUES ('. $ip .', '. $serverId .', '. $ownerId .', now())');

 

And then reload the page. It should print out your query with the variables replaced with their values and you can see what looks incorrect, or post the results here and we'll take a look

[Mod-Jay]

INSERT INTO `noxipcom_toplist`.`votes` (`ip`, `serverId`, `ownerId`, `date`) VALUES (::1, 3, , now())

[JD*]

Ok, so it looks like your variables are empty. Can you post the rest of your code?

[Pikachu2000]

No, actually what the problem looks like is the values aren't quoted in the query string. The IP address looks hosed, but if it were quoted, it would at least insert. $ownerId may be empty. If you form your query string in a variable, without all the unnecessary string concatenation, it makes these errors much easier to spot, and allows you to echo the entire query string when there's an error.

 

$query = "INSERT INTO `$db`.`votes` ( `ip`, `serverId`, `ownerId`, `date` ) VALUES ( '$ip', '$serverId', '$ownerId', now() )";
$result = mysql_query( $query ) or die( "<br>Query string: $query<br>Produced error: " . mysql_error() . '<br>' );