PHP - Moved: Desc Sorting By Dateh

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=320518.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=310879.0

Glad to be back in the community 

Anyways I've got a mysql table with 4 different entries from a form.  One being an id with an auto-increment.  I'm wanting to arrange them into a table, descending by the id number.  I'm having a hard time wrapping my mind around how to even start it and get the other 3 fields to retrieve and be in a table together.  I have:

$db="prayers";
$link = mysql_connect('localhost', 'root' , '');
if (! $link) die(mysql_error());
mysql_select_db($db , $link) or die("Select Error: ".mysql_error());


$query = "SELECT * FROM table prayerwall BY id DESC LIMIT 10";  

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

Not sure how to retrieve the other entries and then put them into a table.  A start or some help would be greatly appreciated.  Thanks everyone!

Ok so here is my code. Ignore the $_POST['dobm']. That is part of the whole script.
All I want to know is how to set the list from 1998 to 1911 in descending order. I already tried making $i = 1998 and make $i - 1 til $i >= 1911. It seems to go in an infinite loop when I do that.

Code: [Select]
<?php
for($i = 1911; $i <= 1998; $i++)
{
if ($_POST['dobm'] == $i)
{
echo '<option selected="selected" value="'.$i.'">'.date('Y', mktime(0,0,0,0,0,$i+1)).'</option>\n';
}
else
{
echo '<option value="'.$i.'">'.date('Y', mktime(0,0,0,0,0,$i+1)).'</option>\n';
}
}
?>

Hello and Gm.
I have a script (below) which paginates a mysql table. Showing 4 rows per page. It works well.

   <?php

$sql = mysql_query("SELECT * FROM tablename ORDER BY id ASC");

$nr = mysql_num_rows($sql); 
if (isset($_GET['pn'])) { 
    $pn = preg_replace('#[^0-9]#i', '', $_GET['pn']); 
   
} else {
    $pn = 1;
} 

$itemsPerPage = 8; //number of rows per page 

$lastPage = ceil($nr / $itemsPerPage);

if ($pn < 1) {
    $pn = 1; 
} else if ($pn > $lastPage) { 
    $pn = $lastPage;
} 

$centerPages = "";
$sub1 = $pn - 1;
$sub2 = $pn - 2;
$add1 = $pn + 1;
$add2 = $pn + 2;
if ($pn == 1) {
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
} else if ($pn == $lastPage) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
} else if ($pn > 2 && $pn < ($lastPage - 1)) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub2 . '">' . $sub2 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add2 . '">' . $add2 . '</a> &nbsp;';
} else if ($pn > 1 && $pn < $lastPage) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
}

$limit = 'LIMIT ' .($pn - 1) * $itemsPerPage .',' .$itemsPerPage; 

$sql2 = mysql_query("SELECT * FROM tablename ORDER BY id ASC $limit"); //second query

$paginationDisplay = ""; 
if ($lastPage != "1"){
   
    $paginationDisplay .= 'Page <strong>' . $pn . '</strong> of ' . $lastPage. '&nbsp;  &nbsp;  &nbsp; ';
 
    if ($pn != 1) {
        $previous = $pn - 1;
        $paginationDisplay .=  '&nbsp;  <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $previous . '"> Back</a> ';
    } 
  
    $paginationDisplay .= '<span class="paginationNumbers">' . $centerPages . '</span>';

    if ($pn != $lastPage) {
        $nextPage = $pn + 1;
        $paginationDisplay .=  '&nbsp;  <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $nextPage . '"> Next</a> ';
    } 
}

$outputList = '';
while($row = mysql_fetch_array($sql2)){  


print "$row[permalink]";
print "$row[title]";

  } 
    
  ?>
</div>

  

<h2>Total Items: <?php echo $nr; ?></h2>
 
      <?php echo $paginationDisplay; ?>
      <?php print "$outputList"; ?>

        

What I would like to do is have it like you see on other sites where there is a drop down menu that one can sort by a column first and it paginates after.

So the url or dropdown would look something like

/paginatedfile.php/column_name=title&orderby=desc

And if you click page 2 you get a url like..

/paginatedfile.php/column_name=title&orderby=desc&pn=2

Can someone please help.


Thanks, Chris


 
 

Hi i am trying to change the query to sort by desc or asc I am using the switch method but the form is not calling the switch statment can someone help me out please?

this is the swicth script
Code: [Select]
switch ($sortby) {
    case "ASC":
        $args = array(
's' => $_GET['s'],
'post_type' => 'deals',
'orderby' => 'title',
'order' => 'ASC',
'paged' => get_query_var('paged')
);
    break;
    case "DESC":
                $args = array(
's' => $_GET['s'],
'post_type' => 'deals',
'orderby' => 'title',
'order' => 'DESC',
'paged' => get_query_var('paged')
);
        break;
}This is the form
Code: [Select]
<form name="myForm">
             <select id="sortby" >
                 <option value="ASC">ASC</option>
                 <option value="DESC">DESC</option>
            </select>
         </form>
