require('../classes/database.php');
$db = new database();
$res = $db->allResults("SELECT lead_id FROM wp_19_rg_lead_detail WHERE ((form_id = 1) && (field_number = 1))");
echo('Ilmoittautuneita on yhteensä '.count($res).' kpl.
');
echo('Nimi:
');
foreach($res as $r) {
if(count($db->allResults("SELECT lead_id FROM wp_19_rg_lead_detail WHERE ((form_id = 1) && (lead_id = '$r[lead_id]') && (field_number LIKE 26.1))")) == 0) {
$query = $db->query("SELECT value FROM wp_19_rg_lead_detail WHERE ((form_id = 1) && (lead_id = '$r[lead_id]') && ((field_number LIKE 6.3) || (field_number LIKE 6.6)))");
echo(mysql_result($query, 0).' '.mysql_result($query, 1).'
');
}
}
?>