Form that submits data to three tables, need help linking two tables to one
I want one form to submit to 3 different tables in MYSQL... I got them to submit to the right tables, but I want to take the first tables id (primary key, auto_increment) and make that the realtor_id of the other two tables. Anyone know what I need to put in the field of the other 2 to make it read it properly? Heres what I have so far...
Code:
if($_POST['submit'])
{
$sql = "INSERT INTO logins (username, password)
I am writing a code for a shopping cart, the customer selects the color, which also has the price. I want to send the color and the price to "price" and "color" on the mysql server. How do I code a SELECT to send two different variables to two different mysql names?
I'm trying to make an online store and have everything working so far. The only problem I am having is making a multi level navigation. When someone clicks "mens" section it brings up stuff like "tshirt", "hats", etc. That works fine, my problem is when they click on that I want the same sub navigation to be there so they can still look at "tshirt", "hats", etc without having to click "mens"...