[insert_php] global $wpdb;

$settore=$_GET[‘settore’];
$ruolo=$_GET[‘ruolo’];
$location=$_GET[‘location’];

$query = “SELECT id, title, description, shortdescription, projectid FROM jobalert where expiration_date >= now() and poligrafico = \”SI\””;

if(!empty($settore))
{
$settore = urlencode($settore);
$settore = strtoupper($settore);
$query = $query . ” and settore = \”$settore\” “;
}
if(!empty($location))
{
$query = $query . ” and shortdescription = \”$location\” “;
}
if(!empty($ruolo))
{
$query = $query . ” and description like ‘%$ruolo%’ “;
}
$query = $query . ” order by date desc limit 100″;

// echo “$query”;

$risultati = $wpdb->get_results($query);
foreach ($risultati as $result)
{
$id=urldecode($result->id);
$title=urldecode($result->title);
$reference =urldecode($result->projectid);
$description=urldecode($result->description);
$shortdescription=urldecode($result->shortdescription);

$pos = strpos($description, “\n”, strpos($description, “\n”) + 1);
$pos++;
$pos = strpos($description, “\n”, $pos);
$description = substr( $description, 0, $pos );
$description=$description.”\n”;

echo “

“;
echo “$title”;
echo “

“;
echo “$description”;
echo “
“;

echo “ $shortdescription “;

echo “

“;

echo “

“;

}[/insert_php]