sql ?

  • hay all.

    Ok, sorta got done with what I could call my first real widget, it looks allows you to give it a list of blog id’s and it then lists the most recent post from them.

    I currently have it listing 3 blogs and a small sample from each of their most recent posts.

    The SQL calls im doing manually, because I dont know how to do it via wordpress, so my database password etc is all hardcoded which is fine if only I want to use it, but I might want to let others use it.

    So whats the wordpress method for calling sql queries and getting results. ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter dvalin

    (@dvalin)

    $result = $wpdb->get_results($SQL);
        //$result = mysql_query($SQL)  or die("A MySQL error has occurred.<br />Your Query: " . $your_query . "<br /> Error: (" . mysql_errno() . ") " . mysql_error());;

        while($row=mysql_fetch_assoc($result)){

    thats what I am trying to do but its not working.. the comment out is how I was doing it before.

    You don’t even need to query the database directly for this…

    WordPress has functions which let you switch which blog is currently being queried, so you could just switch to the differant ones, and then use query_posts as you would normally.

    The functions you want are

    switch_to_blog($blog_id);
restore_current_blog();

    Thread Starter dvalin

    (@dvalin)

    never mind solved the problem

    Thread Starter dvalin

    (@dvalin)

    Ah, I didnt know about those commands…

    What I am doing now is this.

    $sql2="SELECT wp_".$row['blog_id']."_posts.post_date, wp_".$row['blog_id']."_posts.post_title, wp_".$row['blog_id']."_posts.post_content, wp_".$row['blog_id']."_options.option_value,wp_blogs.blog_id,wp_blogs.domain FROM wp_".$row['blog_id']."_posts, wp_".$row['blog_id']."_options,wp_blogs WHERE option_name = 'template' and wp_blogs.blog_id='".$row['blog_id']."' AND post_type='post' AND post_status='publish' ORDER BY post_date DESC LIMIT 0,1 ";

    So with a single query I get out the info I need, that query is then part of a loop that goes through all the blogs we have.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘sql ?’ is closed to new replies.