Online users help

My Online script work great by i wonted to add something lik this

M.j king (0 min) ago

How do i add sec to my online script like dsipaint.

Here my script



<?php
session_start();
include("database.php");
$result = mysql_query("SELECT * FROM users WHERE Online='Online'");
while($row = mysql_fetch_array($result)){
$get = mysql_query("SELECT * FROM users WHERE username='".$row['username']."'");
$Show = mysql_fetch_array($get);

echo"<a href='Profile.php?username=".$row['username']."'><font color=".$row['color'].">".$row['username']."</font></a><br/> - ".$row['status']."<hr>";
}
include("database.php");
$result = mysql_query("SELECT * FROM users WHERE Online='Online'");
$row = mysql_fetch_array($result);
if($row['username'] ==""){
echo"There are No users online";
}
else{
}
?>

A true developer

Thanks :D

Existance alludes

Give me the mysql

Existance alludes

That is copyright Chanishyy.

...

I did it they were errors.

Existance alludes

First off, you need to use the time() function and set the `online` column on your table equal to the output of that function.
Then, based off of the difference between the current time and what is stored, you can find (in seconds), how long a person has been online.

Does this alter-ego make me look stupid?

Not understanding
I get the time part is it like this


time()+10*8;

A true developer

Doesn't this code need a MYSQL because am getting these errors:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/u690474005/public_html/user_index.php on line 32

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/u690474005/public_html/user_index.php on line 40
There are No users online

Existance alludes

What that error mean is that the the filed in the database dose not exit in the database table or the filed name is spelled wrong.

A true developer

What do l meant to do?

Existance alludes

You need to created the table.

Example:
id(11)
username var(15)
password (text)
Online (text)

You getting that error because the filed dose not exist within you database server.

A true developer

Okay :D

Existance alludes

No its not that.

Existance alludes

It is that did you make a var call Online?

A true developer

Yeah l got it now and learnt!

Existance alludes

Ok happy to hear.

A true developer

I have need to add latin_general_ci to the username

Existance alludes

I do not understand your question.
0_0?

A true developer

For my login and register

l put this

Username varchar 30 latin_general_ci

Password varchar 30 latin_general_ci

Can l still include latin_general_ci into the table :

id(11)
username var(30) latin_general_ci
password (text) latin_general_ci
Online (text)

Or should l just do what you did with the MYSQL?

Existance alludes

Do not include it auto do it after you create the table

A true developer