two inserts at once?
| From: | Michael Knauf/Niles | Date: | Thu, 09 Jan 2003 17:04:27 +0000 |
| Subject: | two inserts at once? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24702@lists.php.net to get a copy of this message | ||
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