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 shor

Re: [PHP] sql help ?

> 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

Re: [PHP] sql help ?

> 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

[PHP] synchronize functions

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