How do I do this in php?

SELECT news_id, news_title, news_url,  news_position, news_order, news_status  FROM "tblNews" ORDER BY news_id DESC, news_order ASC LIMIT 10 OFFSET 0

Stick to doing only a single ordering (either news_id or news_order).

Example:

SELECT news_id, news_title, news_url,  news_position, news_order, news_status  FROM "tblNews" ORDER BY news_order DESC LIMIT 10 OFFSET 0

You will have to specify how you want to handle situations where there are more that 10 entries.
ie 50 entries of each priority, all entered so that newness spans all priorities.
Do you want just all NEW, just the priority ones (even though there are newer ones).
or
Do you want 10 New ones, which are then ordered by priority?

waygood:
>> Do you want 10 New ones, which are then ordered by priority?

yes, i want this way,... only 10 news (latest ... by putting news_id DESC) as welll as these 10 news should be ordered the priority also...

for example,

last 10 news

news_id       news_title                         news_priority
17                   This is latest news2             1
16                  This is latest news2           3
15                  This is latest news2           3
14                  This is latest news2           5
12                  This is latest news2          5
10                  This is latest news2          6
9                  This is latest news2          7

You mean allways sorting out the latest ten, but by priority as second choice?
Then ahmad2121 is spot on with his example. That gets the highest numbered news. Then sort those by priority, with those lowest first.

SELECT news_id, news_title, news_url,  news_position, news_order, news_status  FROM "tblNews" ORDER BY news_id DESC, news_order ASC LIMIT 10,0

Did you get a problem using that query?

Regards,
Andreas

>> Take the result set with first query and sort it programatically.

can you give some more details,?

HeroGuran:

>>
SELECT news_id, news_title, news_url,  news_position, news_order, news_status  FROM "tblNews" ORDER BY news_id DESC, news_order ASC LIMIT 10,0

I am getting exact results till news_id DESC ... i am not getting news_order in ASC order.. thatz the problem (i.e first priority comes first...  1, 2,3,4,5 etc) ...

 this applies only the latest 10 records what we select in the news_id DESC

am i making sense please?

hi HeroGuran.. thanks for the answers..

can anyone help, i could not get it correctly.,
$i = 0;
while($row=mysql_fetch_array($result))
{
   $array[$i] = array($row["news_id"],$row["news_priority"]);
   $i++;
}

**************
may you tell how do i sort or get the exact result.,

Hey!
I'm sorry it didn't work out for you. Normally you should start a new question, but I guess you have reason for posting here so I'll try to help anyways. The attached code to my previous post is the easiest to work from so that's where I'll start.

//Get the 10 latest news
$sql = 'SELECT news_id, news_title, news_url,  news_position, news_order, news_status FROM "tblNews"  ORDER BY news_id ASC LIMIT 10,0';
//Iterate the latest ten news to use in secondary query
$addSQL = "";
while($row=mysql_fetch_array($result))
{
   $addSQL = "AND news_id = '".$row["news_id"]."' ";
}
$sql = 'SELECT news_id, news_title, news_url,  news_position, news_order, news_status FROM "tblNews" WHERE 1=1 '.$addSQL.' ORDER BY news_order ASC LIMIT 10,0';
//This should result in the latest ten news, ordered by "news_order", which I assume is your "priority"

Or did you try that allready?

Regards,
Andreas

i did not try that..i am trying.. this.,

The last SQL should come out something like ..
Oh, hey, you must use OR.. not AND. That's a big mistake by me.
There must also be a punctuation at the addSQL variable for building on values, not replacing like now. I have corrected this below.

Regards,
Andreas

//Get the 10 latest news
$sql = 'SELECT news_id, news_title, news_url,  news_position, news_order, news_status FROM "tblNews"  ORDER BY news_id ASC LIMIT 10,0';
//Iterate the latest ten news to use in secondary query
$addSQL = "";
while($row=mysql_fetch_array($result))
{
   if($addSQL)
      $addSQL .= "news_id = '".$row["news_id"]."' ";
   else
   $addSQL .= "OR news_id = '".$row["news_id"]."' ";
}
$sql = 'SELECT news_id, news_title, news_url,  news_position, news_order, news_status FROM "tblNews" WHERE 1=1 AND ('.$addSQL.') ORDER BY news_order ASC';
//This should result in the latest ten news, ordered by "news_order", which I assume is your "priority"

Select allOpen in new window

Sheesh, monday.. I turned the if-statement around, should be:

//Get the 10 latest news
$sql = 'SELECT news_id, news_title, news_url,  news_position, news_order, news_status FROM "tblNews"  ORDER BY news_id ASC LIMIT 10,0';
//Iterate the latest ten news to use in secondary query
$addSQL = "";
while($row=mysql_fetch_array($result))
{
   if($addSQL)
      $addSQL .= "OR news_id = '".$row["news_id"]."' ";
   else
      $addSQL .= "news_id = '".$row["news_id"]."' ";
}
$sql = 'SELECT news_id, news_title, news_url,  news_position, news_order, news_status FROM "tblNews" WHERE 1=1 AND ('.$addSQL.') ORDER BY news_order ASC';
//This should result in the latest ten news, ordered by "news_order", which I assume is your "priority"

Select allOpen in new window

Yes, it works now., i was trying without OR as well concatenation of $addSQL.. anyhow it works welll... thanks again.., anyhow i don't have option again to assign points.. it is something great to come and discussed this point.,

but i was trying some SORTING technique ... did not work that//

thanks HeroGuran;

you could always use subquery

SELECT * FROM (SELECT * FROM table ORDER BY newest LIMIT 10) ORDER BY priority

I couldn't get it to work through phpMyAdmin, but this is the basic syntax
http://dev.mysql.com/doc/refman/4.1/en/unnamed-views.html

:: waygood
>> excellent .... i have also got the results through like this sub query ...., anyhow thanks for posting your answer here....  so i have used like this also and got the correct result.. thanks