PHP - Can Order Condition Be Added To Query?

I have a basic query where I am retrieving project records. I basically want to show the records from newest to oldest, but I also want to show the Featured projects first. Each Featured project is marked by "1" in the mysql table column.  If it's not featured, then it's marked "0".

$find_records = $db->prepare("SELECT * FROM projects ORDER BY project_id DESC, featured DESC LIMIT 10");
$find_records->execute();
$result_records = $find_records->fetchAll(PDO::FETCH_ASSOC);
if(count($result_records) > 0) {
  foreach($result_records as $row) {
    
  }
}

The issue with above query is that the ORDER BY works only for the first component(project_id) and ignores the second component(featured). Do you see what's wrong with it?

i have this query and i'm trying to order all of the results by `created` ascending. I've tried putting the later query before the first but the single row from the first query(the way it is right now) gets stuck as the last row in the results. How can i order the results of both queries?

Code: [Select]
(
SELECT *
FROM Account_activity
WHERE DATE( created ) <  '2011-08-01'
AND username =  '40'
ORDER BY created DESC
LIMIT 1
)
UNION (
SELECT *
FROM Account_activity
WHERE MONTH( created ) =  '08'
AND YEAR( created ) =  '2011'
AND username =  '40'
ORDER BY created ASC
)

This topic has been moved to MySQL Help.

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

I am loading notifications from a database table called "notifications" and I am having a little trouble getting them to order in the correct way.

my query I'm using right now:

Code: [Select]
$query = mysql_query("SELECT B.* FROM (SELECT A.* FROM notifications A WHERE A.user_id='$session' AND A.from_id!='$session' ORDER BY A.id ASC ) AS B ORDER BY B.state ASC LIMIT 7");

this works well as far as showing the unread notifications on top, then the read notifications below, however it's not ordering the two sets by ID (which the id auto increments so the higher id number is the newest) from newest on top to the oldest on bottom, still keeping them separated by the unread on top, read on bottom (column name is state for showing whether they're read or not).
The order the notifications are displaying by their ID is:

3
5
2
4
1

when it should be:

5
3
2
4
1

This topic has been moved to MySQL Help.

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

i am printing the dates from the last 30 days in ascending order and then comparing them in my query to print the results. How can I can print the below array in descending order without affecting my query?
Code: [Select]
   
  $thirtydaysago = time() - (30 * 24 * 60 * 60);
 
  $oneday=24 * 60 * 60;
  for($i=0;$i<31;$i++)
  {
     $d[$i]= $thirtydaysago + ($i*$oneday);
echo date('Y-m-d',$d[$i])."<br>";
  }
  for($i=0;$i<31;$i++)
  {
     $postsql=mysql_query("SELECT DATE_FORMAT(FROM_UNIXTIME(dateline), '%Y-%m-%d') AS FmtDate, COUNT(postid) AS PostCnt FROM post " .
              "WHERE dateline < '" . $d[$i+1] . "' AND dateline >= '" . $d[$i] . "' GROUP BY DATE_FORMAT(FROM_UNIXTIME(dateline), '%Y-%m-%d') DESC") or die(mysql_error());
   

   if($postsql_rows=mysql_fetch_assoc($postsql))
   {
    $data_date[$i]["date"]=$postsql_rows['FmtDate'];
$data_postcount[$k][$i]["postcount"]=$postsql_rows['PostCnt'];
   }
 }
 $k++;
 }

Hi everyone. I'm very new into self learning programming. Presently I'm trying to develop a simple basic Robot that would only Place a Market Order every seconds and it will cancel the Order every followed seconds. Using the following library:
https://docs.b2bx.exchange/en/_docs/api-reference.html#private-api

It would place Trade Order at a ( Price = ex.com api * Binance api Aggregate Trades Price)

I have already wrote the api to call for xe.com exchange rate with php 

<?php

$auth = base64_encode("username:password");
$context = stream_context_create([
    "http" => [
        "header" => "Authorization: Basic $auth"
    ]
]);
$homepage = file_get_contents("https://xecdapi.xe.com/v1/convert_from?to=NGN&amount=1.195", false, $context );
$json = json_decode($homepage, TRUE);
foreach ($json as $k=>$to){
    echo $k; // etc
};


