If you are using MySQL, you can't.
(none of my business, but why not simplifying your table names: "faqProduct"
instead of "faqRelatedToProduct" ?)
Ignatius
____________________________________________
----- Original Message -----
From: "Michael Knauf/Niles" <mknauf@nilesaudio.com>
To: <php-db@lists.php.net>
Sent: Thursday, January 09, 2003 6:04 PM
Subject: two inserts at once?
> This Code Snippet works:
>
> $newfaq_query = "INSERT INTO `faq` (`faqid`, `question`, `answer`) VALUES
> ('', '$question', '$answer')";
> $newfeaturesResult = mysql_query($newfeatures_query);
>
> But I'd like to combine that query with this one:
>
> INSERT INTO `faqRelatedToProduct` (`id`, `fgNumber`, `faqId`) VALUES ('',
> '$fgNumber', '$faqid');
>
> So that both are executed at the same time.
>
> The variables $question, $answer, $fgNumber come from a form, the faqid is
> a auto increment field, as is id... but it seems I need to know the value
> of faqid to relate it correctly to the fgNumber...
>
> Is there a way to combine the two queries?
>
> Michael
>
>
>
> --
> 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
