prefix."people"); echo "\n"; } function people_list_ajax() { global $wpdb; $result = mysql_query("SELECT * FROM ".$wpdb->prefix."people ORDER BY last_name"); echo "\n"; } function people_get_random_bio() { global $wpdb; $row = mysql_fetch_array(mysql_query("SELECT COUNT(*) AS count FROM ".$wpdb->prefix."bios")); $count = $row[count]; $rid = rand(1,$count); people_get_bio_by_id($rid); } function people_get_bio_by_id($id) { global $wpdb; $result = mysql_fetch_array(mysql_query("SELECT id, uid, text FROM ".$wpdb->prefix."bios WHERE uid='$id'")); $presult = mysql_fetch_array(mysql_query("SELECT * FROM ".$wpdb->prefix."people WHERE id='$id'")); echo "

$presult[first_name] $presult[last_name]

\n"; $sections = explode("{more}",$result[text]); echo "
\n\t\n\t
$sections[0]"; if (count($sections) > 1) { echo "More"; echo "\n\t"; } echo "\n\t
\n
\n"; } function people_get_bio_by_slug($slug) { global $wpdb; $result = mysql_fetch_array(mysql_query("SELECT id FROM ".$wpdb->prefix."people WHERE slug='$slug'")); people_get_bio_by_id($result['id']); } ?>