PHP - 2 Way Sms Order System

I got this code from a previous thread:

Code: [Select]
mysql_query("SET @rows = 0;");
$res = mysql_query("SELECT @rows:=@rows+1 AS view_rank,COUNT(id) AS views, credit_members_id FROM vtp_tracking GROUP BY credit_members_id ORDER BY views DESC");
$n   = array(1 => 'st', 2 => 'nd', 3 => 'rd');
while($row = mysql_fetch_row($res))
{
   if ( $row[2] != $members_id )
      continue;
   if ( substr($row[0], -1) < 4 )
   {
      $row[0] .= $n[$row[0]];
   }
   else
   {
      $row[0] .= 'th';
   }
   echo ' You are in ' . $row[0] . ' place with ' . number_format($row[1]) . ' views.';
   break;
}
Everything seems ok except it orders by the "credit_members_id" and not "views" as entered.

Can someone explain why, and how to fix this?

Currently i have a query which at the end has this
Code: [Select]
order by (value/counter) desc");

which works fine, however i was wondering, if in the case that 2 rows have the same, is it possible to set a second value to order by?

I need to make 0, which displays as POA appear at the ned of the list not at the begining, I currently just use
order by price asc

and 0 is at the beginning, i need to make 0 at the end

Hello, I have a little thing I am making, and it is a Toplist. People can vote for a user, and then there vote will go up. But people can only vote once per day on one IP address.

I am having a problem ordering my front page by votes though. Here is my code for it to load the votes, and to display the user's on the list.

<?php
include 'vote.php'
    $list_q = mysql_query("SELECT * FROM toplist WHERE premium='1' && activated='1' && ban='0' && staff='0' ORDER BY '$voteAmount'") or die (mysql_error());
    while($list_f = mysql_fetch_assoc($list_q)) {
list ($error, $message, $voteAmount) = voteAmount(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME, $list_f['id']);
?>
<tbody style="" id="cat_1_e">
<!-- start: forumbit_depth2_forum -->
<tr>
<td class="trow2" align="center" valign="middle" width="1"></td>
<td class="trow2" valign="middle">
<strong><a href="server.php?view=details&id=<?php echo $list_f['id'];?>"><?php echo capitalizeFirstCharacter($list_f['servername']);?></a></strong><div class="smalltext"><?php echo $list_f['shortdescription'];?></div>
</td>
<td class='trow1' valign='middle' align='left' style='white-space: nowrap'><span class='smalltext'><?php echo $list_f['revision'];?></span></td>

<td class="trow2" valign="middle" align="right" style="white-space: nowrap"><font size="4px"><?php echo $voteAmount;?> Votes</font></td>
</tr>
<!-- end: forumbit_depth2_forum -->

</tbody>
<?php } ?>

And here is the code to my vote.php file that it loads all of the data from.
<?php
 function install($host, $user, $pass, $db) {
   $c = @mysql_connect($host, $user, $pass);
   if(mysql_select_db($db, $c)) {
     mysql_query('CREATE TABLE `'.$db.'`.`votes` (
                  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
                  `ip` VARCHAR(50) NOT NULL,
                  `serverId` INT(50) UNSIGNED NOT NULL,
                  `date` DATETIME NOT NULL,
                  PRIMARY KEY (`id`)
                ) ENGINE = InnoDB;');
     return true;
   } else {
      return false;
   } 
 }
 function voteAmount($host, $user, $pass, $db, $serverId) {
   $c = @mysql_connect($host, $user, $pass);
    if($c) {
      if(mysql_select_db($db, $c)) {
        if($getVotes = mysql_query('SELECT * FROM `'. $db .'`.`votes` WHERE serverId='. $serverId)) {
        if(mysql_num_rows($getVotes) >= 1) {
          $getVoteQ = mysql_query('SELECT COUNT(id) AS total FROM `'. $db .'`.`votes` WHERE serverId='. $serverId);
          $vote = mysql_fetch_assoc($getVoteQ);
          return array(0, "", $vote['total']);
        } else {
          return array(0, "", 0);
        }
       } else {
       if(install($host, $user, $pass, $db)) {
          return array(1, "The vote script has successfully been installed.<br>Please reload the page.", 0, 0);
      } else {
          return array(1, "Could not connect to DB.", 0);
      }
       }
      } else {
        return array(1, "Error connecting to DB.", 0);
      } 
    } else {
      if(install($host, $user, $pass, $db)) {
          return array(1, "The vote script has successfully been installed.<br>Please reload the page.", 0, 0);
      } else {
          return array(1, "Could not connect to DB.", 0);
      }
    }
 }              
