floweringmind

This is how I got the info:
[code]
$value = $wpdb->get_results("SELECT option_value FROM wp_options WHERE option_name = 'wp_user_roles'");

$value = get_option('wp_user_roles');
[/code]

I figured it out. By the way I am using the attachment plugin but wanted the title and description of the image so that I didn’t have to re-enter it every time.

$querystr = “SELECT wposts.* FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta WHERE wposts.ID = “.$attachments[$i][‘id’];
$pageposts = $wpdb->get_results($querystr, OBJECT);
echo $pageposts[0]->post_title;
echo $pageposts[0]->post_content;