getting output of second row from mysql

Question

hi i have this mysql statement without limit so it will get first row in ascending order but i want to get the title of second row as well

    $res = mysql_query("select * from tas where id='{$m_id}' ");

after that i can fetch and get the first output without any issue earlier i was required to get the id so i used this

   $nidf=$m_id-1;

but now i need title of previous id.table consists if id,title,views etc .i know it can be done easily by this query

    $res2 = mysql_query("select * from tas where id='{$nidf}' ");

but i dont want to execute second syl query and i want to learn how it can be done without using above query

i cant not use while as i need only second title and rest of the thigs i need for first row only

Leave mysql, it is deprecated. Join PDO : php.net/manual/en/intro.pdo.php — Yousuf Memon
– Yousuf Memon, Commented Apr 2, 2013 at 16:09

Marc B · Accepted Answer · 2013-04-02 16:08:43Z

2

SELECT *
FROM tas
WHERE id <= $m_id
ORDER BY id DESC
LIMIT 2

fetch all the rows that have your specified ID OR* LESS, order by that id in descending order, then return only the first 2 rows in that ordered set. That'll be the $m_id you wanted, and the next immediately lower id as well.

answered Apr 2, 2013 at 16:08

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

1 Comment

tumbinkya Over a year ago

i am using $row = mysql_fetch_array($res); and after that $output=$row['title']; which will give output of first row how to get for second row

Collectives™ on Stack Overflow

getting output of second row from mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related