?>

And also for the Binance Aggregate Price in JavaScript

 

<script>
var burl = "https://api3.binance.com";

var query = '/api/v3/aggTrades'; 

query += '?symbol=BTCUSDT';

var url = burl + query;

var ourRequest = new XMLHttpRequest();

ourRequest.open('GET',url,true);
ourRequest.onload = function(){
    console.log(ourRequest.responseText);
}
ourRequest.send();
</script>

  My problem  is how to handle these two api responds  and also the functions to use them to place a trade and cancel it.
Please help me out. Thanks in advance on any help.

I have this if statement with validations and mysql query

Code: [Select]
<?php
if(isset($_POST['submit']))
{
$errors = array();

$required_fields = array('menu_name', 'position', 'visible');

foreach($required_fields as $fieldname)
{
if(!isset($_POST[$fieldname]) || (empty($_POST[$fieldname]) && $_POST[$fieldname] != 0))
{
$errors[] = $fieldname;
}
}

$fields_with_length = array('menu_name' => 30);

foreach($fields_with_length as $fieldname => $maxlength)
{
if (strlen(trim(mysql_prep($_POST[$fieldname]))) > $maxlength)
{
$errors[] = $fieldname;
}
}


if(empty($errors))
{
//Perform Update

$id = mysql_prep($_GET['subj']);
$menu_name = mysql_prep($_POST['menu_name']);
$position = mysql_prep($_POST['position']);
$visible = mysql_prep($_POST['visible']);


$query = "UPDATE subjects SET menu_name = '{$menu_name}', position = {$position}, visible = {$visible} WHERE id = {$id}";

$result = mysql_query($query, $connection);
if(mysql_affected_rows() == 1)
{
//success
$message = "Record has been successfuly updated!";
}
else
{
//failed
$message = "The subject update failed";
$message .= "<br>". mysql_error();
}

}
else
{
//Error Occured
$message = "There were ". count($errors) . " error in the form";
}


}

?>


I'm having problem on this line

Code: [Select]
<?php
if(!isset($_POST[$fieldname]) || (empty($_POST[$fieldname]) && $_POST[$fieldname] != 0))
?>

this line is for validation of my radio button which has a 0 and 1 value.

Quote

&& $_POST[$fieldname] != 0




Eventhough the textbox is not set and is empty, it's still bypassing my if statement and still executing the update query...

<?php
$id1 = '5' ;
$id = array(1,2,3,4,5,6,7);

    foreach($id as $value){
if($id1==$value){
    echo 'One of them matches, ' ;
    echo 'Do not execute command <BR>' ;
} ////// if ends here
} ////// loop ends here

?>   How to do something if all statements are false ? like when id $id1 = '10' , ?

Hi..

I tried this code:

Code: [Select]
<?php
     error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');
  mysql_select_db("mes", $con); 
if (!$con) {
    echo 'failed';
    die();
}

$sql = "SELECT PCODE, total FROM kanban_checker ORDER BY PCODE";
$res = mysql_query($sql, $con) or die(mysql_error());

