Trying to ad a online table, what should it be set to?

[Breana]

Ok, i am adding a table to the users table called online.
So when they login it will set (online) to Y and when they logout it will be set to N.

But what should it be created as, it will be updated often and i need to beable to read it from my php in the Members online section?
varchar(50), int(10), or Text...

And how do i call the results of it not in text Y but in total.
Like lets say there is a total 50 users=Y so it will PRINT 50.

I have tried several times but i keep getting eather 9empty) or (Y) Not the total as 8

I created the table like this:
[PHP]ALTER TABLE users
ADD online varchar(1) default 'N';[/PHP]

And call it like this:
[PHP]$sql="SELECT online FROM users WHERE online = $Y";
$result = mysql_query($sq l ,$db);[/PHP]

And call it:
[PHP]<?php printf($online) ; ?>[/PHP]

is there a special way to count the value of Y and skip N

[pbmods]

Heya, Breana.

You've managed to create a UPDECT query, which is a cross between a SELECT and an UPDATE. It's not valid, but it is very creative.

The idea is that the `last_active` field stores the time of last activity; that is, the time that the User loaded the page. So you can simply set its value to the current datetime when updating it:

 $_sql = "
UPDATE
        `users`
    SET
        `last_active` = NOW()
    WHERE
        `user_id` = '{$user_id}'
    LIMIT 1";
 

[Breana]

I tried to but it dont change, allways 000-000-000
Iposted my code maybe i placed it wrong..

[PHP]<?php

$sql = "select * from users where login = '$login' and password = '$password'";
$result = mysql_query($sq l ,$db);

if ($myrow = mysql_fetch_arr ay($result)) {

do {

$uid = $myrow["userid"];
$uname = $myrow["login"];

} while ($myrow = mysql_fetch_arr ay($result));

$loggedin = true;
$upwd = $password;
$msg = "<table width=\"500\" border=\"0\" align=\"center\ " cellpadding=\"0 \" cellspacing=\"0 \">
<tr>
<td><img src=\"images/top_c.gif\" width=\"500\" height=\"24\"></td>
</tr>
<tr>
<td align=\"center\ " background=\"im ages/b_m.gif\">Welco me <font color=\"#FF0000 \">$uname</font>, you are now logged in.</td>
</tr>
<tr>
<td><img src=\"images/bottom_c.gif\" width=\"500\" height=\"24\"></td>
</tr>
</table><br />
<br />
<a href=\"index.ph p\">CONTINUE >></a><br /><br /><p align=\"center\ "><img src=\"images/Welcome_Back.gi f\" width=\"300\" height=\"282\" /></p>";
$sql = "UPDATE `users` SET `last_active` = NOW() WHERE `user_id` = '{$user_id}' LIMIT 1";

} else {
$loggedin = false;
$upwd = "";
$uid = "";
$uname = "";
$msg = "<img src=\"images/invalid.gif\" width=\"402\" height=\"107\" /><br /><b><font color=\"#FF0000 \">Sorry,</font></b> that login and password is not valid.<br /><br />If you have forgotten your password <a href=forgot.php >Reset Password</a>. <br />If you are a new user you will need to <a href=newuser.ph p>Create A New Account!</a>";


}

session_registe r("loggedin") ;
session_registe r("upwd");
session_registe r("uid");
session_registe r("uname");

?>[/PHP]

[pbmods]

Heya, Breana.

Make sure that the `last_active` field is a TIMESTAMP with DEFAULT CURRENT_TIMESTA MP and ON UPDATE CURRENT_TIMESTA MP.

Also note this line:

 $sql = "UPDATE `users` SET `last_active` = NOW() WHERE `user_id` = '{$user_id}' LIMIT 1";
 

You'll want to replace $user_id with $uid, since that's the variable that stores the User's ID. Also, in your Users table, the User ID field is userid, not user_id. I just put some generic names in there.

Your code should look more like this:

 $sql = "UPDATE `users` SET `last_active` = NOW() WHERE `userid` = '{$uid}' LIMIT 1";
 

[Breana]

Oh ok, i did it now error or blank page, but on the part where i posted the whos online is empty?

I used this to call it:
[PHP]Total online: <?
$_sql = "SELECT
COUNT(`uid`)
FROM
`users`
WHERE
`last_active` > TIMESTAMP(NOW() , '00:15:00')
GROUP BY
`uid`" ?>[/PHP]

[pbmods]

Heya, Breana.

You're setting the value of $_sql, but you never call mysql_query().. ..

[Breana]

Ok like this:
[PHP]<?
$sql = "SELECT COUNT(`uid`) FROM `users` WHERE `last_active` > TIMESTAMP(NOW() , '00:15:00')
GROUP BY `uid`";
$result = mysql_query($sq l ,$db);?>[/PHP]

[pbmods]

Heya, Breana.

That looks pretty good. Then just call mysql_fetch_row ($result), and echo index 0 of the resulting array.

[Breana]

Ok i have it like this:
[PHP]Total online: <?
$sql = "SELECT COUNT(`uid`) FROM `users` WHERE `last_active` > TIMESTAMP(NOW() , '00:15:00')
GROUP BY `uid`";
$result = mysql_query($sq l ,$db);
mysql_fetch_row ($result);?>[/PHP]

"echo index 0" what....
you mean i need to echo ("index 0"); or what?

[pbmods]

Heya, Breana.

This line:

mysql_fetch_row($result);
 

Returns an array. You'll want to assign that array to a variable and then echo its 0th index.

I.e.,

$row = mysql_fetch_row($result);
echo $row[0];
 

[Breana]

Ok now it works sort of, it don't show 1 or 5 but this 209.33.95.33?
What is that... my ip address. (0 ^ 0)

Do i need to change the (0) to uid? so it shows a number