0

Hi all, i am very new to php, this is my first post and the first project that i am working on. i have searched for my problem but i cant find a solution, i suppose i dont even know what im looking for so here goes!

i have a form that is used to post details of a vehicle including an image,
everything is great if i store all if my values into one table.
my problem is that i want to store the image name into a different table so that each vehicle can have multiple images.

what i dont understand is the following:

in the file/page where the following query is held

$query = "INSERT INTO cars (id,  make,  model,  description,  color,  yearmodel,  price,  km,  dealership,  location, date_added)
VALUES ('NULL', '".$make."', '".$model."', '".$desc."', '".$colour."','".$yearmodel."', '".$price."', '', '', '', '')";
mysql_query($query) or die("error".mysql_error());

the above query stores the details of the vehicle into the database table called: cars, and creates a unique ID for the row.

following the above query i want to insert or create a new row in a table called images and insert the name of the image, but i need to associate the image with the car so i thought of adding the unique ID of car row to the image row.

the thing is that i dont know what the ID of the new row is because it was just created and im not sure if i can do another query to find the car row ID on the same page.

if anyone can guide me in the right direction, i will really appreciate it

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by smantscheff
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.