$link=mysql_connect("localhost","parquead_blog","4p1R5dgY");
mysql_select_db("parquead_blog",$link);
$consulta="SELECT *
FROM `wp_posts` , wp_term_relationships
WHERE wp_posts.ID = wp_term_relationships.object_id
AND term_taxonomy_id = '8' AND `post_status` = 'publish'
ORDER BY `post_date` DESC;";
//echo $consulta," ";
$sql=mysql_query($consulta,$link);
while ($row=mysql_fetch_array($sql)){
$fecha=substr($row['post_date'],0,11);
echo " ", fecha_espanol($fecha), " - ", $row['post_title'], " - leer más", " ";
}
?>
|