mysql_connect("localhost","root","");
mysql_select_db("mydatabase");
$query = "SELECT id, title FROM mytable ORDER BY title";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$title = $row['title'];
$id = $row['id'];
echo "Product: $title ($id)
}
?>