PHP - otras formas de llamar los datos

yo conozco 2 formas de llamar datos

1**************************

<?php
$con = msql_connect();
if (!$con) {
die('Server connection problem: ' . msql_error());
}

if (!msql_select_db('test', $con)) {
die('Database connection problem: ' . msql_error());
}

$result = msql_query('SELECT id, name FROM people', $con);
if (!$result) {
die('Query execution problem: ' . msql_error());
}

while ($row = msql_fetch_row($result)) {
echo $row[0] . ': ' . $row[1] . "\n";
}

msql_free_result($result);
?>

2****************************************************************

<?php
$con = msql_connect();
if (!$con) {
die('Server connection problem: ' . msql_error());
}

if (!msql_select_db('test', $con)) {
die('Database connection problem: ' . msql_error());
}

$result = msql_query('SELECT id, name FROM people', $con);
if (!$result) {
die('Query execution problem: ' . msql_error());
}

while ($row = msql_fetch_array($result, MSQL_ASSOC)) {
echo $row['id'] . ': ' . $row['name'] . "\n";
}

msql_free_result($result);
?>

HAY ALGUNA FORMA DE LLAMAR SOLO ALGUNOS DATOS O OTRA FORMA