get_results('SELECT gid,previewpic,title,name FROM wp_dnag_ngg_gallery'); print_r($galleries); foreach($galleries as $gallery){ $previewpic_id = $gallery->previewpic; $gallery_id = $gallery->gid; $gallery_title = $gallery->title; $gallery_name = $gallery->name; $picture = new stdClass; $picture = $wpdb->get_results('SELECT filename,description FROM wp_dnag_ngg_pictures WHERE pid = '. $previewpic_id); $picture = $picture[0]; $previewpic_filename = $picture->filename; $previewpic_description = $picture->description; $pictures = new stdClass; $pictures = $wpdb->get_results('SELECT pid,filename,description FROM wp_dnag_ngg_pictures WHERE galleryid = '. $gallery_id); $siteurl = get_bloginfo('url'); $qnt_images = intval($wpdb->get_var("SELECT COUNT(*) FROM wp_dnag_ngg_pictures WHERE galleryid = ".$gallery_id)); $img_url = $siteurl.'/wp-content/gallery/'.$gallery_name.'/'.$previewpic_filename; $content = '
'; $content .= ' '; $content .= '
'; $content .= ' '.$previewpic_description.''; $content .= '
'.$gallery_title.'

'.$qnt_images.' Fotos

'; $i = 0; while($i <= sizeof($pictures)-1){ $picture_filename = $pictures[$i]->filename; $picture_description = $pictures[$i]->description; $picture_url = $siteurl.'/wp-content/gallery/'.$gallery_name.'/'.$picture_filename; if($pictures[$i]->pid != $previewpic_id){ $content .= ' '; } $i++; } $content .= '
'; echo $content; } ?>