"; $query_result = mysql_query($query); $index = 0; $has_error = false; $errors = array(); while($row = mysql_fetch_assoc($query_result)){ $value = $row[$cross_ref_field."_0"]; $cross_ref_d = $row[$cross_ref_d_field."_0"]; $main_id = $row[$head_tag."_id"]; foreach($dialect_fields as $dialect=>$field) { $query = "SELECT count(*) FROM $main_table WHERE ".$field."_0 = \"$value\""; $r = mysql_query($query); $vals = mysql_fetch_assoc($r); $count = $vals["count(*)"]; if(eregi($dialect,$cross_ref_d)) { if($count < 1) { $has_error = true; $message = "dialect is $cross_ref_d but no entry exists with $field=$value"; } } else if($count > 0) { $has_error = true; $message = "dialect only contains $cross_ref_d but and an entry exists containing $field=$value"; } if($has_error) { $query = "SELECT ".$id_field."_0 FROM $main_table WHERE ".$head_tag."_id='$main_id'"; $foo = mysql_query($query); $id_row = mysql_fetch_assoc($foo); $id = $id_row[$id_field."_0"]; echo "$id : $message
"; $message = ""; $has_error = false; } } } ?>