Why wont this work properly?

[LordBaby]

<?
$username="Blank";
$password="Blank";
$database="Blank";

$first=$_POST['first'];
$last=$_POST['last'];
$xero=$_POST['xeroe'];
$aol=$_POST['aol'];
$msn=$_POST['msn'];
$email=$_POST['email'];
$fcard=$_POST['fcard'];
$fdeck=$_POST['fdeck'];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO Members VALUES ('','$first','$last','$xero','$aol','$msn','$email','$fcard',$fdeck')";
mysql_query($query);

mysql_close();
?>
<?
$username="Dont Worry";
$password="Wont Worry";
$database="Dont WOrry";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM Members";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Members</center></b><br><br>";

$i=0;
while ($i < $num) {

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$xero=mysql_result($result,$i,"xero");
$aol=mysql_result($result,$i,"aol");
$msn=mysql_result($result,$i,"msn");
$email=mysql_result($result,$i,"email");
$fcard=mysql_result($result,$i,"fcard");
$fdeck=mysql_result($result,$i,"fdeck");

echo "First Name: $first<br>Last Name: $last<br>Xero: $xero<br>Aol: $aol<br>Msn: $msn<br>E-mail: $email<br>Favorite Card: $fcard<br>Favorite Deck: $fdeck<br><hr><br>";

$i++;
}

?>

it wont write or do anything anymore

[MykeXero]

i belive the problem is how you are processing the reuslt


<?
$username="Blank";
$password="Blank";
$database="Blank";

$first=$_POST['first'];
$last=$_POST['last'];
$xero=$_POST['xeroe'];
$aol=$_POST['aol'];
$msn=$_POST['msn'];
$email=$_POST['email'];
$fcard=$_POST['fcard'];
$fdeck=$_POST['fdeck'];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO Members VALUES ('','$first','$last','$xero','$aol','$msn','$email','$fcard',$fdeck')";
mysql_query($query);

mysql_close();
?>
<?
$username="Dont Worry";
$password="Wont Worry";
$database="Dont WOrry";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM Members";
$result=mysql_query($query);

//$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Members</center></b><br><br>";

//$i=0;
//while ($i < $num) {
while ($row = mysql_fetch_array($result) ) {



/*
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$xero=mysql_result($result,$i,"xero");
$aol=mysql_result($result,$i,"aol");
$msn=mysql_result($result,$i,"msn");
$email=mysql_result($result,$i,"email");
$fcard=mysql_result($result,$i,"fcard");
$fdeck=mysql_result($result,$i,"fdeck");
*/

$first = $row['first'];
$last = $row['last'];
$xero = $row['xero'];
$msn = $row['msn'];
$email= $row['email'];
$fcard = $row['fcard'];
$fdeck= $row['fdeck'];

echo "First Name: $first<br>
Last Name: $last<br>
Xero: $xero<br>
Aol: $aol<br>Msn: $msn
<br>E-mail: $email
<br>Favorite Card: $fcard
<br>Favorite Deck: $fdeck<br><hr><br>";

//$i++;
}

?>

[LordBaby]

alright look my site

http://www.sundrhosting.com/join.php

it still wont work

[LordBaby]

the file has to be .php correct?

[MykeXero]

Show what you have on teh script now. Cuse its saying stuff that isnt in what i see in your example. Maybe that can shed some light.