PHP reverse order from mysql

Question

I have this piece of code:

return $this->db->query("SELECT * FROM `messages` where `toid`='$userid' and `fromid`='$userConvensation' or `fromid`='$userid' and `toid`='$userConvensation' order by `id` DESC LIMIT 10");

It takes the 10 latest messages.

But i need the 10 latest messages, but also in reversed order. how am i able to do that?

output code:

foreach($messages->result() as $thisMessage) {
//dostuff
}

("SELECT * FROM messages` where toid='$userid' and fromid='$userConvensation' or fromid='$userid' and toid='$userConvensation' order by id DESC LIMIT 10") AS latest ORDER BY id ASC? — aldrin27
– aldrin27, Commented Sep 29, 2015 at 2:16

Andi Sholihin · Accepted Answer · 2015-09-29 02:57:08Z

1

how about subquery:

SELECT * FROM `messages` WHERE id IN (
  SELECT `id` FROM `messages` where `toid`='$userid' and
  `fromid`='$userConvensation' or `fromid`='$userid' and
  `toid`='$userConvensation' order by `id` DESC LIMIT 10
)
ORDER BY `id` ASC

answered Sep 29, 2015 at 2:57

Andi Sholihin

4893 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

maria Over a year ago

for some reason now. its not selecting it by the toid and fromid, or only getting 10 rows .prntscr.com/8lqcxd

maria Over a year ago

Error Number: 1235 This version of MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

aldrin27 · Accepted Answer · 2015-09-29 02:26:40Z

0

Wrap your query and renamed it and reorder that.

("SELECT * FROM messages` where toid='$userid' and fromid='$userConvensation' or fromid='$userid' and toid='$userConvensation' 
 order by id DESC LIMIT 10") AS latest ORDER BY id ASC

answered Sep 29, 2015 at 2:26

aldrin27

3,4184 gold badges31 silver badges44 bronze badges

1 Comment

maria Over a year ago

for some reason now. its not selecting it by the toid and fromid.prntscr.com/8lqcxd

Collectives™ on Stack Overflow

PHP reverse order from mysql

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related