\n"; ?> http:/// http:///img/logo/logo.png Gasteizko Margolariak Gasteizko Margolariak \n"); echo("\t\t\thttp://$http_host/img/actividades/view/$r[image]\n"); echo("\t\t\t$r[title_es]\n"); echo("\t\t\n"); } $q = mysqli_query($con, "SELECT title_es, image FROM post_image, post WHERE post = post.id ORDER BY dtime DESC;"); while ($r = mysqli_fetch_array($q)){ echo("\t\t\n"); echo("\t\t\thttp://$http_host/img/blog/view/$r[image]\n"); echo("\t\t\t$r[title_es]\n"); echo("\t\t\n"); } $q = mysqli_query($con, "SELECT album.title_es AS album, photo.title_es AS photo, file FROM photo, album, photo_album WHERE photo.id = photo AND album.id = album ORDER BY uploaded;"); while ($r = mysqli_fetch_array($q)){ echo("\t\t\n"); echo("\t\t\thttp://$http_host/img/galeria/view/$r[file]\n"); if (strlen($r['photo']) == 0){ echo("\t\t\t$r[album]\n"); } else{ echo("\t\t\t$r[photo]\n"); } echo("\t\t\n"); } ?>