PHP - Help With Order Of Code

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?

Hello,


I have classes in a database with no set UNIX date, just the day like Wednesday and in two other columns the start and end dates.


I want to be able to order by the day first and then by end_time but php orders the day column by spelling and not the day it holds in chronological order.


Is there anyway to change the query to order the day column as a date?


See the query below?


Code: [Select]
$query = "SELECT * FROM zumba_timetable WHERE end_time>'$current_time' ORDER BY day, end_time ASC LIMIT 0,1";

Hi there, just registered and in need of help, this looks a good place to start!
I'm a php beginner so please bear with me

I have a mysql database which holds 3 pieces of info
id:
match:
1:

I'm trying to sort the results using ORDER BY match ASC but for some reason it's just not for having it...
Can't work out if it's an error with my php code or my table. I can order by "ID" no problem but I when I try ordering alphabetically by "match" it won't.

my code is:

Code: [Select]
mysql_connect("***.***.***") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());


$query = "SELECT * FROM employees WHERE flag = 'tv' ORDER BY match ASC";
$result = mysql_query($query) or die ("Query failed");

$numrows = (mysql_num_rows ($result));


       

// loop to create rows
if($numrows >0){
echo "<table width = 100% border = '0' cellspacing = '2' cellpadding = '0' >";
// loop to create columns
$position = 1;
while ($row = mysql_fetch_array($result)){
if($position == 1){echo "<tr>";}
 
echo " <td align = 'center'><a href=\"http://www.website.eu/sport-stream/1/{$row['id']}.html\" target=_blank>{$row['match']}
<br>
<img src=\"{$row['8']}\" width=\"100\" height=\"70\" /> </a>
</td>

";
if($position == 4){echo "</tr> "; $position = 1;}else{ $position++;}
}//while

$end = "";
if($position != 1){
for($z=(4-$position); $z>0 ; $z--){
$end .= "<td></td>";
}
$end .= "</tr>";
}

echo $end."</table> ";
}//if
And here's a cap of my database:


any help for a php n00b would be greatly appreciated!

Hello All,   I've added search to my CMS and one column of data in particular is a date column. My whileLoop spits out data I want however it sorts the date field ASC but I need is DESC.  I've tried adding the ORDER BY in several different ways however I keep getting an error... what would be the best approach to get it to sort the way I want using my current SELECT statement

$search_sql = "	SELECT * 
		FROM tracking 
		INNER JOIN sender ON tracking_sender_id = sender_id 
		INNER JOIN method ON tracking_method_id = method_id 
		WHERE (tracking_recepient LIKE '%" . $_POST['search'] . "%')";

the above code works fine but the output sorts ASC, can seem to add the ORDER BY in an appropriate manner to get it DESC.  Any advice ?   Thank you in advance

Hi everyone,

I'm looking for a point in the right direction. I just about to start my biggest coding project yet. (A Simple PHP Order form).

The client has suggested that they want a form for users to enter a reference code (from a catalog) of a product type how many items they want. It will generate a sub total. And if the total is over a certain amount discount will be given.

The form will also have the regular form fields as well. e.g Name, email, address etc...

Then all this will post to a email. I've created contact form scripts before. But is there any links or tutorials that could help me do this or even point me in the right direction.

Thanks for all the help

Barry

Hi.  Right I'm trying to write a little script that selects one random image from a group and displays it on the page.  Here is my code...

$TheCat = $data['album_name'];
$GetAPicy = "SELECT photo_name, album FROM photos WHERE album = '$TheCat'  ORDER BY rand LIMIT 1"; 
$rGetAPicy = mysql_query($GetAPicy) or die(mysql_error());
$Picy = mysql_fetch_array($rGetAPicy);


With this code I get the following error

                         Unknown column 'rand' in 'order clause'

Obviously I can see the error but I dont understand where they are supposed to be placed.  Can anyone help?

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!'));
        }           
       
    }

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>";

Really need a hand from someone mysql query is pretty basic.

I have been ask to add a random order to this query.

 $query = "SELECT rd.user_id
            FROM {$regions_data_table} rd
            WHERE rd.field_id = {$regions_field_id} AND rd.value LIKE %s
                  AND rd.user_id NOT IN (SELECT um.user_id
                                         FROM {$wpdb->base_prefix}usermeta um
                                         WHERE ((um.meta_key='wp_ul_disabled' AND um.meta_value=1) OR (um.meta_key='wp_ul_inactive' AND um.meta_value=1))
                                         GROUP BY um.user_id)";

I have tried so many options but cannot seem to get it to work i am trying to insert order by rand().

Any help please?

Hey everybody, i'm building a website for the softball league i play in.... so far the website is pretty good... with all the stats and profiles.... i'm having a little problem with the ORDER of the leaders in the categories i have to calculate the result...

for example... avg. is the result of the total hits divided by the total number of at bats... both numbers are coming from the database... the problem comes when i have to order the leaders from first to last...

this is my php:

Code: [Select]
$sql = "select profile_id, SUM(total_hits) AS hitstotal, SUM(ab) AS abtotal from batters WHERE year = '2010' GROUP BY profile_id";

