This is driving me mad

[codebox]

This may be totally wrong, but do you normally enclose number fields in single quotes?

If I take out the $data statement and replace it with a number it works fine.

Kenny,
you have an error in PHP syntax.
Here is the correct statement.

$strSQLInsert = "INSERT INTO elo_value (ID_elo, ID_player, ID_game, ID_country, elo) values (NULL,'".$data["ID_player"]."','1','".$_SESSION["GID_country"]."','1000')";db_exec($strSQLInsert,$conn);

You can learn some PHP at the following sites:

http://www.php.net/manual/en/langref.php

http://www.webcheatsheet.com/php

http://www.w3schools.com/php/

Kenny,

Thanks Alexey
have just replaced my statement with yours and it is still giving me the same error.

Hi,
if the type of your ID_player field is NUMBER you don't need to use single quotes around field value:

$strSQLInsert = "INSERT INTO elo_value (ID_elo, ID_player, ID_game, ID_country, elo) values (NULL,".$data["ID_player"].",'1','".$_SESSION["GID_country"]."','1000')";db_exec($strSQLInsert,$conn);

Also I recommend you to check another fields in your query.

Hi,

All fields are INT(10)

Here is the correct SQL query:

$strSQLInsert = "INSERT INTO elo_value (ID_elo, ID_player, ID_game, ID_country, elo) values (NULL,".$data["ID_player"].",1,".$_SESSION["GID_country"].",1000)";

Thanks Guys I rally do appreciate your help but it's still not doing it. The error keeps coming up.
Parse error: parse error, unexpected T_STRING in /home/a/k/akr_productions_co_uk/ukfed/elo/include/elo_player_events.php on line 34

I have included the offending file....
line 34 is the statement we have been looking at the Inset INTO
[codebox]<?php
function BeforeAdd(&$values)

{
// Parameters:

// $values - Array object.

// Each field on the Add form represented as 'Field name'-'Field value' pair
//** Custom code ****

// put your custom code here
$_SESSION["GID_country"] = $values["ID_country"];

$_SESSION["Gname"] = $values["name"];
return true;
// return true if you like to proceed with adding new record

// return false in other case
}
function AfterAdd()

{

//** Insert a record into another table ****

global $conn;

$strSQLQuery = "select ID_player from elo_player where name='".$_SESSION["Gname"]."';

$rsResult = db_query($strSQLQuery,$conn);

$data=db_fetch_array($rsResult);
$strSQLInsert = "INSERT INTO elo_value (ID_elo, ID_player, ID_game, ID_country, elo) values (NULL,".$data["ID_player"].",1,".$_SESSION["GID_country"].",1000)";

db_exec($strSQLInsert,$conn);
}
?>[/codebox]

I recommend you to print your SQL query on the page before executing:

$strSQLInsert = "INSERT INTO elo_value (ID_elo, ID_player, ID_game, ID_country, elo) values (NULL,".$data["ID_player"].",1,".$_SESSION["GID_country"].",1000)";

Then copy and execute this query in the database directly and correct it.

Jane,

I suspect that the error is even before there. I put in your echo statement and I am still getting the error.
I will try taking out some of the other bits of code and see how I get on.

Use the following event code:

function AfterAdd()

The post resulting query here.

OK finally solved the problem....it was a missing " at the end of the initial query...
Thanks for all your help, first rate support and why I have bought the product...