YAY! Noobish question

Kakashi

Hey gurus 🙂

I'm attempting to do something that most of you will see as very simple. I'll admit my noobishness with PHP right now. I've muddled through many thing and I'm starting to get the hang of things.

What I'm confused about is syntax. In the following code I'm attempting to do a simple (so I thought) If/Then statement to echo "Done" or "Not Done" if the value of $policy, which should correspond to an enumerated field called 'afterkick_rev' to which the values are 'Covered', 'Not Covered', is equaled to "Covered". So far the only results I get are "Not Done", even though there are 2 records each with a different value entered.

$data = mysql_query("SELECT * FROM test WHERE trainer='Kàkà§hì'")
or die(mysql_error());

$policy = array('afterkick_rev');
$result = "Covered";

//Code for summary table
while($info = mysql_fetch_array( $data ))
{
if ($policy == $result)
echo "Done";
else echo "Not Done";
}
?>

I know...I know...my code is silly and it's obvious why it doesn't work right :p I come with my hat in my hand 😃

devinemke

$result = mysql_query("SELECT * FROM test WHERE trainer = 'Kàkà§hì'") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['afterkick_rev'] . '<br>';	
}

Kakashi

Thanks for the quick reply! And yes, that does echo the actual data in that field, but I guess I was a little vague on what I was trying to do.

Instead of echoing "Covered", or "Not Covered", which are the actual values, I wanted to 'mask' these values with "Done", or "Not Done". The reason is that that field is the last in a series of things that needs to be completed for the trainee to be considered "Done" with training, so I thought that I could simply 'mask' that value for this field with something that indicated the training to be complete. I still need the actual value to remain as "Covered" or "Nor Covered" for other tables elsewhere.

devinemke

$array = array(
'Covered' => 'Done',
'Not Covered' => 'Not Done'
);

$result = mysql_query("SELECT * FROM test WHERE trainer = 'Kàkà§hì'") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $array[$row['afterkick_rev']] . '<br>';	
}

Kakashi

You're on my Christmas list! Worked like a charm! Thanks for the help, and knowledge 🙂