Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002091

RE: [PHP-DB] INSERTing INTO Multiple Tables with MySQL & PHP From: joakim.andersson <email protected>
Date: 09/10/02

Something like this, perhaps?
<?
// your INSERT to first table here.

$insert_id = mysql_insert_id();

$sql = "SELECT MAX(SecondID) FROM LookupTable WHERE FirstID = $insert_id";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$max_second_id = $row[0];

$sql = "INSERT INTO LookupTable VALUES ($insert_id, $max_second_id + 1)";
$result = mysql_query($sql);
?>

Might be some errors in it, but you get the idea.

Regards
Joakim Andersson

> -----Original Message-----
> From: Graeme McLaren [mailto:mickel <email protected>]
> Sent: Tuesday, September 03, 2002 5:42 PM
> To: php-db <email protected>
> Subject: [PHP-DB] INSERTing INTO Multiple Tables with MySQL & PHP
>
>
> Hi there, I've been hunting thru the net trying to find some info on
> inserting data to multiple tables.
>
> I have two tables (LookupTable and MainTable):
>
> LookupTable(
> FirstID
> SecondID
> )
>
> MainTable(
> ID
> Name
> Address
> etc
> etc
> )
>
> Once I insert data into the MainTable I want to also insert
> the ID from the
> MainTable to the LookupTable as the FirstID. Then I want to
> check for the
> highest ID number in the SecondID field that is associated
> with the First ID
> then add one to the highest value and insert that to the SecondID.
> FirstID SecondID
> 1 1
> 1 2
> 1 3
> 1 4
>
> In the above table I would want to insert 1 to the FirstID
> then find the
> highest number in the SecondID associated with the FirstID
> "1" then add one
> to it so that my next row in the table would be:
>
> FirstID SecondID
> 1 5
>
> How would I go about doing this? I've been looking thru Kevin
> Yank's book
> "Build Your Own Database Driven Website Using PHP & MySQL",
> its pretty good
> on the whole but updating two tables simultaneously seems to
> be lacking
> detail.
>
> I hope I've made this clear enough, I may have repeated
> myself there but I
> was wanted to make sure that what I've written is cleary understood.
>
> Thank you in advance for any help - I'm lost!
>
> Graeme :)
>
>
> Public Sub House()
>
> On Error Resume drink
>
> If Pint.empty = True Then
> Pint.refill
> Else
> Pint.drink
> End if
>
> stomach.add Pint
>
> MsgBox " I've had .... " & stomach.count & " Pints"
> MsgBox "VERY DRUNK"
>
> End Sub
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php