PHP - Sort Images By Newest To Oldest

Now im trying to do one more thing, that if I make another row with the value 2 for the type of news it is, I want to automatically turn the oldest news with the value 2 in the type column to '3'.

Is there any kind of query to update the row to '3' if a row is found with the same value and update the oldest news that was posted with the value 2. Also, I want it to work that if only there are 3 rows in there with the same value.

Id be happy if I could get some help.

Is there anything that can do it like that? or can that not be created?

hi, i want to select the 5 newest records from a table in the database. the date they were entered is in a column called post_time and this is a timestamp(000-00-00 00:00:00). how would i go about this?

Good morning. I need to subtract stock levels from oldest stock first then to the next date.

It is allowed to move into negative values.

example

01-10  stock in 10  stock out 5 - stock count 5

02-10 stock in 10 stock out 7 stock count ... here we need to subtract the 7 from previous days 5 til it reches 0  then stock in subtraction

 01-10 stock =0

02-10 stock = 8 --- as 7 -5 gives me -2 in incoming stock is 10 leaving me with stock count of 8.

03-10 stock in 8 stock out 21 

02-10 stck level must be    0

03-10 stock lever now is 8-14 = -6 and so on

below is my code. 

    $lq_in = new ListQuery('stock_audit5f5795042f369');
    $lq_in->addSimpleFilter('name', '%PEPPER yellow%', 'LIKE' );
    //$lq_in->addSimpleFilter('product_id', $product_id, '=');
    $lq_in->setOrderBy('date_entered');
    $res_in = $lq_in->fetchAll();
$StockArray = [];
foreach($res_in as $out_rec) {
    /*$upd_out = array();
    $upd_out['stock_out_done'] = 0;

    $out_rec_u = ListQuery::quick_fetch('stock_audit5f5795042f369', $out_rec->getField('id'));
    $aud_upd_out = RowUpdate::for_result($out_rec_u);
    $aud_upd_out->set($upd_out);
    $aud_upd_out->save();
    continue;
    */
    $stock_out = $out_rec->getField('stock_out');
    $stock_out_done = $out_rec->getField('stock_out_done');
    $date_entered = $out_rec->getField('date_entered');
    $product_id = $out_rec->getField('product_id');

    
    //echo '<pre>';
   // print_r($out_rec->row);
    $StockItems[] = $out_rec->row;

    //$stock_done = 0;
    /*
    foreach($res_in as $in_rec) {
        $upd = array();
        if($stock_out_new > $in_rec->getField('stock_level')) {
            $upd['stock_level'] = 0;
            $stock_out_new = $stock_out_new-$in_rec->getField('stock_level');
            $stock_done = $in_rec->getField('stock_level');
        } elseif ($stock_out_new == $in_rec->getField('stock_level')) {
            $upd['stock_level'] = 0;
            $stock_out_new = 0;
            $stock_done = $stock_out;
        } elseif($stock_out_new < $in_rec->getField('stock_level')) {
            $upd['stock_level'] = $in_rec->getField('stock_level')-$stock_out_new;
            $stock_out_new = 0;
            $stock_done = $stock_out;
        } else {
            continue;
        }

        $in_rec_u = ListQuery::quick_fetch('stock_audit5f5795042f369', $in_rec->getField('id'));
        $aud_upd = RowUpdate::for_result($in_rec_u);
        $aud_upd->set($upd);
        $aud_upd->save();

        if($stock_out_new == $stock_done)
            break;
    }
    
    $upd_out = array();
    $upd_out['stock_out_done'] = $stock_done;

    $out_rec_u = ListQuery::quick_fetch('stock_audit5f5795042f369', $out_rec->getField('id'));
    $aud_upd_out = RowUpdate::for_result($out_rec_u);
    $aud_upd_out->set($upd_out);
    $aud_upd_out->save();
    */
}
function GetFirstItemWithStockKey($StockItemsarrayk = null){
    if($StockItemsarrayk != null){
        foreach($StockItemsarrayk as $key => $value){
            if(((int) $StockItemsarrayk[$key]['stock_level']) > 0){
                return $key;
            }
        }
    }
}

