adding some "if"s at end of script.

[xwishmasterx]

I have a this piece of code, and simply need to make the last piece work:

$amount = $_POST['amount'];
.........
$query = mysql_query("SELECT * FROM teams WHERE team_id='$te' ") 
or die(mysql_error());
$result = mysql_fetch_array( $query );
if($result['team_treasure'] <= '$amount'){
echo "<br><br><div align='center'>Transfer Failed: Not enough credits</div>  ";}
else
{
echo "<br><br><div align='center'>Transfer Completed!</div>";}

 

It returns Transfer Completed!, no matter if team_treasure is higher or lower than $amount

[Fadion]

Remove single quotes in the variable, or you'll treat it as string.

 

Replace

if($result['team_treasure'] <= '$amount'){

 

with:

if($result['team_treasure'] <= $amount){

[Psycho]

Then echo the data to the page to validate your hypothesis. And, as GuiltyGear stated - compare it as a number, not a string

 

$amount = $_POST['amount'];

//.........

//Only query the field you need
$query = mysql_query("SELECT `team_treasure` FROM teams WHERE team_id='$te' ") 
    or die(mysql_error());
$result = mysql_fetch_assoc($query);
//Add a debug line:
echo "Result['team_treasure']:{$result['team_treasure']}, Amount:{$amount}<br>\n";
if($result['team_treasure'] <= '$amount')
{
    echo "<br><br><div align='center'>Transfer Failed: Not enough credits</div>  ";
}
else
{
    echo "<br><br><div align='center'>Transfer Completed!</div>";
}