jQuery(document).ready(function($){
$('.spoiler_links').click(function(){
$(this).parent().children('div.spoiler_body').toggle('normal');
$(this).parent().css('background-color','#FFFFFF');
$('.spoiler_links').not(this).parent().css('background-color','#f5f5f5');
$('.spoiler_links').not(this).parent().children('div.spoiler_body').css('display','none');
return false;
}); });<?php $the_query = new WP_Query( 'showposts=4' ); ?>
<?php while ($the_query -> have_posts()) : $the_query -> the_post(); ?>
<li><a href="<?php the_permalink() ?>"><?php the_title(); the_date() ?></a></li>
<li><?php the_excerpt(__('(more…)')); ?></li>
<?php endwhile;?>
</ul>UPDATE table AS t1
JOIN (SELECT obj_id, MIN(float_val) AS 'f'
FROM table
WHERE field_id in (208, 209, 210)
GROUP BY obj_id) t2
ON cms3_object_content_copy.obj_id = t2.obj_id
SET rel_val = CASE WHEN f BETWEEN 0 AND 999 THEN 1
WHEN f BETWEEN 1000 AND 2000 THEN 2
ELSE 3
END
WHERE table.field_id = 402