function SetFirstItemWithStock($StockItemsarray = null){
    if($StockItemsarray != null){
        foreach($StockItemsarray as $key => $value){
            if(((int) $StockItemsarray[$key]['stock_level']) > 0){
                return $StockItemsarray[$key];
            }
        }
    }
}
$remainder = 0;
$pkey = "";
$StockLevelKey = 0;
$StockIn = [];
$StockOut = [];
$InStock = [];

$NewStockItems = $StockItems;
$ArrayKeys = [];
foreach($StockItems as $key => $value){
  $StockIn[$key] = (int) $StockItems[$key]['stock_in'];
  $StockOut[$key] = (int) $StockItems[$key]['stock_out'];
  $InStock[$key] = (int) $StockItems[$key]['stock_level'];
  $ArrayKeys[] = (int)$key;
  
}
//var_dump($InStock);
foreach($NewStockItems as $key => $value){
    if($key < 1){
        if($StockIn[$key] > 0 && $StockOut[$key] == 0 && $InStock[$key] == 0){
            $StockItems[$key]['stock_level'] = ($InStock[$key] + $StockIn[$key]);     
        }
        if($StockIn[$key] == 0 && $StockOut[$key] > 0 && $InStock[$key] == 0){
            $StockItems[$key]['stock_level'] = ($InStock[$key] - $StockOut[$key]);
         
        }
        if($StockIn[$key] > 0 && $StockOut[$key] > 0 && $InStock[$key] == 0){
            $StockItems[$key]['stock_level'] = ($InStock[$key] - $StockOut[$key] + $StockIn[$key]);
            $StockItems[$key]['stock_out'] = 0;
        }
    }
    if($key > 0){
        $previousWithStockItem = SetFirstItemWithStock($StockItems);
        $previousItemWithStockKey = GetFirstItemWithStockKey($StockItems);
       // echo "<pre>";
      //  print_r($previousWithStockItem);
       // var_dump($StockIn[$key]); echo "&nbsp;&nbsp;&nbsp;&nbsp;--IN";
      //  var_dump($InStock[$key]); echo "&nbsp;&nbsp;&nbsp;&nbsp;--- current";
       // var_dump($StockOut[$key]); echo "&nbsp;&nbsp;&nbsp;&nbsp;--- OUT";
        while($StockOut[$key] > 0){
            if($StockOut[$key] > 0 && $previousWithStockItem['stock_level'] > 0){
                $Counter = 0;
                $maxIteration = 0;
                for($Counter = $previousWithStockItem['stock_level']; $Counter >= 0; $Counter--){
                    $StockItems[$previousItemWithStockKey]['stock_level'] = $Counter;
                    if($Counter == 0){
                         $StockOut[$key] = $StockOut[$key] - $maxIteration;
                    }
                    $maxIteration++;
                }
            }
            if((((int) $StockItems[$key]['stock_level'] < 0) || ((int) $StockItems[$key]['stock_level'] === 0))&& ($StockIn[$key] > 0)){
                $valueTotal = $StockItems[$key]['stock_level'] + $StockIn[$key];
                $StockItems[$key]['stock_level'] = $valueTotal;
            }
            echo "<hr/>";
            echo (int) $StockOut[$key];
            echo "<br/>";
             echo (int) $StockItems[$key]['stock_level'];
            echo "<br/>";
             echo "<hr/>";
            if(((int) $StockOut[$key] > 0) && ((int) $StockItems[$key]['stock_level'] > 0) && ((int) $StockItems[$key]['stock_level'] > $StockOut[$key])){
              
                $newStockLevel = $StockItems[$key]['stock_level'] - $StockOut[$key];
                echo $newStockLevel;
                $StockItems[$key]['stock_level'] = $newStockLevel;
                $StockItems[$key]['stock_out'] = 0;
                $StockOut[$key] = 0;
            }
            if((((int) $StockItems[$key]['stock_level'] < 0) || ((int) $StockItems[$key]['stock_level'] === 0))&& ($StockIn[$key] > 0)){
                $valueTotal = $StockItems[$key]['stock_level'] + $StockIn[$key];
                echo $valueTotal;
                $StockItems[$key]['stock_level'] = $valueTotal;
            }
        }
    }
}
echo "<table><tr><td><pre>";
print_r($NewStockItems);
echo "</pre></td><td><pre>";
print_r($StockItems);
echo "</pre></td></table>";
/*
        if($StockIn[$key] > 0 && $StockOut[$key] >0 && $InStock[$key] == 0){
            $StockItems[$key]['stock_level'] = ($InStock[$key] + ($StockIn[$key] + $StockOut[$key]));
            
            $StockOut[$key] = 0;
            $StockItems[$key]['stock_out'] = 0;
        }
        if($StockIn[$key] != 0 && $StockOut[$key] != 0 && $InStock[$key] != 0){
            $StockItems[$key]['stock_level'] = ($InStock[$key] - ($StockOut[$key] + $StockIn[$key]));
            
            $StockOut[$key] = 0;
            $StockItems[$key]['stock_out'] = 0;
        }*/
