Hi!
Any idea, how to synchronize functions in php???
I also have access to perl - so if it isn't possible with php, perhaps with
perl???
thanks for any hint, any idea or simple any mail!!!
regards
michael
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net
--
PHP General M
> select * from tracker where day='1' and month=' ".$month." ' XXX";
>
> XXX = but donot return values with the same value in the "sess_id" field
>
> what should XXX be ?
one line for each sess_id
select * from tracker where day='1' and month=' ".$month." ' group by
sess_id;
or one
> or one line for each sess_id with only one row:
> select * from tracker where count(sess_id)=1 and day='1' and month='
> ".$month." ' group by sess_id;
sorry that was wrong!
correct:
select * from tracker where day='1' and month=' ".$month." ' group by
sess_id having count(sess_id)=1;
michi
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 shor
4 matches
Mail list logo