<?php
$mysqlhost = "dbhost";
$mysqluser = "dbuser";
$mysqlpwd = "dbpassword";
$connection=mysql_connect($mysqlhost,$mysqluser, $mysqlpwd) or die("Connection failed");
mysql_selectdb("dbname");

/* Let's say you have the following database structure:

Tablename: Users

Username
Password
FirstName
LastName
Age
*/

$Query = "SELECT * FROM Users WHERE Username='Bla' AND Password='Bla'";

$Result = mysql_query($Query);

while($row = mysql_fetch_object($Result)) {
echo $row->Username."|".$row->FirstName."|".$row->LastName."|".$row->Age."<br>";
}
?>