little help please

[porko2004]

Im making this script it all works fine but doesn't show what u wont it to show.

 

I think this is the problem but not sure

echo "Please use this ID to move your character:  <b>$row[1]</b><br>";

 

<?php
$connection=mysql_connect("localhost","test","test");
$db=mysql_select_db("account_zf",$connection);
$result = mysql_query("select password, id from account where name='$_POST[username]'") or die(mysql_error());
if(!$result)
{
echo "Account ID does not exist.";
echo '<br><br><a href="unstick.htm">Return to UnStick Player page</a>';
}
else
if (!$_POST['username'] )
{
die('You did not fill the Account ID field <br><br> <a href="unstick.htm">Return to UnStick Player page</a>');
}
else
if (!$_POST['password'] )
{
die('You did not fill the Password field  <br><br> <a href="unstick.htm">Return to UnStick Player page</a>');
}
if($_POST['password']!= mysql_result($result, 0))
{
echo "Password invalid.";
echo '<br><br><a href="unstick.htm">Return to UnStick Player page</a>';
}
else
{
echo "Please use this ID to move your character:  <b>$row[1]</b><br>";
}
?>

[redarrow]

what is this suppose to mean please got me .......

 

if($_POST['password']!= mysql_result($result, 0)) << what that array 0

 

if so why seeing array $row[1]

 

if($_POST['password']!= mysql_result($result, 0))
{
echo "Password invalid.";
echo '<br><br><a href="unstick.htm">Return to UnStick Player page</a>';
}
else
{
echo "Please use this ID to move your character:  <b>$row[1]</b><br>";
}