Neurotic Fishbowl: Correct Comment Leaders

« Spa Day | Main Index | Best. Day. Ever. »
comments | incoming pings | outgoing pings



strtotime ("March 21, 2003 05:47 PM")) { ?>

Correct Comment Leaders

Thanks to Kristine's simple instructions over at Scripty Goddess, I made a few queries in my PHPMyAdmin and combined e-mail address for a few people in my comments. This results in accurate data for the comment leader board in my sidebar. If you've changed your e-mail address from one you've commented with in the past, leave me the old one and the new one and I'll change them up.

.: Posted March 21, 2003 05:47 PM in Geeky Things, ";print substr($entry_cats, 0, -2); ?> :.


"; echo "Trackbacks on this post: ", $count, ""; $pingarray = "SELECT p.tbping_source_url, p.tbping_blog_name, p.tbping_created_on, p.tbping_excerpt, p.tbping_tb_id, t.trackback_id, t.trackback_entry_id FROM mt_tbping p, mt_trackback t WHERE (p.tbping_blog_id = $blogid) and (t.trackback_entry_id = $entry_id) and (t.trackback_id = p.tbping_tb_id)"; $resultping = mysql_query($pingarray) or die (mysql_error()); while ($row = mysql_fetch_array($resultping)) { //set up the variables being used - the date can be configured below $url = ($row['tbping_source_url']); $blog = ($row['tbping_blog_name']); $date = date("F d, Y g:i A", strtotime($row['tbping_created_on'])); $excerpt = ($row['tbping_excerpt']); echo "

", $excerpt, "

"; echo "
Posted by "; echo "", $blog, ""; echo " on ", $date, "
"; } ?>

Ping this post
http://www.neuroticfishbowl.com/mt/mt-tb.cgi/1364




"..."




Comments

I'm number 2! I'm number 2! Whoo hoo! I'm number 2!

.: Christine said on March 21, 2003 08:28 PM :: link it :.

I better post more often so I can get my numbers up! ;)

.: susan said on March 22, 2003 12:22 AM :: link it :.

You're too early! Come back at March 21, 2003 05:47 PM to see this post.

Post a comment*:
{HTML ok, IP address logged}

Name:


E-mail Address: (Optional)


URL: (Optional)


Add a smilie (launches smilie 'palette')

Comments:


Remember info?





Subscribe to post
Unsubscribe to post
(e-mail field must be filled in)
Enter e-mail address to subscribe/unsubscribe to comments on this post without having to post a comment:
Subscribe to post
Unsubscribe to post
E-mail:
(e-mail field must be filled in) -->

* Please note: Comments that are inappropriate will be deleted - mean, spiteful, rude comments. Don't let that stop you from posting comments. Just wanted to let you know the rules of the house.