DatabasesQuery

[php]
global $wpdb;
$sql=”SELECT * FROM forn_evr_event”;
$events = $wpdb->get_results($sql);

$i= 0;

$llocslliures= [];

if ( $events )
{
foreach ( $events as $evnto )
{
//Selecionem quantes persones hi han incrites:
$sql=”SELECT count(*) FROM forn_evr_attendee where event_id = $evnto->id “;
$Inscrits = $wpdb->get_var($sql);

//Quantes persones poden estar:    evnto->reg_limit;
//print(“$Inscrits/$evnto->reg_limit “);

$llocslliures[$i] = $Inscrits-$evnto->reg_limit;

//Id Event, + nom
//echo $evnto->event_name.” \n<br /> “;

$i++;
}
}

echo $llocslliures[1];

echo $llocslliures[2];
[/php]