How to order by order in other table

[AndyPSV]

I've got.

 

    SELECT * FROM '.PRFX.'sell WHERE draft = "0" AND id IN (SELECT id_ FROM '.PRFX.'skipped WHERE uid = "'.$u.'")

And want to order by ID field (DESC) from '.PRFX.'skipped'

 

How to do it?

[Barand]

Use a JOIN to find the matching records instead of IN (SELECT ...)

$tblsell = PRFX.'sell';
$tblskipped = PRFX.'skipped';

$sql = "SELECT *
    FROM $tblsell AS sel
      INNER JOIN $tblskipped AS sk 
        ON sel.id = sk.id_ AND sk.uid = $u
    WHERE sel.draft = 0
    ORDER BY sk.id" ;       

Edited December 11, 2014 by Barand

[AndyPSV]

Found already an answer.

SELECT DISTINCT * 
FROM '.PRFX.'sell sell
JOIN '.PRFX.'skipped skip ON skip.id_ = sell.id
WHERE draft = "0" AND skip.uid = "'.$u.'"
ORDER BY skip.id DESC

[AndyPSV]

I've got.

 

    SELECT DISTINCT * FROM '.PRFX.'sell sell JOIN '.PRFX.'followed follow ON follow.id_ = sell.id WHERE draft = "0" AND follow.uid = "'.$u.'" ORDER BY follow.id DESC '.$sql_limit

that orders table, but it messes with the original '.PRFX.'sell ID (exchanging it with the follow.id)

 

How to make it back to the original one?

[AndyPSV]

Examples mess my original ID (from sell table) and i MUST preserve it. How to do it (Still waiting for an answer)?

[Barand]

1. I am not on your payroll and therefore do not respond well to comments like

 

Still waiting for an answer

 

2. I haven't a clue what you are talking about when you say

 

Examples mess my original ID

[AndyPSV]

I want to preserve ORIGiNAL sell.id instead of id: '1 2 3 4 etc.'

[Barand]

It's a SELECT query. It is not changing any data in your database.

[AndyPSV]

Yeah, but I get '1 2 3 4' IDs instead of original sell.id's i.e. 12 14 16 19

[AndyPSV]

It's done.

 

SELECT DISTINCT sell.*, follow.id as followid
FROM '.PRFX.'sell sell JOIN '.PRFX.'followed follow
ON follow.id_ = sell.id
WHERE draft = "0" AND follow.uid = "'.$u.'"
ORDER BY follow.id DESC '.$sql_limit;

[Barand]

The moral is "Don't use 'SELECT * '. Specify the columns you want."