Something

<?php

$connection = CONNECTION TO DB

$sql = "PUT YOUR SQL STATEMENT IN HERE";
$sql_result = mysql_query($sql, $connection) or die (mysql_error()); 
while ($row = mysql_fetch_array($sql_result))
{
// DO STUFF
echo "";

}

?>

// THIS WILL LIST EACH ITEM THAT COMES OUT OF THE SQL.  USE $row['fieldname'] to display items.