I intend to use a onchange so that when depending on the option they select it will change the order?

I have a situation where I need to sort files on a screen based on the date that is embedded into the file name.  The problem is that I am sorting based off the file name, and when I get my output the LEGACY file always comes out on top of the sort because it starts with a 0 meanwhile the rest have dates appended the the filename so I don't have a problem sorting those.

Please help me if you can.
<?
//Special case for extra files
IF($Recordmyrow['App'] == "(Printable)")
{ 
$display = false;
$column3 = "Printable VER";
IF($securityvalue == "P")
{
    if(substr($path, 0, 5) == "file:")
    {
        $filename = substr($path, 5);
        if(file_exists($filename))
        {
$basename = substr($filename, 0, strrpos($filename, '.'));
$ext      = ".pdf";
$allfiles = glob("{$basename}*.pdf");
rsort($allfiles, SORT_NUMERIC);
 
            foreach($allfiles as $file)
            {
                if($ext == ".pdf")
                {
                    $column4 = "<a href=\"pdf.php?src={$file}\">VIEW</a><br />\n";
                    $codate = substr($file, 70, 8);
                    $co = substr($file, 59, 1);
                    if ($codate != "pdf")
                    {
                     $column3 = "Printable File - ".$codate;
                    }
                    elseif ($codate == "pdf")
                    {
                     $column3 = "Printable File - LEGACY";
                    }
                    
                     IF($lastGroup != $Recordmyrow['Grouping'])
{
$lastGroup = $Recordmyrow['Grouping'];
?>
<TR>
<TD colspan="4" align="center"  bgcolor="#418765"><B><FONT color="white"><? echo $Recordmyrow['Grouping'] ?></FONT></B></TD>
</TR>
<?
}

                     ?>
                    
<TR>
<TD class="display" align="center" bgcolor="<?=changeColor($rowcount)?>"><B><? echo $column1 ?></B></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>"><B><? echo $column2 ?></B></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>"><B><? echo $column3 ?></B></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>" align="center"><B><? echo $column4 ?></B></TD>
</TR>
<?
$rowcount++;
                }
                 }
        }
        else
        {
            $column4 = "Not Available";
             ?>
<TR>
<TD class="display" align="center" bgcolor="<?=changeColor($rowcount)?>"><B><? echo $column1 ?></B></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>"><B><? echo $column2 ?></B></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>"><B><? echo $column3 ?></B></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>" align="center"><B><? echo $column4 ?></B></TD>
</TR>
<?
$rowcount++;
        }
    }
}

                

}

Part of my code:

Code: [Select]
<?php

