database problem need help

mungra

Hello !!!

i have a function which is supposed to insert data in 2 tables ,"comments" and "postalbumcomments"
The problem is that only the table "comments" gets the data and "postalbumcomments" does not change at all
my code syntax seems ok..but don't know why the table "postalbumcomments", does not get updated
can someone help me plz

here are my codes
:

//connection stuffs
include("dbinfo.inc.php");
$userid=2;
$albumid=1;
$Data = "mycomments bla bla bla!!!";
$query = "INSERT INTO comments VALUES ('9','$Data','2001-01-05')";//This line works fines
mysql_query($query);//This line works fines

//update table post albumcomments.Here i need memberid, albumid, commentid=9

$query2 ="INSERT INTO postalbumcomments VALUES ('$userid','$albumid','9')";
mysql_query($query2);//This line seems not not working

//close connection
mysql_close();

mikesch

Hi,

I'm not sure, but maybe you have to close the first connection and then open a new connection to the second table?

I assume the two tables are in the same database, right?

Mike

rincewind456

Use

or die(mysql_error())

at the end of all your sql queries, and then let us know if there is an error.

You don't need to close the connection between queries.

You can run more tham one query at a time as long as the queries are delimited with ; so

$query = "INSERT INTO comments VALUES ('9','$Data','2001-01-05');INSERT INTO postalbumcomments VALUES ('$userid','$albumid','9')";

would work just as well as rumming 2 queries. Providing of course that the tables are in the same database.

mungra

thank for your help guys.Now i get the following error :

"Cannot add or update a child row: a foreign key constraint fails"

My table "postalbumcomments" refers from both the table"member" and "comments"

i have checked, and saw tht the values tht am inserting in the table "postalbumcomments" do exists in the parent tables.

so i dont know wat may be the problem ?

can you kindly help me?

regards

mungra

Its ok guys i found the error

thx