[SOLVED] help with basic query

[gammaman]

I need help figuring out why my query is not updating the way it should.

 

foreach($Grade as $itm =>$value)
    {   

       print_r($value);
       mysql_query("Update Rcourse set Grade = '$value'  where Grade < 'A' AND StudentID='$itm' AND  CourseID='{$_SESSION['checkaddGrades']['course']}'")
          or die(mysql_error()); 
       
     
     
    } # end of foreach

 

Here is the array you are seeing from the foreach

 

Array ( [1] => A ) Array ( [311] => C+ )

 

I want the Grade to be set to either A or C+ depeding upon the studentID which is the key inside the [].

When I run it assigns the word array to just the first occurance of the query.

[rhodesa]

before the foreach, do a print_r($Grade); and post what that is...your array looks a bit weird

[gammaman]

This is what the Grade array has before the foreach loop

 

Array ( [0] => Array ( [1] => A ) [1] => Array ( [311] => C+ ) )

[rhodesa]

Yeah, that is what I thought it would be...it's just oddly structured...this should work for you though:

 

<?php
foreach($Grade as $set){
  foreach($set as $itm =>$value){
    print "Giving student $itm grade $value\n";
    mysql_query("Update Rcourse set Grade = '$value'  where Grade < 'A' AND StudentID='$itm' AND  CourseID='{$_SESSION['checkaddGrades']['course']}'")
      or die(mysql_error()); 
  }
}
?>

 

Not sure why you have "WHERE Grade < 'A'" either...but that is how you can get your array values properly

[rhodesa]

Also, in my opinion, the array should look like:

 

Array (
  [1] => A  
  [311] => C+
)

 

Then your original code would work

[gammaman]

Thanks a million that worked perfectly.