Hello! It's me again, with the magazine database : )
Is there any way to combine INSERT...SELECT and INSERT INTO so one could insert a new row with a few values inserted by hand and others from another table? something like INSERT INTO mag_table (mag_id,issn,year,info,volume,numbers,remarks) VALUES ( (SELECT id FROM mag_names WHERE mag_names.name="Asdf"), "1234-5678","2001","foobar","1-4","1-52","foobar"); I'm trying to construct myself a nice clever INSERT statement to my web-frontend. Haven't got it to work, though. Is this even possible? The other option would be to use three(?) mysql_query calls from my PHP-code, but I'd like to keep it as simple as possible. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
