
August 23rd, 1999, 09:05 AM
|
|
Guest
|
|
Posts: n/a
Time spent in forums:
Reputation Power:
|
|
|
Hi everybody,
Who can help me to fix a problem.
I want to join two tables.
TABLE_A
Aid int; //auto increment
name varchar;
TABLE_B
Bid int; //same id as Aid
Author varchar;
if ($voegtoe) { // name of button in form
//add a record ID Aid auto increment
$sql_A = "INSERT INTO TABLE_A (naam) VALUES
('$name')";
mysql_query($sql_A);
//Tryin' to get the last ID from TABLE_A
$result_A = mysql_query("SELECT Aid FROM TABLE_A");
$objectid= mysql_query($result_A);
//Tryin' to use Aid From TABLE_A
$sql_B = "INSERT INTO TABEL B (Bid, author) VALUES
('$objectid', '$author')";
mysql_query($sql_B);
}
TABLE_B is not getting the ID from TABLE_A, Why??
Regards,
Vin@ic
|