EXAMPLE MYSQL

$DBHOST = 'localhost';
$DBNAME = 'lol';
$DBUSER = 'orgi';
$DBPASS = '#care';

mysql_connect($DBHOST, $DBUSER, $DBPASS) OR die(mysql_error());
mysql_select_db($DBNAME) OR die(mysql_error());

//simple query
$q = mysql_query('SELECT * FROM TABLE');
while($row = mysql_fetch_assoc($q))
{
 echo $row['stuff'];
}

-----------------------------------
EXAMPLE PDO WITH OO-PHP

$DBHOST = 'localhost';
$DBNAME = 'lol';
$DBUSER = 'orgi';
$DBPASS = '#care';

//try and catch is error handling since php 5

try
{
    $db = new PDO('mysql:host:'.$DBHOST, $DBUSER, $DBPASS);
}
catch(PDOExeption $e)
{
    echo 'Could not establish database connection'; //userfriendly error output
}

//simple query
$q = $db->query('SELECT * FROM table');
$result = $q->fetchAll(PDO::fetch_assoc)

foreach($result as $row)
{
    echo $row['stuff'];
}