Re: SQL Statement
| From: | w dot w dot w at gmx dot at | Date: | Wed, 19 Jun 2002 06:26:48 +0000 |
| Subject: | Re: SQL Statement | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-102877@lists.php.net to get a copy of this message | ||
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
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net