If statement not working

[mrt003003]

Hi there im having trouble with my If statement in that its not doing what it is suppose to do!

 

I have a do loop that and If statament that checks that resultp < results. If it is less then an echo is suppose to happen, but its not. Im getting notice errors: Undefined index: Class1- 4 but nothing is outputted. I checked the records in the database so the condition will happen but nothings happening.

 

Help

 

 <?php do { ?>
    
    <?php 

echo $row_resultp['Class1_totla']; echo ' Class 1';
echo'<br>';
echo $row_resultp['Class2_totla']; echo ' Class 2'; echo'<br>';
echo $row_resultp['Class3_totla']; echo ' Class 3'; echo'<br>';
echo $row_resultp['Class4_totla']; echo ' Class 4';

echo'<br>';echo'<br>';echo'<br>';

echo $row_results['Class1_totlas']; echo ' Class 1';
echo'<br>';
echo $row_results['Class2_totlas']; echo ' Class 2'; echo'<br>';
echo $row_results['Class3_totlas']; echo ' Class 3'; echo'<br>';
echo $row_results['Class4_totlas']; echo ' Class 4';

if ($row_resultp['Class1'] < $row_results['Class1']){
echo 'you need';
echo $row_resultp['Class1'] - $row_results['Class1'];
echo 'more'; }

if ($row_resultp['Class2'] < $row_results['Class2']){
echo 'you need';
echo $row_resultp['Class2'] - $row_results['Class2'];
echo 'more';}

if ($row_resultp['Class3'] < $row_results['Class3']){
echo 'you need';
echo $row_resultp['Class3'] - $row_results['Class3'];
echo 'more'; }

if ($row_resultp['Class4'] < $row_results['Class4']){
echo 'you need';
echo $row_resultp['Class4'] - $row_results['Class4'];
echo 'more'; }

?>
    <?php } while ($row_resultp = mysql_fetch_assoc($resultp) && ($row_results = mysql_fetch_assoc($results))); ?>

[fugix]

an Undefined index: error indicates that either that index doesnt exist or hasnt been set

[mrt003003]

Hmm ok, i thought it was set, heres the code in full:

<?php $colname_results = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_results = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_results = sprintf("SELECT SUM(Class1) As Class1_totlas, SUM(Class2) As Class2_totlas, SUM(Class3) As Class3_totlas, SUM(Class4) As Class4_totlas FROM ships WHERE PlayerName = %s", GetSQLValueString($colname_results, "text"));
$results = mysql_query($query_results, $swb) or die(mysql_error());
$row_results = mysql_fetch_assoc($results);
$totalRows_results = mysql_num_rows($results);

$colname_resultp = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_resultp = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_resultp = sprintf("SELECT SUM(Class1) As Class1_totla, SUM(Class2) As Class2_totla, SUM(Class3) As Class3_totla, SUM(Class4) As Class4_totla FROM planet WHERE PlayerName = %s", GetSQLValueString($colname_resultp, "text"));
$resultp = mysql_query($query_resultp, $swb) or die(mysql_error());
$row_resultp = mysql_fetch_assoc($resultp);
$totalRows_resultp = mysql_num_rows($resultp);

<?php do { ?>
    
    <?php 

echo $row_resultp['Class1_totla']; echo ' Class 1';
echo'<br>';
echo $row_resultp['Class2_totla']; echo ' Class 2'; echo'<br>';
echo $row_resultp['Class3_totla']; echo ' Class 3'; echo'<br>';
echo $row_resultp['Class4_totla']; echo ' Class 4';

echo'<br>';echo'<br>';echo'<br>';

echo $row_results['Class1_totlas']; echo ' Class 1';
echo'<br>';
echo $row_results['Class2_totlas']; echo ' Class 2'; echo'<br>';
echo $row_results['Class3_totlas']; echo ' Class 3'; echo'<br>';
echo $row_results['Class4_totlas']; echo ' Class 4';

if ($row_resultp['Class1'] < $row_results['Class1']){
echo 'you need';
echo $row_resultp['Class1'] - $row_results['Class1'];
echo 'more'; }

if ($row_resultp['Class2'] < $row_results['Class2']){
echo 'you need';
echo $row_resultp['Class2'] - $row_results['Class2'];
echo 'more';}

if ($row_resultp['Class3'] < $row_results['Class3']){
echo 'you need';
echo $row_resultp['Class3'] - $row_results['Class3'];
echo 'more'; }

if ($row_resultp['Class4'] < $row_results['Class4']){
echo 'you need';
echo $row_resultp['Class4'] - $row_results['Class4'];
echo 'more'; }

?>
    <?php } while ($row_resultp = mysql_fetch_assoc($resultp) && ($row_results = mysql_fetch_assoc($results))); 
mysql_free_result($results);
mysql_free_result($resultp);

 

Wheres the problem with it?

 

 

Thanks

[minidak03]

Double check your array using print_r() to make sure everything is set correctly.

[mrt003003]

i have done and these are outputted:

echo $row_resultp['Class1_totla']; echo ' Class 1';
echo'<br>';
echo $row_resultp['Class2_totla']; echo ' Class 2'; echo'<br>';
echo $row_resultp['Class3_totla']; echo ' Class 3'; echo'<br>';
echo $row_resultp['Class4_totla']; echo ' Class 4';

echo'<br>';echo'<br>';echo'<br>';

echo $row_results['Class1_totlas']; echo ' Class 1';
echo'<br>';
echo $row_results['Class2_totlas']; echo ' Class 2'; echo'<br>';
echo $row_results['Class3_totlas']; echo ' Class 3'; echo'<br>';
echo $row_results['Class4_totlas']; echo ' Class 4';

 

Its just the if statement that doesnt work.

[fugix]

your if statements with $_SESSION['MM_Username'] arent working or your if statements with the classes?

[mrt003003]

The $_SESSION['MM_Username'] is working as i can confirm the data thats echoed. So the problems with the If statment with the classes.

[mrt003003]

I forgot to add the _totlas or _totla to the Class.. oops