while($row = mysql_fetch_assoc($res)){
    $PCODE = $row['PCODE'];
    $total = $row['total'];
}
  $sql = "SELECT 
                P28, P28_max, P28_min,
                P30, P30_max, P30_min,
                P32, P32_max, P32_min,
                P33, P33_max, P33_min,
                P35, P35_max, P35_min,
                P35M, P35M_max, P35M_min,
                P35W, P35W_max, P35W_min,
                P38, P38_max, P38_min,
                P41, P41_max, P41_min,
                P42, P42_max, P42_min,
                P43, P43_max, P43_min,
                P46, P46_max, P46_min
                FROM parameter_settings";
        $res_pcode = mysql_query($sql, $con);
        
  $row = mysql_fetch_assoc($res_pcode);
            $P28 = $row['P28'];
            $P28_max = $row['P28_max'];
            $P28_min = $row['P28_min'];
        
            $P30 = $row['P30'];
            $P30_max = $row['P30_max'];
            $P30_min = $row['P30_min'];
            
            $P32 = $row['P32'];
            $P32_max = $row['P32_max'];
            $P32_min = $row['P32_min'];
            
            $P33 = $row['P33'];
            $P33_max = $row['P33_max'];
            $P33_min = $row['P33_min'];
            
            $P35 = $row['P35'];
            $P35_max = $row['P35_max'];
            $P35_min = $row['P35_min'];
           
            $P35M = $row['P35M'];
            $P35M_max = $row['P35M_max'];
            $P35M_min = $row['P35M_min'];
            
            $P35W = $row['P35W'];
            $P35W_max = $row['P35W_max'];
            $P35W_min = $row['P35W_min'];
            
            $P38 = $row['P38'];
            $P38_max = $row['P38_max'];
            $P38_min = $row['P38_min'];
            
            $P41 = $row['P41'];
            $P41_max = $row['P41_max'];
            $P41_min = $row['P41_min'];
            
            $P42 = $row['P42'];
            $P42_max = $row['P42_max'];
            $P42_min = $row['P42_min'];
            
            $P43 = $row['P43'];
            $P43_max = $row['P43_max'];
            $P43_min = $row['P43_min'];
            
            $P46 = $row['P46'];
            $P46_max = $row['P46_max'];
            $P46_min = $row['P46_min'];
            
            $P47 = $row['P47'];
            $P47_max = $row['P47_max'];
            $P47_min = $row['P47_min'];             
       if($PCODE = $P28 || $total = $P28_min){
            echo $P28_min;
        }
        elseif($PCODE = $P30 || $total = $P30_min){
            echo $P30_min;
        }
        elseif($PCODE = $P32 || $total = $P32_min){
            echo $P32_min;
        }
        elseif($PCODE = $P33 || $total = $P33_min){
            echo $P33_min;
        }
        elseif($PCODE = $P35 || $total = $P35_min){
            echo $P35_min;
        }
        elseif($PCODE = $P35M || $total = $P35M_min){
            echo $P35M_min;
        }
        elseif($PCODE = $P35W || $total = $P35W_min){
            echo $P35W_min;
        }
        elseif($PCODE = $P38 || $total = $P38_min){
            echo $P38_min;
        }
        elseif($PCODE = $P41 || $total = $P41_min){
            echo $P41_min;
        }
        elseif($PCODE = $P42 || $total = $P42_min){
            echo $P42_min;
        }
        elseif($PCODE = $P43 || $total = $P43_min){
            echo $P43_min;
        }
        elseif($PCODE = $P46 || $total = $P46_min){
            echo $P46_min;
        }
        elseif($PCODE = $P47 || $total = $P47_min){
            echo $P47_min;
        }
        else{
            echo '';
        }
?>

for display data if total = min.

The problem is, in this condition he satisfied if condition even though $total is not equal to $P28_min.

Thank you

this code works fine if the conditions are absolute ( pass, fail or empty). im trying to make the fail work if its part of the query. ive tried %fail% but didnt work.

$choice = strtoupper($rows['comments']);
if($choice == "PASS"){  
$bgc = "#ff25f0" ; }    
elseif($choice == "FAIL"){
$bgc = "#666666" ;   
}else{
$bgc = "#FF6600" ; }

Can someone please tell me what i have got wrong here?

I am trying to return value C if conditions a AND B are met or return value D.  Not sure if its parenthesis or something else?

<?php if (($row_Recordset4['multidirection']=="yes") &&
($_POST["widthcheck"] < $row_Recordset4['drop'])) echo $row_Recordset4['width'];else echo $row_Recordset4['drop'] ?>

Thanks

Code: [Select]
if($this->color=="Blue" || $this->color=="Green" || $this->color=="Red" || $this->color=="Yellow") {
return true;
} else {
return false;
}

This is returning false, when it should be returning true because $this->color DOES equal "Red"...
I can NEVER EVER get these conditional things to work UNLESS it's &&, but I even tried:
!$this->color != "Red" && .........

as well to see if that would work even though that's really confusing.

Can someone help me finally understand this stupid OR stuff?

if u use this for one condition

if ($nr > 5)

how would u check if the nr is between 5 and 50

thanks !