Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199807

Re: [PHP3] SQL Question From: Tony Hall (tonyhall <email protected>)
Date: 07/31/98

At 01:43 PM 31/7/98 -0700, you wrote:
>Hello everyone,
>
>Should this statement work as it is written? I keep getting sintax
>errors, so I am assuming that I am missing something minor. Please let
>me know, I have been banging my head on this all morning.
>
>Thanks,

Depends on the Database you are Writing to
e.g, mSQL and mySQL do not support SELECT INTO
where as Oracle DOES

>
>> $ready_sql = "INSERT INTO tblTable (Index, Things) VALUES (SELECT column
FROM tblOtherTable
>>
>> WHERE Stuff = '$Stuff', SELECT anothercolumn FROM
tblOtherTable2
>>
>> WHERE Newstuff = '$NewStuff')";
>>
>
>
>--
>Justin Foster <jfoster <email protected>>
>
><HTML>
>Hello everyone,
>
><P>Should this statement work as it is written? I keep getting sintax errors,
>so I am assuming that I am missing something minor.&nbsp; Please let me
>know, I have been banging my head on this all morning.
>
><P>Thanks,
><BR>&nbsp;
><BLOCKQUOTE TYPE=CITE>
><PRE>$ready_sql = "INSERT INTO tblTable (Index, Things) VALUES (SELECT
column FROM tblOtherTable</PRE>
></BLOCKQUOTE>
>
><BLOCKQUOTE TYPE=CITE>
><PRE>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE Stuff = '$Stuff', SELECT&nbsp;
anothercolumn FROM tblOtherTable2</PRE>
></BLOCKQUOTE>
>
><BLOCKQUOTE TYPE=CITE>
><PRE>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE
Newstuff = '$NewStuff')";</PRE>
></BLOCKQUOTE>
>
>
><P>&nbsp;
>
><P>--
><BR>Justin Foster &lt;jfoster <email protected>>
><BR>&nbsp;</HTML>
> 

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3