$arr = array ("Christina", "Daniel", "Andreea);
reset($arr);

foreach ($arr as $username) {

//more code here ...

foreach ($stats as $result) 
{
echo $username."'s points - ".$result."<br />";
}

}

?>

And gives this:
Code: [Select]
Christina's points - 14
Daniel's points - 45
Andreea's points 23

My question is: can you sort the the $result so it will show

Code: [Select]
Daniel's points - 45
Andreea's points 23
Christina's points - 14

Thank you

Hello.  I have a multi dimensional array that needs to be sorted. Array  top25 [index][product id][number_of_purchases].  The index will contain a unique number for each product id. First product will be 1, second product will be 2, etc.  The product id will be a id number like 34324ac9a89.  The number of purchases will be how many times the item has been purchased. 

- End result:  I want to print the 25 most purchased products in this format.

product id - number of purchases

a39acz   -  503
a8cz9c   - 480
zc8ac   -  392


How do I do this?  Thanks

Just a further question from a earlier post that was complete if i do a search and i want to order them from a drop box the if statement would it just look like
Quote

"select * from Table order by '".$_POST['order']."'"

Or would this not work ?


Thanx

I have an array like this:

$array[$row] = array (
    'name' = $name,
    'discount' = $discount,
    'price' = $price
);

Now, I have about 200 of those in that array, and im trying to sort by the discount, highest 1st. How would I go about doing that? Thanks.

i need to sort my database results by the day they were added to the database. There is a column with the timestamp of when they were inserted but how do i group them by the day they were inserted so i can display them as such:

Mon 14th: 5 records
Tues 15th: 11 records

etc.

hello, i have the following, which is sorting by id number with a horizontal line between.  im trying to make it so that it is sorted by supplier with lines between each letter.

Code: [Select]
<?php

if ($PreviousID!=0 && $ManID != $PreviousID) {?>
                          <hr />
                          <?PHP }
                          $PreviousID = $ManID;
 
include 'config.php';
include 'javascript.php';


@mysql_select_db ("citycore", $conn) OR DIE (mysql_error());

$sql = "SELECT * FROM supplier ORDER BY supplier";
$result = @mysql_query($sql, $conn) or die(mysql_error());
//$row2 = mysql_query($sql, $conn);
$PreviousID=0;
while ($row = mysql_fetch_array($result)) {
  $ManID = $row['id'];
  $id=$row['id'];
  $supplier=$row['supplier'];
  $address=$row['address'];
  $city=$row['city'];
  $province=$row['province'];
  $postal=$row['postal'];
  $phone2=$row['phone2'];
  $phone=$row['phone'];
  $fax=$row['fax'];
  $email=$row['email']; 
 
?>
<div align="center">
                              <table border="1" width="95%" style="border-collapse: collapse">
                                <tr>
                                  <td><?php echo $row['supplier'];?></td>
                                  <td><a href="http://mapof.it/<?php echo($address .' ' .$city .',' .' ' .$province .' ' .$postal); ?>" target="_blank"><?php echo($address .' ' .$city .',' .' ' .$province .' ' .$postal); ?></a></td>
                                </tr>
                              </table>
                              </div>

 <?PHP  } ?>

Hello,

Hope somebody can help me.
I have an XML file that is generated by active directory that dumps everything required for a telephone directory.
I currently present this using XSL but would like to move towards PHP.

I have some rudimentary code and it's working fine but I'd like to be able to sort by various values, such as First Name or telephone number.

My XML format looks like this:

Code: [Select]
<?xml version="1.0" encoding="UTF-8"?>
<telephonelist>
   <employee>
      <firstname>Jimmy</firstname>
      <lastname>Jimmerson</lastname>
      <email>jimbo@companyxyz.com</email>
      <extensionnum>956</extensionnum>
      <jobtitle>Security Officer</jobtitle>
      <department>Security</department>
   </employee>
   <employee>
      <firstname>David</firstname>
      <lastname>Davidson</lastname>
      <email>David.Davidson@companyxyz.com</email>
      <extensionnum>968</extensionnum>
      <jobtitle>Manager</jobtitle>
      <department>Management</department>
   </employee>
Any my current code looks like this:

Code: [Select]
<?
$myStaffMembers = new SimpleXMLElement("includes/telephonelist.xml", null, true);

echo <<<EOF
<table width="95%" border="0">
  <tr>               
<th><b>First Name</b></th>               
<th><b>Last Name</b></th>               
<th><b>Telephone Number</b></th>               
<th><b>Position</b></th>                       
  </tr>
EOF;

foreach($myStaffMembers as $myStaffMember)
{
echo "     
  <tr>               
<td>{$myStaffMember->firstname}</td>               
<td>{$myStaffMember->lastname}</td>               
<td>{$myStaffMember->extensionnum}</td>               
<td>{$myStaffMember->jobtitle}</td>                       
  </tr>";
}
?>
Appreciate any help anybody could give.

Thanks,
LJ

Hi - I'm modifying some PHP code that someone else wrote. Below is a snippet of code that basically takes mp3 files files within all the folders in a directory, and creates an RSS feed. In the resulting feed, the files are intermingled in date order.

Instead, I'd like them sorted by the directory that they are in. So, if there are files in these directories:

01-First
02-Second
03-Third

I'd like all the files in the "01-First" directory to come before the "02-Second" directory and so on. Within each directory the files can be sorted as they currently are.  The name of the directory in the code is signified by $dir_name.

I tried sort() and array_multisort() but I couldn't get either of them to work the way I wanted.  Any thoughts?


if ($url_params['mode'] == 'rss2') {

print getRSSHeader('UTF-8', $device, $vm_config, $vm_name, $web_master, $logo_image,$context);
    $mailboxes = array();
if ($dev_dir = @opendir($VMHome . $device)) { //might fail if mailbox has not received first message yet
while ($f = readdir($dev_dir)) {
     if (!eregi("tmp","$f") && !eregi("\.+","$f") && !eregi("Exclude-From-CD", "$f")) { //skip tmp directory and Exclude-From-CD Directories   
     array_push($mailboxes,"$f"); #collect all existing mailboxes
     }
  }
     array_multisort($mailboxes, SORT_DESC);
foreach ($mailboxes as $mailbox) {
$files=array();
$dir_name = $VMHome . $device . '/'. $mailbox .'/'; 
$dir = opendir($dir_name);
while ($f = readdir($dir)) {
  if (eregi("\.txt",$f)){ #if filename matches .txt in the name
     array_push($files,"$f"); #push into $files array
  }
}
foreach($files as $file){
   $props = getProperties($dir_name, $file);
   $uid = getMP3File($dir_name, $file, $props, $device, $mailbox, $vm_config, $vm_name,$context);
   print getRSSItem ($props, $uid, $dir_name, $device, '/' . $mailbox . '/', $context);      
}
}
}
print  '
</channel>
</rss>';
}