Support » Fixing WordPress » How can I use data from a mysql wordpress data base?

  • I need to show out of wordpress the title and date from a blog WordPress mysql Data Base. How could I make the request? Could you give me an example?

    I tried to do this but it doesn´t work (it is strange because with andother not-wordpress database it works well):

    <?
    //connect with database
    
    $connect=mysql_connect("localhost","myuser","mypassword");
    
    //select database
    
    mysql_select_db("mydatabase",$connect);
    
    //make querys
    
    $result=mysql_query("select * from wp_posts order by fecha DESC limit 0,20", $connect);
    $totalregistros=mysql_num_rows($result);
    
    //print results in array
    
    while($row=mysql_fetch_array($result))
    {
    echo $row[post_title];
    echo "";
    echo $row[post_date];
    }
    mysql_free_result($result)
    ?>

    Thanks for your answer. I need help!!!

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How can I use data from a mysql wordpress data base?’ is closed to new replies.