Re: SQL Statement

Sorry... michi.. I've ignored your advice to quote the script as : > 3. > you have to quote "v$session": "v\$session" ----- yeah.. the script is work when I change the script right below : $query = "Select OSUSER From v\$session Where USERNAME = (Select USER From DUAL) And AUDSID =(Select USERENV('SESSIONID') From DUAL)"; great thanks in advance to michi... ^_^ ----- Original Message ----- From: "èdy kurniawan" <edy.kurniawan@astra-honda.com> Subject: Re: [PHP] SQL Statement > thanks to michi for ASAP response... > but I thought your opinion not actually right.. > > I've a sql : > > $query = "Select dfl_desc From > fmmis_0000_datafls@dbhonda Where dfl_flag = > (Select dpb_flag From fmadm_gs00_dtlppbs@dbhonda > Where DPB_PARTNONSTOCK = '".$TT[$n]."') > And DFL_KDDOK ='PPM'"; > > its a kind of subselect (or oracle-ist usual call it nested query) and it > works properly. > > as your sugesstion, I've ever put a simple script : > $query = "Select OSUSER > From v$session"; > > and the error is still occured. > > Ora_Parse failed (ORA-00942: table or view does not exist ........ > > > O.k. but at all... i'm very appreciate for your response michi .. > > any other ideas ? > > sincerely, > edyk ----- Original Message ----- From: <w.w.w@gmx.at> Sent: Wednesday, June 19, 2002 1:26 PM Subject: Re: [PHP] SQL Statement > this is the problem: > > $query = "Select OSUSER > >From v$session > Where USERNAME = (Select USER From DUAL) > And AUDSID =(Select USERENV('SESSIONID') From DUAL)"; > > 1. > mysql does NOT support subselects! > 2. > delete the "<" in front of "FROM" > 3. > you have to quote "v$session": "v\$session" > > start with a short query like: > $query = "select OSUSER from v\$session where USERNAME like 'foo'"; > > then you have to recode the subselects with php-loops!!! > michi >