CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 PHP and MySQL, on logout event bug

Print topic Send  topic

Author Message
W. Krasowski
Posted: 08/09/2001, 1:53 PM

I have tried to force CC (ver 2.0 beta4) to do something at "on logout
event"
when working with example "Portal" - but it seems it does completlly
nothing!
I wanted it to update MySQL database field (possible values are 1 and
0) where - if user is currently logged - it states 1, otherwise 0.

It works well (updates this field into 1) at execution an event of the
form - "on login event" but do not work at execution "on logout" event
of the same form.

The PHP/MySQL code that do not works is:
$set_logged = "update members set logged='0' WHERE member_login='$sLogin'";
mysql_query($set_logged);

My configuration is: MySQL 3.23.38 for Win9x, Apache 1.3.14 for Win9x,
PHP 4.05 for Win9x. CC 2.0 beta 4 with PHP4 with templates

Any ideas or advices would be appreciated.

Greets to all CodeCharge coders,
W. Krasowski






Alexey Alexapolsky
Posted: 08/10/2001, 2:26 AM

mysql_query ($set_logged,$db->Link_ID);

you forgot to specify db connection

--
Alex
CC developer

W. Krasowski <pkrasowska@deagostini.pl> wrote in message
news:9kut8k$jmp$1@news.codecharge.com...
> I have tried to force CC (ver 2.0 beta4) to do something at "on logout
> event"
> when working with example "Portal" - but it seems it does completlly
> nothing!
> I wanted it to update MySQL database field (possible values are 1 and
> 0) where - if user is currently logged - it states 1, otherwise 0.
>
> It works well (updates this field into 1) at execution an event of the
> form - "on login event" but do not work at execution "on logout" event
> of the same form.
>
> The PHP/MySQL code that do not works is:
> $set_logged = "update members set logged='0' WHERE
member_login='$sLogin'";
> mysql_query($set_logged);
>
> My configuration is: MySQL 3.23.38 for Win9x, Apache 1.3.14 for Win9x,
> PHP 4.05 for Win9x. CC 2.0 beta 4 with PHP4 with templates
>
> Any ideas or advices would be appreciated.
>
> Greets to all CodeCharge coders,
> W. Krasowski
>
>
>
>
>
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.