SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Wizard Defender1's Avatar
    Join Date
    Apr 2001
    Location
    My Computer
    Posts
    2,808
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Two queries at once?

    how would i do both of these queries at once?
    PHP Code:
    SELECT from links WHERE cat_id '$cat' LIMIT $limitvalue$limit

    SELECT sum
    (ratings) as total from links_ratings WHERE id '$rate_row[id]' 
    also, how would i take the sum from that query, and divide it by the number of entrys to get the average of the ratings?
    Last edited by Defender1; Oct 9, 2001 at 22:06.
    Defender's Designs
    I'm Getting Married!

    Not-so-patiently awaiting Harry Potter Book 7 *sigh*

  2. #2
    SitePoint Wizard silver trophy Karl's Avatar
    Join Date
    Jul 1999
    Location
    Derbyshire, UK
    Posts
    4,411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    From the looks of things you're not going to be able to do them both at the same time, but I can solve your average problem, change:

    SELECT sum(ratings) as total from links_ratings WHERE id = '$rate_row[id]'

    to

    SELECT sum(ratings) as total, avg(ratings) as average from links_ratings WHERE id = '$rate_row[id]'

    and you should now have the average returned as well as the sum.
    Karl Austin :: Profile :: KDA Web Services Ltd.
    Business Web Hosting :: Managed Dedicated Hosting
    Call 0800 542 9764 today and ask how we can help your business grow.

  3. #3
    SitePoint Wizard Defender1's Avatar
    Join Date
    Apr 2001
    Location
    My Computer
    Posts
    2,808
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    well, i need to loop both of those queries so i can print out the links, and their ratings. here's the whole code so you can see what i mean
    PHP Code:
    <?
        $limit 
    20;
        
    $columns 3;

        
    $sqlcount"SELECT * from links WHERE cat_id = '$cat'"
        
    $sql_countresult mysql_db_query($db_name$sqlcount$db_connect) or die(mysql_error()); 
        
    $totalrows mysql_num_rows($sql_countresult) or die(mysql_error()); 

        if(empty(
    $page))
        { 
        
    $page 1
        } 

        
    $limitvalue $page*$limit-($limit); 

        
    $get_cat2 "SELECT * from links_catagories WHERE cat_id = '$cat'"// Get Current Catagory
        
    $do_cat2 mysql_db_query($db_name$get_cat2$db_connect);
        
    $get_row mysql_fetch_array($do_cat2);

        
    $id_query "SELECT * from links WHERE cat_id = '$cat' LIMIT $limitvalue$limit"// Get link id for rating
        
    $get_id mysql_query($id_query);
        
    $rate_row mysql_fetch_array($get_id);

        
    $get_cat "SELECT * from links WHERE cat_id = '$cat' LIMIT $limitvalue$limit"// Select all links where $cat = catagory id
        
    $do_cat mysql_db_query($db_name$get_cat$db_connect);

    ?>
         <td width="50%" colspan="2"><font face="verdana" size="5"><i><b><?=$get_row[catagory]; ?></b></i></font></td>
         <td width="50%" colspan="2"></td>
        </tr>
        <tr>
    <?
        $get_rate 
    "SELECT * from links_ratings WHERE id = '$rate_row[id]'"// get rating for links
        
    $do_rate mysql_query($get_rate);
        
    $show_rate mysql_fetch_array($do_rate);

        while (
    $result mysql_fetch_array($do_cat))
        {
        
    ?>
          <td width="20%" bgcolor="#520608"><font size="2" face="verdana"><b><i>
          <a href="/links/jump.php?id=<?=$result[id]; ?>" target="_blank"><?=$result[url_name]; ?></a></i></b></font></td>
          <td width="20%" bgcolor="#520608">
          <form action="/links/ratings.php" method="POST">
          <input type="hidden" value="<? echo "$CHARSET_HTTP_METHOD"$HTTP_HOST"$REQUEST_URI"?>" name="back_value">
          <input type="hidden" name="id" value="<?=$result[id]; ?>">
          <input type="Image" name="submit" src="/links/rate_it.jpg" border="0"></td></form>
          <td width="20%" bgcolor="#520608"><font size="2" face="Verdana">Rating: <?=$show_rate[rating]; ?></font></td>
          <td width="20%" bgcolor="#520608"><font size="2" face="Verdana"><?=$result[hits]; ?> hits</font></td>
        </tr>
        <tr>
          <td colspan="4" width="100%"><font size="1">&nbsp;&nbsp;<?=$result[description]; ?></td>
         </tr>
         <tr>
         <?
         
    }
    ?>
    At this point it just gets the rating of the first link and prints the same thing out for each of the links.
    Defender's Designs
    I'm Getting Married!

    Not-so-patiently awaiting Harry Potter Book 7 *sigh*


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •