php 4.0.6 to php 4.2.2 inserting data into database

[angelorigo]

Hi
I was using php 4.0.6 and upgrade to php 4.2.2.
I was using this piece of code to insert data on postgresql database:

$query = "INSERT INTO table (id, autor, title, date) values (nextval('table_id_seq'), '$autor', '$title' '$date')";

$result = pg_exec($db, $query);
if (!$result) {printf ("ERROR"); exit;}
printf ("Estes valores foram inseridos no banco de dados<p> -%s %s %s<p>", $autor, $title, $date);

But now no data is inserted! but only the id and date field wich is a variable defined outside the caption form, in wich each table field has his input text with the corresponding name . Anything change ?
why do i can not get data from the form?

Thank´s in advance

[jkohns]

what is nextval() ? if it's a function from your script, try this:

if ($query = mysql_query("INSERT INTO table (id, autor, title, date) values ('".nextval('table_id_seq')."', '$autor', '$title' '$date')"){
print "Estes valores foram inseridos no banco de dados<p> -$author $title $date";
}else{
print "ERROR";
exit;
}

[angelorigo]

Originally posted by jkohns
what is nextval() ? if it's a function from your script, try this:

if ($query = mysql_query("INSERT INTO table (id, autor, title, date) values ('".nextval('table_id_seq')."', '$autor', '$title' '$date')"){
print "Estes valores foram inseridos no banco de dados<p> -$author $title $date";
}else{
print "ERROR";
exit;
}

I will try just now!!!!!

nextval just retrieve the next sequence value of the record to put on the id field