2. PHPRunner General questions
  3. Save record another table
This topic is locked

Save record another table

 		12/6/2008 3:31:21 AM
PHPRunner General questions
M
 maxcolo author

My code is:

[codebox]//** Save new data in another table ****
global $conn,$strTableName;
$strSQLSave = "INSERT INTO tavoli_pranzo (zona, numero_tavolo, posti_max, foto_tavolo) values (";
$strSQLSave .= $values["zona"].",";
$strSQLSave .= $values["numero_tavolo"].",";
$strSQLSave .= $values["posti_max"].",";
$strSQLSave .= $values["foto_tavolo"];
$strSQLSave .= ")";
db_exec($strSQLSave,$conn);
return true;[/codebox]
but, I have this error:

Errore di tipo256Errore di descrizioneThis is a general error. It occurs when thereis an error in event code or in SQL.
M
 		maxcolo author 12/6/2008

Solved with this:



[codebox]//** Save new data in another table ****
global $conn,$strTableName;$strSQLSave = "INSERT INTO tavoli_pranzo (zona, numero_tavolo, posti_max, foto_tavolo) values ('";
$strSQLSave .= $values['zona']."','";
$strSQLSave .= $values['numero_tavolo']."','";
$strSQLSave .= $values['posti_max']."','";
$strSQLSave .= $values['foto_tavolo'];
$strSQLSave .= "')";
db_exec($strSQLSave,$conn);
return true;[/codebox]