complicated query

[brauchi]

I am having problems to figure out the code for an array.

Here is the scenario.

Everyday we are adding articles into our database. So far we are able to show the last 10 added articles so that people can always see what is new on our site. But we also have all the articles rated. For example if one of the ten last articles was a news article we would like to give this first ranking.

In order to do this we associate with each article a document ranking variable that can be anything between one and two.

I am coding for hours and I can't get this solved.

Maybe somebody could give me a small hint about how i could work this problem?

Thank you in advance

andrea

[TruckStuff]

can you not do a "sort by rank asc" at the end of your query?

[brauchi]

i tried this but then i didn't get the 10 most recent documents. then it was sorted by the numbers first and then the ranking. but i think i need to first build an array for the 10 most recent and then sort through this new built array.

[Chris_Evans]

There's a way of doing this, I think, but I can't think of how to write it... basically, you need to get the ten latest articles from the database sorting by date and if neccessary, time.

Then, once you've got those, you need to sort those individual 10 articles in order... I think that's done without the mysql part... then it should work.