Thread: Sort by $serverVotes - Import values from MySQL- rep++

Results 1 to 4 of 4
  1. #1 Sort by $serverVotes - Import values from MySQL- rep++ 
    Donate to Rune-Server
    Donate's Avatar
    Join Date
    May 2010
    Posts
    419
    Thanks given
    69
    Thanks received
    19
    Rep Power
    19
    Done, thanks for 1776 for script.

    - I would have done this myself in a second, but I have so confusing plans which aren't maybe using the best ways to do things
    so I thought it would be more difficult as I didn't think I could do it by normal script which loads data from MySQL database.

    Code:
    <?php
    
    $serverRank = 0;
    While(true) { $serverRank++; }
    
    $db_host = "";
    $db_user = "";
    $db_pass = "";
    $db_host = ""
    
    if (!@mysql_connect($db_host, $db_user, $db_pass)) {
        die("error connecting to database: " . mysql_error());
    }
    if (!@mysql_select_db($db_name)) {
        die("error selecting database: " . mysql_error());
    }
    
    $query = mysql_query("SELECT * FROM `table` ORDER BY `serverVotes` DESC;");
    if(mysql_num_rows($query) > 0) {
    while($results = mysql_fetch_assoc($query)) {
    echo $serverRank . " - " . $results['serverName'] . " - " . $results['serverVotes']; $serverRank++; }
    }
    
    ?>
    Thanks,

    Donate.

    I mean.

    Donate,

    thanks.
    Reply With Quote  
     

  2. #2  
    Donator


    Join Date
    Mar 2010
    Age
    28
    Posts
    637
    Thanks given
    50
    Thanks received
    82
    Rep Power
    189
    Quote Originally Posted by Jami View Post
    I need some script that imports all servers' names and votes from MySQL database and sort them for descending array like "$serverRank - $serverName" by value of "$serverVotes".
    PM me your table SQL and I'll do it for you.
    Reply With Quote  
     

  3. #3  
    Donate to Rune-Server
    Donate's Avatar
    Join Date
    May 2010
    Posts
    419
    Thanks given
    69
    Thanks received
    19
    Rep Power
    19
    Quote Originally Posted by Sloth™ View Post
    PM me your table SQL and I'll do it for you.
    I haven't even made it yet and I wouldn't give it. You know enough already.
    Thanks,

    Donate.

    I mean.

    Donate,

    thanks.
    Reply With Quote  
     

  4. #4  
    Donator


    Join Date
    Mar 2010
    Age
    28
    Posts
    637
    Thanks given
    50
    Thanks received
    82
    Rep Power
    189
    Quote Originally Posted by Jami View Post
    I haven't even made it yet and I wouldn't give it. You know enough already.
    Lmao.. Anyways, this can get you started.

    Code:
    CREATE TABLE IF NOT EXISTS `servers` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `server_name` varchar(32) COLLATE latin1_general_ci NOT NULL,
      `votes` int(11) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
    Code:
    $query = mysql_query("SELECT * FROM servers ORDER BY votes DESC") or die(mysql_error());
    while($row = mysql_fetch_assoc($query)) {
     $id = $row['id'];
     $name = $row['server_name'];
     $votes = $row['votes'];
     
     echo 'Server name:'.$name.' has '.$votes.' votes <br />';
    }
    This should work, writing it while playing xbox xD
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Replies: 5
    Last Post: 07-09-2011, 11:43 AM
  2. i need to know how to import mysql
    By humon99 in forum Help
    Replies: 0
    Last Post: 06-15-2011, 01:57 AM
  3. MySQL Help. Will rep++
    By Mister Maggot in forum Help
    Replies: 1
    Last Post: 12-17-2009, 11:57 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •