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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
