I have to transform into normal db with table :
function insertVisit (&$visitData)
{
$query = "INSERT INTO trackVisit (
";
$query .= implode (",",array_keys ($visitData));
$query .= ")VALUES ( ";
$query .= implode ("," ,array_values ($visitData));
$query.= ");
";
$result = sqlite_query ($GLOBALS['dbres'], $query);
$visitData ['ID']= sqlite_last_insert_rowid ($GLOBALS['dbres']);
/* field ID is automatic incremented*/
}
?>
Please help me how to do code? I have transformed as this code:
function insertVisit (&$visitData)
{
$query = "INSERT INTO trackVisit WHERE MAX( $visitData ['ID'])(
";
$query = array_keys ($visitData);
$query = array_values ($visitData);
$query.= ");
";
$result = mysql_query ($GLOBALS['dbres'], $query);
}
how to insert new row into table?