/**
 @Rule 1 
 # Stockin has value and stock_out = 0 and stock_level = 0 and stock_out_done = null, actualstock to show actual stock level;
 # 
 
 */

/*if($StockCalculation[$Skey]['stock_out'] >= $StockItems[$key]['stock_level']){
                           $StockItems[$key]['stock_out'] = ($StockItems[$key] - 1);
                           $StockItems[$key]['stock_level'] = ($StockItems[$key]['stock_level'] - 1);
                           // If StockOut == 0 next StockOutItem
                           if($StockCalculation[$Skey]['stock_out'] == 0){
                               $remainder = 0;
                                continue;
                           }elseif($StockItems[$key]['stock_level'] == 0){
                               //CurrentInStock == 0 then continue to next CurrentItem
                                $remainder = $StockItems[$key]['stock_out'];
                                continue(2);
                           }
                       }
 $CurrentStockIn = $StockItems[$key]['stock_in'];
   $CurrentStockOut = $StockItems[$key]['stock_out'];
   $CurrentInStock = $StockItems[$key]['stock_level'];
   if($key == 0){
       if($CurrentStockIn > 0 && $CurrentStockOut === 0 && $CurrentInStock == 0){
           $CurrentInStock = $CurrentStockIn;
           //Query update stock level set = stock_in 
           //"UPDATE STOCK SET stock_level = {$CurrentStockIn} where id = {$StockItems[$key]['id']}";
           $StockItems[$key]['stock_level'] = $CurrentStockIn;
       }
       if($CurrentStockIn != 0 && $CurrentStockOut != 0 && $CurrentInStock == 0){
           //Query Update Stocklevel if stock_out > 0 and stock_level = 0
           //"UPDATE STOCK SET stock_level = "+($CurrentStockIn - $CurrentStockOut) + "where id = {$StockItems[$key]['id']}";
           if($CurrentStockIn > $CurrentStockOut && $CurrentStockOut == 0){
               $StockItems[$key]['stock_out'] = 0;
               $StockItems[$key]['stock_level'] = $CurrentInStock = $CurrentStockIn - $CurrentStockOut;
           }
           if($CurrentStockOut > $CurrentStockIn){
               $StockItems[$key]['stock_level'] = $CurrentInStock = $CurrentInStock - $CurrentStockOut;
           }
       }
       if($CurrentInStock != 0 && $CurrentStockOut > 0){
            //If Current in stock below 0 and stock out > 0 then negative more
           //"UPDATE STOCK SET stock_level = "+($CurrentInStock - $CurrentStockOut) + "where id = {$StockItems[$key]['id']}";
           $StockItems[$key]['stock_level'] = $CurrentInStock = ($CurrentInStock - $CurrentStockOut);
           $StockItems[$key]['stock_out'] = 0;
       }
        if($CurrentInStock != 0 && $CurrentStockIn > 0){
            
            //If Current in stock below 0 and stock out > 0 then negative more
           //"UPDATE STOCK SET stock_level = "+($CurrentInStock - $CurrentStockOut) + "where id = {$StockItems[$key]['id']}";
           $StockItems[$key]['stock_level'] = $CurrentInStock = ($CurrentInStock + $CurrentStockIn);
       }
       // Run row update for first item
   }else{
       foreach($StockCalculation as $Skey => $Sval){
           $NextStockOut = $Sval['stock_out'];
           $NextStockIn = $Sval['stock_in'];
           $NextStockLevel = $Sval['stock_level'];
           
           if($Skey > 0 && $key > 0){
              // print_r($NextStockOut);
                   for($i = $NextStockOut; $i >= -1; $i--){
                       if($NextStockOut > 0){
                           if($NextStockOut > 0){
                               /* if($StockItems[$StockLevelKey]['stock_level'] != 0){
                                    $StockItems[($StockLevelKey)]['stock_level'] = ($StockItems[($StockLevelKey)]['stock_level'] - 1);
                                    //$StockItems[($Skey-1)]['stock_out'] = ($StockItems[($Skey-1)]['stock_out'] -1);
                                }
                                if($StockItems[($Skey-1)]['stock_level'] != 0){
                                    $StockItems[($Skey-1)]['stock_level'] = ($StockItems[($Skey-1)]['stock_level'] - 1);
                                }
                           }
                       }
                       $NextStockOut = ($NextStockOut -1);
                       if($NextStockOut != 0){
                           $StockItems[$Skey]['stock_out'] = 0;
                           
                           break;
                       }
                       
                   }
               
           }
           unset($StockCalculation[$Skey]);
       }
   }/*
*/

                              

