6 replies to this topic

[hk_]

well it's just that i want to display the current loged user
like welcome: username so i put this together


<?php

mysql_connect("$host","$user","$pass") or die(mysql_error());
mysql_select_db("$db") or die(mysql_error());

$data = mysql_query("select username from $table") or die(mysql_error());
$info = mysql_fetch_array($data);

if(!session_is_registered('loged')){
echo('Bienvenido : Invitado');
}else{
echo('Bienvenido : '.$info['username']);
}
?>

but if i login with the last username or any other it just return the user of the first row on the database.

a little help?


thanks by the way x)

[Demonslay]

Look up on some basic user system scripts.

You problem is you aren't selecting the logged in user. This is how you would do it as an example query.

SELECT * FROM `members` WHERE `username` = '$username'

Where $username is the currently logged in person's username, taken from their cookie, or session data.
Or you could select by the user's id, which is probably more reliable.

Once again, simply look up your average member system and you'll see it all in there.

[hk_]

thanx a lot x)

[derek.sullivan]

<?php
// add you're database connect file here...

$query = mysql_query("SELECT * FROM `table_name` WHERE `username` = '".$_SESSION['s_username']."'") or die("MySql Error: ".mysql_error() );

$row = mysql_fetch_array($query);

$onoff = $row['status'];

if ($onoff == 'Online') {
echo "Online";
}else{
echo "Offline";
}
?>

Now you're going to have to do a little editing, but that's what I used and it works.

[rc69]

Umm, Derek, i don't know if you noticed or not, but it appears as though he has already gotten it working.

[derek.sullivan]

Nope, but you never know when someone will be lazy and just copy and paste then edit it Plus, I can do what I want as long as it's within regulations.

[hk_]

jeje thnx for the script im just having troubles with the sessions and frames xD