Select a row in phpmyadmin [closed]

-1

Good afternoon guys.

When developing for VB I used a select using the top, to select a certain line I wanted, however I'm developing in php now and I'm using the phpmyadmin DB and I would like if possible how do I select only one row, since I will use a loop in php to go reading line by line.

I already tried the limit but it shows all within the limit, and I need the select to select only one line.

I tested some select personnel that commented on several sites but were unsuccessful.

The last one I used now was:

'SELECT cdAgendamento FROM agendamento WHERE cdAgendamento > 10 AND ROWNUM = 1'

Thank you!

    
asked by anonymous 19.10.2016 / 19:03

1 answer

1

Mysql you can use LIMIT.

SELECT cdAgendamento FROM agendamento WHERE cdAgendamento > 10 LIMIT 1
    
19.10.2016 / 20:09