PHP help

<?php
mysql_connect('username', 'password', 'server');
mysql_select_db('database');
$results = mysql_query('SELECT * FROM `table` WHERE `letter` = "'.$_GET['value'].'"')or die(mysql_error());
mysql_close();

$i = 0;
while($i < mysql_num_rows($result)){
     echo mysql_result($result, $i, 'field');
     $i++;
}

<?php 
$value=$_GET[letter];

//MYSQL QUERIE HERE

?>

<?php

//Gets the database information to carry out SQL tasks
include ("includes/config.php");

//Includes functions for menu items
include ("includes/functions.php");


	//SQL query to gather data
	$sql = "SELECT * FROM `cprofile` WHERE `club` = "'.$_GET['value'].'";
	$result = mysql_query ($sql); 

	$i = 0;
		while($i < mysql_num_rows($result)){
			echo mysql_result($result, $i, 'field');
			
			data selection and display code would go here?
			
			$i++;
} 

?>

$sql = "SELECT * FROM `cprofile` WHERE `club` = '".$_GET['value']."'";

function teamlist() {

	//Get letter of the club to display the
	//relevant page
	$value=$_GET[letter]; 


	//SQL query to gather data including the id
	//to pull out the correct data
	$sql = "SELECT * FROM `cprofile` WHERE `club` = '".$_GET['value']."'";  
	$result = mysql_query ($sql); 


	//While there are more results fill
	//the following variables
	while ($row = mysql_fetch_array($result))
	{
		$clubinfo= $row["club"];

		//Display the information as needed on the page
	echo '<table>';
	echo '<tr>';
	echo '<td> '.$clubinfo.' </td>';
	echo '</tr>';
	echo '</table>';
	}
}

<?php
echo "<a href="listclub.php?A">A</a><a href="listclub.php?B">B</a>";
?>

<?php

$pageid = $QUERY_STRING;
if ($QUERY_STRING == "")
{
$pageid = A;
}

echo "The passed variablee is $pageid";
//Now process the query here


?>