The code is
Code: Select all
$result2 = @mysql_query("SELECT maxsize, badge FROM classes where maxsize>0");
while($row = mysql_fetch_array( $result2 )) {
$maxsize = $row['maxsize'];
$badge = $row['badge'];
$stored_values = array($class1,$class2,$class3,$class4,$class5,$class6,$class7,$class8,$class9);
for ($i = 0; $i <= 9; $i++) {
if($badge==$stored_values[$i]) {
$checkmessage="Scout has chosen a class ($stored_values[$i]) with a max class size of $maxsize";
}
}
}
Code: Select all
$result3 = @mysql_query("SELECT * FROM classes where <<CLASS#>> = $stored_values[$i])");
Hopefully that makessense and someone can give me the probably very simple code to do it
Richard