[insert_php]
$list = array(“Viale Piave 51, Brescia”, “Piazza Garibaldi 23, Gavardo”, “Via Mazzini 3, Gussago”, “Via Milano 33, Cremona”, “Piazza Duomo 45, Manerbio”);
$index = (rand(1,5));
//print_r($_REQUEST);
global $wpdb;

$submit_timeresult = $wpdb->get_row(“SELECT submit_time FROM wp_cf7dbplugin_submits WHERE field_name =’n_sinistro’ and field_value=’$_REQUEST[n_sinistro]'”);

$sql = “SELECT * FROM wp_cf7dbplugin_submits where submit_time=’$submit_timeresult->submit_time’ and field_value<>””;

$result = $wpdb->get_results($sql);
if($_REQUEST[n_sinistro]!=”){
echo ‘

‘;
foreach($result as $key=>$row) {
if($key==$wpdb->num_rows-4){
break;
}
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo $row->field_name;
echo ‘		 ‘;
echo $row->field_value;
echo ‘
‘;
echo ‘ubicazione’;
echo ‘		 ‘;
echo $list[$index];
echo ‘

‘;
}

[/insert_php]