current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

here is the code

$result=mssql_query($query);

while($rows=mssql_fetch_array($result, MYSQL_NUM))
  {
  $subjectcode[] = "<tr><td>" . implode("</td><td>", $rows) . "</td></tr>";

  }

on my query i have 3 fields, subject1, grade and remarks..

for example the result of the query would be

math 1.55 NULL

now i want to evaluate the field (grade) so that i can insert to the implode part a pass or failed..probably i want to use an in statement inside the loop before the $subjectcode[]

share|improve this question
    
im sorry the while statement is like this----while($rows=mssql_fetch_array($result, MYSQL_NUM)) { $subjectcode[] = "<tr><td>" . implode("</td><td>", $rows) . "</td></tr>"; $counter++; } –  Gerald Mar 10 '11 at 21:46

2 Answers 2

up vote 0 down vote accepted

If you wanted to keep the grade and add another column you could do the following (above 40 is a pass)

$result=mssql_query($query);

while($rows=mssql_fetch_array($result, MYSQL_NUM))
{
    $rows[] = ($rows[1] > 40) ? "PASS" : "FAIL";
    $subjectcode[] = "<tr><td>" . implode("</td><td>", $rows) . "</td></tr>";
    $counter++;
}
share|improve this answer
    
thanks..should i have to include the question mark (?) –  Gerald Mar 10 '11 at 21:58
    
Yes, it's an inline if statement. –  spamoom Mar 10 '11 at 22:00
    
ahm what if $rows[1] is a string, how can i convert it to int? –  Gerald Mar 10 '11 at 22:27
    
PHP isn't usually bothered, but if you want to convert it to an int, you can typecast it. $rows[] = ((int)$rows[1] > 40) ? "PASS" : "FAIL"; –  spamoom Mar 10 '11 at 22:29
    
what if $rows[1] = "INC" or "incomplete" –  Gerald Mar 10 '11 at 22:34
up vote 0 down vote

Assuming $rows[1] is grade, and grade 1 failes, grater grades pass:

while(...) {
    if ($rows[1] > 1) {
        $rows[1] = "pass";
    } else {
        $rows[1] = "failed";
    }
    $subjectcode[] = "\n" . implode(" ", $rows) . "\n";
}
share|improve this answer
    
the implode part should be like this $subjectcode[] = "<tr><td>" . implode("</td><td>", $rows) . "</td></tr>"; –  Gerald Mar 10 '11 at 21:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.