// list ($error, $message, $voteAmount) = voteAmount('HOST', 'USER', 'PASS', 'DB', $_SERVER['REMOTE_ADDR'], SERVER_ID);
 function votedToday($host, $user, $pass, $db, $hours, $ip, $serverId) {
  $c = @mysql_connect($host, $user, $pass);
    if($c) {
      if(mysql_select_db($db, $c)) {
        if($getVotes = mysql_query('SELECT * FROM `'. $db .'`.`votes` WHERE ip="'. $ip .'"')) {
        if(mysql_num_rows($getVotes) >= 1) {
          $dateQ = mysql_query('SELECT MAX(date) AS lastVoteDate FROM `'. $db .'`.`votes` WHERE ip="'. $ip .'"') or die(mysql_error());
          $getDate = mysql_fetch_assoc($dateQ);
          $diffrence = time() - strtotime($getDate['lastVoteDate']);
          if (($diffrence / 60 / 60) >= $hours) {       
            mysql_query('INSERT INTO `'. $db .'`.`votes` (`ip`, `serverId`, `date`) VALUES ("'. $ip .'", '. $serverId .', NOW())') or die(mysql_error());
            return array(0, "Your vote has been added.");      
          } else {
            return array(1, "You can only vote every ". $hours ." hours. So far ". number_format(($diffrence / 60 / 60), 2) ." hours have past.");    
          }
        } else {
          mysql_query('INSERT INTO `'. $db .'`.`votes` (`ip`, `serverId`, `date`) VALUES ("'. $ip .'", '. $serverId .', NOW())') or die(mysql_error());
          return array(0, "Your vote has been added.");
        }
        } else {
          if(install($host, $user, $pass, $db)) {
             return array(1, "The vote script has successfully been installed.<br>Please reload the page.");
      } else {
          return array(1, "Could not connect to DB.");
      }        
        }
      } else {
          return array(1, "Error connecting to DB.");
      }   
    } else {
      if(install($host, $user, $pass, $db)) {
          return array(1, "The vote script has successfully been installed.<br>Please reload the page.");
      } else {
          return array(1, "Could not connect to DB.");
      }
    }
 }
 
// list ($error, $message) = votedToday('HOST', 'USER', 'PASS', 'DB', HOURS, $_SERVER['REMOTE_ADDR'], SERVER_ID);
?>


