[PHP] synchronize functions

[w . w . w]

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

Re: [PHP] sql help ?

[w . w . w]

> 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 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;

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

Re: [PHP] sql help ?

[w . w . w]

> 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

-- 
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

Re: [PHP] SQL Statement

[w . w . w]

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