[quote=user465]hello

i want to show who is the newst member
i have these codes but something is wrong

the table is called users where all members are saved
but it only says Our very newest member is:
and nothing more

here the codes

PHP Code:

<?php 
 
 
$dbHost = "localhost"; 
$dbUser = "***"; 
$dbPass = "***"; 
$dbName = "***"; 
 
$connect = mysql_connect($dbHost, $dbUser, $dbPass) or die("Keine Verbindung zum Datenbankserver!"); 
mysql_select_db($dbName); 
 
$sql = "SELECT * FROM users ORDER BY id DESC LIMIT 0, 1"; 
$do = mysql_query($sql); 
$fetch = mysql_fetch_array($do); 
 
echo "Our newest member is: ".$fetch['user']; 
 
?>

What's the error you get?

I believe he is saying he doesnt get an error, rather, the lastest member simply isnt displayed =/

thanks
the problem was user it should be username

I think you're right.

Maybe you could try to change '*' into 'user', since you don't need any other data, but I doubt it does anything. You could also try to put a ';' after your query. I don't know if it's very important for MySQL, but it never hurts.

EDIT: Nevermind, the problem was solved already.