two inserts at once?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux