SHow Currentuser

[CJLeah]

I'm having trouble wit a code, i'm quite sure is wrong, what I want is a code that will show the current user, eg Hello Chris. ANyway whats wrong with mine, or whats right, lol. please help 🙂

<?php mysql_query("SELECT username FROM users"); echo ($_POST['username']); ?>

[devinemke]

<?php
mysql_connect('host', 'user', 'password') or exit(mysql_error());
mysql_select_db('dbname') or exit(mysql_error());

$result = mysql_query("SELECT COUNT(*) FROM users WHERE username = '" . $_POST['username'] . "'") or exit(mysql_error());
if (mysql_result($result, 0)) {echo $_POST['username'] . ' is in the database';}
else {echo $_POST['username'] . ' is not in the database';}
?>