Off hand, I don't know. Just try it -- you're not really going to break 
anything and may come up with something we can all use.

About 12 years ago I was working for a sewer and water contractor, which 
built a number of "interesting" projects. Before starting with them I 
assumed they just knew how to build them. I was wrong. If they only built 
what they knew their business would have shrivelled and died.

They grew by building what many other contractors considered undoable, and 
got premium prices. When I struck out on my own that was the lesson I took 
with me. And it's a tough one, because I generally like to know how things 
will turn out before I finish. Several years ago I was 30% of the way into 
a project in VB when it became very clear that for what I wanted to do VB 
just didn't have the capabilities. So it was back to FoxPro for Windows and 
successful completion. Fortunately the client was understanding.

So, it's a good question. But sometimes we just have to try these things. 
If Rasmus et. al. hadn't we wouldn't have PHP today.

Cheers, and please let us know how it works out - Miles

At 12:54 PM 1/14/2002 +0200, Markus Lervik wrote:
>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"Asdf"),
>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.
>Markus Lervik
>Linux-administrator with a kungfoo grip
>Vaasa City Library - Regional Library
>+358-6-325 3589 / +358-40-832 6709
>PHP Database Mailing List (
>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 (
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