Hello I have question that might sound stupid, but how do I echo just one field from the database? I tried the following: // make the connection to the database @require "connect.php"; // Retreive data from database for translation $result = mysql_query('SELECT * FROM admins WHERE id = 29');// Select id 29 from table admins $res = mysqli_query($dbh, $result);// I don't understand this $newArray = mysqli_fetch_array($res, MYSQLI_ASSOC);// Something with an aray? $name = $newArray['name'];//Extract the name from the aray and give it the variable $name? echo "$name";// Show the name What it does... actually what it doesn't do is echo (print) the name on the screen. The table looks like this: CREATE TABLE `admins` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) default NULL, `user` varchar(50) default NULL, `passwd` varchar(50) default NULL, `type` int(11) default NULL, `language` int(11) default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=34 ; INSERT INTO `admins` VALUES (29, 'John Doe', 'hello', 'test', 1, 0); I just don't know how to get the name as a variable and than echo"$name" I'm very new to php :) Any help is welcome! Kind regards, Sebas.