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