$cons = mysql_query($sql);
while ($result = mysql_fetch_array($cons)) {
$sumaab = $resultad['abtotal'];
$sumahits = $resultad['hitstotal'];
$p_id = $resultad['profile_id'];
$prom = round(($sumahits."") / ($sumaab.""),3);

that gives me all the batting averages for the players.

and here is my question:
how can i order that $prom result from first to last?

I have quite a long .php page but I've attached the end of it. I was wondering if I can change the order it is displayed. Basically $j is a year. And currently it goes from 1894 until 2019. I don't think anything is currently telling it to sort either way, it just by default shows that way. But I want it to show 2019 first and go down to 1894. I had this written for me by someone who I can no longer get hold of.

	$total_record=count($session_player);
	$i=0;
	$palyerslink="";
	foreach($session_player as $var=>$val)
	{
		$i++;
		if($i==$total_record)
			$palyerslink.="<a href='/history/?pid=$var' title='view this in more detail'>$val</a>";
		else
			$palyerslink.="<a href='/history/?pid=$var' title='view this in more detail'>$val</a>, ";
		
	}
	if(!empty($session_player))
	{
		$tr++;
		$records.="<tr class=row>
		            <td class=border-right><a href='/history/browse?season=$j'>$j-$value</a></td>
		            <td class=border-right>$max_goal_season</td>
		            <td>$palyerslink</td>
		            </tr>";
	}
}
$records.="</table></div>";
echo $records;
?>

 

This is the end of the page where the records are then displayed using the echo.

I'm not sure if more code is needed though, I could post it in full if needed

Edited May 29, 2020 by alxne

hi, i have a field for price that gets returned.

is there a way to do ORDER BY 'category' so that i can have tally at the bottom of each category that adds all the prices together?

Hi all,

I have a script that is essentially a log file of all preious versions of an article (versioning)

You can see the script I am talking about in action at:

http://danielrhyshardy.com/AWT/forumadmin.php

What I would like to do is, instead of displaying the title of each instance (you will see there are two instances named "apple", as they are two previous versions of an article), I would like to display that title once, and then all of the instances of that title be displayed below.

I hope that makes sense.

Here is the code Code: [Select]
<?

$sql = "SELECT id,title,message,date_added FROM messages2 ORDER BY id "; 
 
 
 
 
   $result = mysql_query($sql) or trigger_error(mysql_error(),E_USER_ERROR);
   
   



   while(list($id,$title,$message,$date_added)=mysql_fetch_row($result)){





     
echo '<div style="color:#bb0000;width:250px;text-align:center;float:left;margin-left:15px;margin-bottom:15px;padding-bottom:20px;"><b>'.$title.'<br>'.$date_added.'</b>
 
<input id="'.$message.'" type="radio" name="admin[]" value="'.$id.'"  onclick="javascript:document.form22.car.value=this.id"
  >


</font></div>'."\n";
   
   

   

 
}



?>

I would use something like
Code: [Select]
if ($title = "apple") {

but this would obviously not work for new posts, unless I wanted to constantly update my code.

I am sure there is a simple way to achieve this.

Perhaps someone can tell me!?

Thanks in advance

Dan

Currently I have where the User can search for records, then the records are displayed on a page. I then have a drop down box to where the user can Order by 2 different categories to make it easier for the user to see things but for some reason it is not working. Here is my code.

Oh and the error I get is mysql_num_rows(): supplied argument is not a valid MySQL result resource in

<?php
$qry_str="SELECT * FROM timeslip WHERE 1 ";  

if($_POST['Initials']) 
{ 
   $Initials=$_POST['Initials'];  
   $qry_str.="and Initials='$Initials' "; 
} 

if($_POST['Identifier']) 
{ 
   $Identifier=$_POST['Identifier'];  
   $qry_str.="and Identifier LIKE '%$Identifier%' "; 
} 

if($_POST['Type']) 
{ 
   $Type=$_POST['Type'];  
   $qry_str.="and Type LIKE '%$Type%' "; 
} 
if($_POST['Terms']) 
{ 
   $Terms=$_POST['Terms'];  
   $qry_str.="and Terms LIKE '%$Terms%' "; 
} 
if($_POST['Memo']) 
{ 
   $Memo=$_POST['Memo'];  
   $qry_str.="and Memo LIKE '%$Memo%' "; 
}
if($_POST['date1']) 
{  
   $date1=$_POST['date1'];
   $date2=$_POST['date2'];
   $start=date('Y-m-d', strtotime($date1));
   $end=date('Y-m-d', strtotime($date2));
   $qry_str.="and Date >= '$start' and Date <= '$end' "; 
}
if($_POST['order1'] && $_POST['order2'])
{
$order1=$_POST['order1'];
$order2=$_POST['order2'];
$qry=$_POST['qry'];
$qry_str="$qry ORDER BY $order1 ASC, $order2 ASC ";
}
if($_POST['order1'])
{
$order1=$_POST['order1'];
$qry=$_POST['qry'];
$qry_str="$qry ORDER BY $order1 ASC";
}
if($_POST['order2'])
{
$order2=$_POST['order2'];
$qry=$_POST['qry'];
$qry_str="$qry ORDER BY $order2' ASC ";
}
$result=mysql_query($qry_str); 
$count=mysql_num_rows($result); 
if ($count>0){

?>

<form action="" method="post">
<input type="hidden" value="<?=$qry_str?>" name="qry"/>
Order Results By
<select name="order1" >
<OPTION value="<?=$order1?>"><?=$order1?></OPTION>
<OPTION value="Identifier">Identifier</OPTION>
                <OPTION value="Type">Type</OPTION>
             <OPTION value="Terms">Terms</OPTION>
                <OPTION value="Date">Date</OPTION>
             <OPTION value="Cost">Cost</OPTION>
              
</select> 
Then
<select name="order2" >
<OPTION value="<?=$order2?>"><?=$order2?></OPTION>
<OPTION value="Identifier">Identifier</OPTION>
                <OPTION value="Type">Type</OPTION>
             <OPTION value="Terms">Terms</OPTION>
                <OPTION value="Date">Date</OPTION>
             <OPTION value="Cost">Cost</OPTION>
              
</select> 
<input type="submit" name="submit">
</form>

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');