Once again, I am trying to make it so the list is ordered by how many votes that server has. Here is an example of the votes database.
Code: [Select]
CREATE TABLE IF NOT EXISTS `votes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(50) NOT NULL,
  `serverId` int(50) unsigned NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

INSERT INTO `votes` (`id`, `ip`, `serverId`, `date`) VALUES
(6, '::1', 4, '2010-08-07 11:44:44');

By not using the order by function in SQL.

Like I have $match_1 and $segment_1. They are two seperate tables so how would I order them like the ORDER BY in sql. Is there a way to do that?

I'm just trying to see if the order of my logic is correct or if there's something I can do differently.  I'm also curious to know at what point I should get the 2 passwords that exists in the database for the user. These are two different passwords.

Code: [Select]
function login_submit()
    {
        $this->form_validation->set_rules('username', 'Username', 'trim|required|xss_clean');
$this->form_validation->set_rules('password', 'Password', 'trim|required|xss_clean');
$this->form_validation->set_rules('remember', 'Remember me', 'integer');
       
        $user_id = $this->users->get_user_id_by_username($this->input->post('username'));
       
        if ($user_id !== 0)
        {
            if ($this->kow_auth->is_max_login_attempts_exceeded($user_id))
            {
                echo json_encode(array('error' => 'yes', 'message' => 'Your account is currently locked, we appologize for the inconvienence. You must wait 10 minutes before you can login again!'));
            }
            else
            {
                $user_status = $this->users->get_user_status($user_id);
               
                if ($user_status == 1)
                {
                    echo json_encode(array('error' => 'yes', 'message' => 'Sorry you must verify your account before logging in!'));                   
                }
                elseif ($user_status == 3)
                {
                    echo json_encode(array('error' => 'yes', 'message' => 'Your account has been suspended!'));         
                }
                elseif ($user_status == 4)
                {
                    echo json_encode(array('error' => 'yes', 'message' => 'Your account is currently banned!'));         
                }
                elseif ($user_status == 5)
                {
                    echo json_encode(array('error' => 'yes', 'message' => 'Your account has been deleted!'));     
                }
                else
                {
                    if ($this->form_validation->run()) {
                        if ($this->kow_auth->login($this->form_validation->set_value('username'), $this->form_validation->set_value('password'), $this->form_validation->set_value('remember')))
                        {
                            redirect('');
        }
                        else
                        {
                            echo json_encode(array('error' => 'yes', 'message' => 'Incorrect username and password combination!'));
                        }
                    }
                }                                             
            }               
        }
        else
        {
            echo json_encode(array('error' => 'yes', 'message' => 'Incorrect username and password combination!'));
        }           
       
    }

I want to get the top 5 rows with common keywords how can i do this?
its like this Code: [Select]
$query = "SELECT adder,min(title)FROM shsh group by adder order by mysql_num_rows($q)";

Hi All,

I have a 'Newspaper' in a game I'm coding. My plan was to have an edition every week and on average 15 articles a week. I would set this out like so. .

Code: [Select]
<?
$select_paper=mysql_query("SELECT * FROM paper WHERE id=1");
while($the=mysql_fetch_object($select_paper)){
?>
<table width=100% class=table>

<tr>
<td>
<td width=50% style=border: none; background-color: transparent; valign=top>


<table border=1 cellpadding=0 cellspacing=0 bordercolor=#000000 class='main' align=center>
<tr>
  <td width=500 class='tableheading'><?php echo "$the->title"; ?><center>
  </center></td>
  </tr>
<tr >
<td class="profilerow" align=left><center><?php echo "$the->news"; ?>
</td>
  </tr>
<tr >
<td  class="subtableheader" align=left><center><?php echo "Article By $the->by - $the->date"; ?>
</td>
  </tr>
  </table>
<br>
</td>
<? } ?>
With that repeated for 15 articles per edition.

BUT! To save time, space and complication, I would rather do it using something like this. .  Code: [Select]
$select = mysql_query("SELECT * FROM paper WHERE edition=1 ORDER by id ASC");
$num = mysql_num_rows($select);
Could someone tell me how to intergrate this with the layout tables as show in code #1?

Thanks!

I have a database of assorted.  Each row contains defined QUANTITIES for each column item.
Example: columns for shirt, tie, pants, socks.
A row would indicate a purchase of 2 shirts, 1 tie, 0 pants, 3 socks for customer A.
Followed by a row indicate a purchase of 1 shirts, 1 tie, 4 pants, 2 socks for customer B, etc.

Now I want to sort EACH item, group them by quantity, and get an ordered list by quantity, that provides me with something like this:

1 shirt customer B
2 shirt customer C
3 shirt customer F
3 shirt customer H
4 shirt customer D, etc.

I am using this code for my query:
$query = "SELECT brisket, COUNT(brisket) FROM pass GROUP BY brisket ORDER BY brisket ASC";

but it is not organizing the info in a correlated manner.

Help?

Greetings! I am really stock on this situation.

1. I have a variable $uc_order_created.
2. I have a code like this:

<b><?php echo t('Due Date:'); ?></b>
             </td>
                <td width="98%">
             <?php $duedate = mktime(0,0,0,date("m"),date("d")+30,date("Y"));
        echo "".date("F jS Y", $duedate);?>

3. How do I code if I want the result of $uc_order_created get displayed as Due Date using the code above? Or other modifications?
4. The situation now, the code is working when printing the invoice but its not based on $uc_order_created. So, every time I will edit the Order because of the change of items among others the Due Date will also update. All I want that when Order is edited the value of Due Date will still remain based on the $uc_order_created.

Thank you so much in advance for your help.

Hi i made a table which keeps player scores, but it is messed. Here's a link - http://kzlt.dev.lt/taure/rezultatai.php.  How can i fix it ?

The code:

$text .= "
<center><table border='1' width='565' height=30><tr><td width='15'>Nr.</td><td width='250'>&#38;#381aid&#38;#279jas</td><td width='150'><center>Ta&#38;#353kai</center></td><td width='150'><center>Dalyvavo</center></td></tr>";
$result = mysql_query("SELECT * FROM taure_lentele ORDER BY score DESC");
while($row = mysql_fetch_array($result))
{
if($rank == 1)
{
$color = "FF3300";
}
else if($rank == 2)
{
$color = "FF6600";
}
else if($rank == 3)
{
$color = "FF9900";
}
else
{
$color = "FFCC00";
}
$text .= '<tr bgcolor="'.$color.'">
<td width="15">'.$rank++.'</td>
<td width="250"><b>'.$row['name'].'</b></td> 
<td width="150"><center>'.$row['score'].'</center></td>
<td width="150"><center>'.$row['played'].' k.</center></td>
</tr></center>';
}
$text .= "</table>";

Hi

I can't get the ORDER BY to work correctly:

Code: [Select]
$getchallenges = safe_query("SELECT * FROM ".PREFIX."cup_challenges WHERE ladID='$laddID' AND challenger='$teamID' ORDER BY $order_date DESC");
   while($gc=mysql_fetch_array($getchallenges)) {

...
   if($gc['finalized_date'])
      $order_date = "finalized_date";
   elseif($gc['reply_date'])
      $order_date = "reply_date";
   else
      $order_date = "new_date";
...
}

Is it because of loop?

echo "order = $order_date";
output:

order =
order =
order = new_date

What I'm trying to achieve is to order by the latest date, but I have 3 date columns:

new_date
reply_date
finalized_date

Is it possible to order by multiple columns where largest to smallest?

how do I order two tables by date so that the most recent are first and the most unrecent last?  like table 1 should be first then a table 2 then a table 1.  does this make sense?

Hi, I've been trying to re-order an array and I can't seem to even do it let alone neatly. I've ran out of time and would appreciate any help!


$array = array(
  '0' => array(
    'filepath' => 'files/image_site1.png',
    'title' => 'Website',
  ),
  '1' => array(
    'filepath' => 'files/image_id.png',
    'title' => 'Identitity',
  ),
  '2' => array(
    'filepath' => 'files/image_site2.png',
    'title' => 'Website',
  )
)

I'm looking to re-order the arrays within the parent array depending on whether the 'filepath's contain a sub string of '_id' or '_site'.

I've been using:
$type = '_site';
foreach ($array as $item){
  if (preg_match("/$type/i", $item['filename'])){
    //add this $item to the top of array, somehow...
  }
}

So with $type set to '_site', I'd like to re-arrange the array so both arrays containing _site1.png and _site2.png appear at the top of the parent array. I.e:
$array('0' = array(...), '2' => array(...), '1' => array(...));

I hope I've explained it well enough.

Thanks,

I'm pulling a list from a DB and inserting it in a drop down menu. Each item on the list has a numerical id associated called marketid in the DB. It works, but it orders the list alphabetically. I need it to order by marketid which is the column name. What code do I need to add? Here is what I have now....

<option value="<?=$market['marketid']?>"><?=$market['name']?></option>

Thanks in advance all!!

Tony