if you are using mysql then no i don't think you can do that, since it
doesn't support nested queries - postgres or some other db may well support
it tho

but like miles said - give it a go :) (maybe on a test database/table just
in case)

hth

-b

// -----Original Message-----
// From: Markus Lervik [mailto:[EMAIL PROTECTED]]
// Sent: Monday, 14 January 2002 6:54 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Combining INSERT...SELECT and INSERT INTO
// 
// 
// 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]
// 

-- 
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]

Reply via email to