Problem With Selecting From Database And Displaying Data

[Fluoresce]

Hi, guys.

 

I haven't been here for years! It's changed so much.

 

I am trying to get back into PHP, which I have almost completely forgotten! Please help me with the following question.

 

After selecting my data, how can I get 'name' to appear in my h1 element?

 

<?php

$conn = mysql_connect("localhost", "user", "pass") or die ("Unable to connect");
mysql_select_db ("database", $conn) or die ("Unable to select database");

$sql = "SELECT name, head, thumb, des
FROM people
WHERE catnum = 1
ORDER BY date DESC";
$rslts = mysql_query($sql, $conn) or die ("Unable to run query");

$num_rows = mysql_num_rows($rslts);

echo "<h1>WANT NAME HERE ($num_rows)</h1>";

while ($row = mysql_fetch_assoc($rslts))
{
echo "<ul>";
echo "<li>{$row['head']}</li>";
echo "<li>{$row['thumb']}</li>";
echo "<li>{$row['des']}</li>";
echo "</ul>";
}

mysql_close($conn);
?>

[Barand]

$rslts = mysql_query($sql, $conn) or die ("Unable to run query");

$num_rows = mysql_num_rows($rslts);

$row = mysql_fetch_assoc($rslts);

echo "<h1>{$row['name']} ($num_rows)</h1>";

do {
echo "<ul>";
echo "<li>{$row['head']}</li>";
echo "<li>{$row['thumb']}</li>";
echo "<li>{$row['des']}</li>";
echo "</ul>";
} while ($row = mysql_fetch_assoc($rslts));

Edited December 4, 2012 by Barand

[Fluoresce]

Thanks, Barand! It seems to be working well!