get_results($sql); if (count($rs)<1) // not yet added { $sql="insert into island_like (user_id, post_id, date_added) values (\"".mysql_real_escape_string($uid)."\", \"".mysql_real_escape_string(get_the_ID())."\", NOW());"; $rs = $wpdb->get_results($sql); } } elseif (!empty($_REQUEST['remove_like']) && !empty( $uid)) { // unset here $sql="delete from island_like where user_id=\"".mysql_real_escape_string($uid)."\" and post_id=\"".mysql_real_escape_string(get_the_ID())."\";"; $rs = $wpdb->get_results($sql); } /* $sql="select U.display_name, U.user_nicename, U.id as uid, if(U.id=\"".mysql_real_escape_string($uid)."\",1,0) as is_current, if (U.id=19, 1,0) as is_allee ". "from island_like as L, wp_users as U ". "where L.post_id=\"".mysql_real_escape_string(get_the_ID())."\" ". "and U.ID=L.user_id ". "order by is_current DESC, is_allee DESC, date_added DESC;"; $jealous_rs = $wpdb->get_results($sql); $user_is_jealous=0; if (count($jealous_rs)>0) { if ($jealous_rs[0]->uid==$uid) { $user_is_jealous=1; } }*/ ?>

Giant Flea Welcomes You

Submitted by Nessa July 9th, 2010
slug=='certifikitsch-winners') { $is_award=1; } if ($cat->slug=='classique-d-camembert-winners') { $is_gold_award=1; } if ($cat->slug=='love-is-in-the-hair-award-winners') { $is_hair=1; } } // true added because this table will now always exist - jealous button if ($is_award || $is_gold_award || $is_hair || true) { $admin_email_pop_coa=$admin_email_pop_cdc=$admin_email_pop_liith=""; if ( current_user_can('level_10') ) { $now=gmdate("Y-m-d H:i:s"); $key=sha1("A".$now."B"); $the_title=single_post_title("", false); ?> Send Certifikitsch Confirmation Email to: ".get_the_author_meta('display_name').""; $admin_email_pop_cdc="
Send Classique d' Camembert Confirmation Email to: ".get_the_author_meta('display_name').""; $admin_email_pop_liith="
Send Love Is In The Hair Confirmation Email to: ".get_the_author_meta('display_name').""; } echo "
"; if ($is_award) { echo ''; echo 'Certifikitsch Winner'.$admin_email_pop_coa; } if ($is_gold_award) { echo ''; echo 'Classique d Camembert'.$admin_email_pop_cdc; } if ($is_hair) { echo ''; echo 'Love Is In The Hair'.$admin_email_pop_liith; } /* if (empty($uid)) { $str="Click if you\\'re Jealous!
(You must be logged in to be Jealous.)"; } elseif ($user_is_jealous) { $str="You are Jealous of this Kitsch!"; } else { $str="Click if you\\'re Jealous!"; } if (empty($uid)) { echo 'Jealous'; } elseif ($user_is_jealous) { echo 'Jealous'; } else { echo 'Jealous'; } if (count($jealous_rs)>0) { echo "(".count($jealous_rs).")"; } */ echo "
\n\n"; } ?>

This giant flea got me pretty excited about this flea market in Charleston, WV! Unfortunately, the flea market turned out to be mediocre at best, with too many bags of tube socks and budget-rate fireworks, and too few awesome kitschy vintage things. Of course it was like 100 degrees and I was dying of heat exhaustion, so maybe I just wasn’t looking hard enough.

The flea himself though was definitely worthy of a picture.

5 Responses to “Giant Flea Welcomes You”

  1. Allee Willis

    The flea himself is so promising so what a drag that it was a mediocre tube sock filled flea market. I hate when that happens. You can kind of feel it as soon as you walk in and certainly by the time that you’re at the end of the firs row. I sometimes make myself trudge through after that as you never know what one little treasure may be buried within but once it’s 100 degrees out I’d rather be anywhere than a bad flea market. Love the sign though.

    • Nessa

      Yeah, I think I spent about 80 cents, total, kind of a bummer. One of those places where everything good you find is 200% overpriced and everything else is junk… the hot weather definitely did not help.

  2. Mooshe

    I love his antennae flopping out of his hobo hat, and that cute little muzzle they gave him so you can always pretend he’s a rabbit if he’s a little too terrifying.