Basically I want to group a bunch of rows together to get the oldest entry which is a unix time stamp, so I can compare that to another variable.   I would like to know if this query is correct to get the oldest entry in "table.replyUnixTime"?

SELECT table.*, MAX(table.replyUnixTime) AS lastReply FROM table GROUP BY table.replyId ORDER BY lastReply DESC

Thanks

Can there be an auto remove oldest message from mailbox so can always get new.   I see the max is 50, kinda sucks to delete manually to make room for more.   Can't you just limit these to 49 by always removing the oldest one? To ensure can get any new messages.

Hi I'm currently wondering how people check for latest records each time they refresh only the latest records display in another color. For example a chat. When people submit post and another user refresh their chat page the newest post always get highlighted. Does it work with sessions or how does it work?

Hi there,

Before I begin, I want you all to know that I've been learning PHP for nearly a month now, so apologies for the poorly-written code that's going to follow. Two of my buddies and I are working on building a small website that allows us to play around with PHP and MySQL, since we work on an actual site that always in need of coding help.

I tried searching for similar threads on this forum, but I couldn't find anything that answers my questions. I'm trying to accomplish a few things here. I have a form that allows us to add a record into a table (hunting consisting of the following columns: id, title, date, data, added_by. What I want to do is write a function that retrieves the newest record added to that table, call that function in a different file (it'll appear on the home page), and add a link to that record. If that sounds confusing, then this is what I want to do:

1. Retrieve last record added to the Hunters DB with a function.
2. Call that function in main.php, where it displays the record and format it like "Latest News: Title of the record"
3. I want to embed the link in the "Latest News: <Title of the record>", so it's clickable (this should be easy for me to do). But I need it to use the id (this is the primary key) column, which changes if a new record is added. Format: www.mysite.com/hunters.php?id=1 (the id value changes if a record with an ID 3 is added, so all I have to do is change the 1 to 3 in my browser to access that new record).


This is what I wrote (functions.php):

Code: [Select]
function getNewHunterNews()
{
global $huntersdb; // Global that connects to the Hunters db
$query = mysql_query( "SELECT `id`, `title` FROM `hunters_news` ORDER BY `id` DESC LIMIT 1", $huntersdb );

while ( $row = mysql_fetch_assoc( $query ) )
{
$id = $row['id'];
$title = $row['title'];
}
return $row;
}
In main.php (functions.php is included in this file):

Code: [Select]
<?php $huntnews = getNewHunterNews(); ?>
                                <div id="news">
                                    Latest News:<br /><br />
                                    <span class="bolddark"><?php echo "<a href="\"/hunters.php?id={$huntnews['id']}\">" . $huntnews['title'] . "</a>"; ?></span>
                                </div>

I make the above changes, and my main page white screens. D: I know it isn't my function, because I've written simpler functions that are called in main.php, and those work. The white screen happens whenever I make the change above to main.php. What am I doing wrong? I'm fairly certain the change to main.php is causing problems, but I can't seem to point out what it is. Is there a different approach I can should take? I'm still in the learning process, so please guide me in the right direction. Additionally, if there any suggestions or constructive criticism you'd like to throw at me, please feel free. Every bit helps.

Thanks in advance for your help!

guys this function below posts the data into table and im also able to send a link in email with caregory name but the issue is getting the id to the particular post i got no isea how do i get that?

Code: [Select]
function insert($postData) {
$postData['description'] = clean($postData['description']);
if(!EmailExists($postData['email'])){
$sql = " INSERT INTO tbl_emails SET
email = '".$postData['email']."',
postersname = '".$postData['postersname']."',
phone = '".$postData['phone']."'
";
executeSql($sql);
}
if(empty($_FILES['image']["name"])){
$sql = " INSERT INTO tbl SET
title = '".$postData['title']."',
image = '',
postersname = '".$postData['postersname']."',
category = '".$postData['category']."',
type = '".$postData['type']."',
state = '".$postData['state']."',
location = '".$postData['location']."',
email = '".$postData['email']."',
phone = '".$postData['phone']."',
description = '".$postData['description']."',
time = '".time()."'
";
executeSql($sql);
}else{
global $uploadPath;
$remove_symbols = array('+', '=', '-', '{', '}', '$', '(', ')','&');
$removed_symbols = str_replace($remove_symbols, "_", $_FILES['image']['name']); 
$randomnum=rand(00000000,99999999); 
$imagepath = uploadFile($_FILES['image'], $uploadPath);
$image = new SimpleImage();
$image->load($imagepath);
$image->resize(250,280);
$resize_rename = $uploadPath.$randomnum._.$removed_symbols;
$image->save($resize_rename);
unlink($imagepath); //delete the original file
$sql = " INSERT INTO tbl SET
title = '".$postData['title']."',
image = '".$resize_rename."',
postersname = '".$postData['postersname']."',
category = '".$postData['category']."',
type = '".$postData['type']."',
state = '".$postData['state']."',
location = '".$postData['ocation']."',
email = '".$postData['email']."',
phone = '".$postData['phone']."',
description = '".$postData['description']."',
time = '".time()."'
";
executeSql($sql);
}
}

Here is what I am trying to accomplish:

I have a students table with a studentID
I also have a notes table and a sched table with studentID

The sched table is working as planned where if the student is scheduled for more than one time he is displayed twice.
However if there are multiple notes per student the student is display for each individual note where I would like only the most current note to be displayed

Here is what the output is:

1- 10:30:00 - 10:50:00   student3 Three   FST   Teacher One   Special1 One   Writing Ratios   09/10
2- 10:30:00 - 10:50:00   student3 Three   FST   Teacher One   Special1 One   Needs to work on fractions and decimals   09/10
3- 13:00:00 - 14:00:00   student3 Three   FST   Teacher One   Special1 One   Writing Ratios   09/10
4- 13:00:00 - 14:00:00   student3 Three   FST   Teacher One   Special1 One   Needs to work on fractions and decimals   09/10

As you can see I have two notes and two schedule times for this student. what I want it to display is only line 1 & 3. which is the newest note in the system.

Below is my code that I am using. Any help would be greatly appreciated.


Code: [Select]
<?php 
$result = mysql_query("SELECT * FROM students 
  LEFT JOIN teachers ON students.teacherId = teachers.teacherId
  LEFT JOIN course ON students.courseId = course.courseId
  LEFT JOIN specialEd ON students.specialId = specialEd.specialId
  LEFT JOIN sched ON students.studentId = sched.studentId 
  ORDER BY start
  ");
echo "<table>";
while ($row = mysql_fetch_array($result)){
$id = "?id=" . $row['studentId'];
echo "<tr>";
echo "<td>" . $row['start'] . " - " . $row['stop'] . "</td>";
echo "<td>" . "<a href='student.php$id'>" . $row['fName'] . " " . $row['lName'] . "</td>";
echo "<td>" . $row['courseName'] . "</td>";
echo "<td>" . $row['teachers_fName'] . " " . $row['teachers_lName'] . "</td>";
echo "<td>" . $row['special_fName'] . " " . $row['special_lName'] . "</td>";
echo "<td>" . $row['note'] . "</td>";
echo "<td>" . date("m/d", strtotime($row['started'])) . "</td>";
echo "</tr>";
}
echo "</table>";
?>

Hello!If i have a table let's say ( Name, Age, Date etc ...), how can i do to sort data table DESC or ASC by clicking in Name, Age and then retrive the same page ( index.php let's say ) with sorted data?

Hello,

I have a code which displays name and number. It is working now but  I want to sort the content on the basis of number... The code is given below:

while($rows = mysql_fetch_array($results)){
echo "". $rows['username'] ." ". $rows['COUNT(Completed_Sales)'] ."";
   
   echo "<br />";
}

The result will look like this

Name Prdoducts.

Im petty new to php, so if you choose to help me please explain it like I was 5

What I am trying to do is this (short version)

I have af form from which I can mail users from my DB.
This form has a dropdown for which users I want to email.

Lets say:

All
Group2+3
Group1
Group2
Group3

When hitting Submit you are taken to "send.php"

As for now I have this:
Code: [Select]
<?php

include "config.php";
$link = mysql_connect($dbhost, $dbuser, $dbpasswd) or die("Couldn't establish connection");
mysql_select_db($dbname);

$gruppe = $_REQUEST['gruppe'];

// Running the MySQL query
if($_REQUEST['password'] == "something")
{
$results = mysql_query("SELECT * FROM medlemmer WHERE tilknytning = '$gruppe'");
//$results = mysql_query("SELECT * FROM medlemmer");
// Pulling up the results and iterating through them
while ($row = mysql_fetch_object($results)) {
// Emailing each member

$ToEmail = $row->email; 
$EmailSubject = "BGA Nyhedsbrev"; 
$mailheader = "From: BGA\n"; 
$mailheader .= "Reply-To: noreply@bga.dk\r\n"; 
$mailheader .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$MESSAGE_BODY = " <H2>BGA Nyhedsbrev</H2><br>"; 
$MESSAGE_BODY .= "".nl2br($_POST["mailtekst"])."<br>"; 
mail($ToEmail, $EmailSubject, $MESSAGE_BODY, $mailheader) or die ("Failure");
} 
mysql_query($query) or die("Nyhedsbrev udsendt med succes!<br><br><a href='nyhedsbrev.php'>Tilbage</a>");

}
if ($query)

{
echo "Nyhedsbrev udsendt med succes!<br><br>";
echo "<a href='nyhedsbrev.php'>Tilbage</a>";
   }

  else

  {

  echo "Password ikke udfyldt eller opgivet forkert !!!";

  }
?>
This is ONLY woking for individual groups, when I want to email 2 or more groups I dont know what to do?

I think I have to use arrays but I am not sure at all.

Can someone help me here?

Hey guys,

I have got some events, and got it sorted by date, although at the moment the oldest date is showing first, and I would like to turn that around(new first old last), any simple suggestions?

Also another little question how would I turn a date row (for example 2009/5/31) into Tuesday - May 2009 or something similar, anyone can point me into the right direction?

Hey, I'm trying to make a script which will match a textbox value against a database, and then sort <=.

I've got this so far;

<input name="search" id="search" type="text">
<input name="year" id="year" type="text">

$search = $_GET['search'];
$year = $_GET['year'];

SELECT * FROM table WHERE MATCH(Place, Land, Yeartime) AGAINST('%$search%' IN BOOLEAN MODE)

SELECT * FROM table WHERE Yeartime <= '%$year%'

This is what I want to accomplish, but the line doesn't seem to work?

SELECT * FROM table WHERE MATCH(Place, Land, Yeartime) AGAINST('%$searsearch%' IN BOOLEAN MODE) AND Yeartime <= '%$year%' ORDER BY Yeartime";

Why does krsort return the array as "1"?

Code: [Select]
$m = array('34' => 1122, '6' => 1944, '9' => 1710);
print_r($m); //outputs: Array ( [34] => 1122 [6] => 1944 [9] => 1710 )
print_r(krsort($m)); //outputs: 1

What i need is the output to be

Array ( [6] => 1944 [9] => 1710 [34] => 1122)