mysql insert data in more than one table

[abda53]

i have 2 tables.. one called image and one called member.

when someone uploads an picture to my site, it will add the correct information to into the image table, but i also want to add the date to the members table for last updated..

just havin a problem doing 2 queries..

heres what i got now..

$date = now();

$sql = "INSERT INTO image (image_name,image_original,image_ext,image_size,image_width,image_height,image_caption,image_member_id,image_status,created_on,updated_on)
VALUES
('$base','$original','$ext','$size','$width','$height','$caption[$i]','$session_member_id','A','$date','$date')";

$result = mysql_query($sql);
}

[LiquidIceB]

im not sure about htis one..but try

$sql = "INSERT INTO image AS i, members AS m (i.img_name, m.time) VALUES ('fdjfld', 'fjdlkf')";

i dont garantee it would work, but worth a try

or if not, you can alwasy do a separate querie...

[Frederick]

Use your insert query and then follow it up with an update query for the members table.

I asume the member is logged in when this is occurring.
Place a hidden field in your uploader form that will hold the members table ID number.

echo "<input type=\"hidden\" name=\"userID\" value=\"$userID\">";