SQL query not working well

Posted on 16th Feb 2014 07:03 pm by admin

Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum

so I'm running
select * from mytable where rownum = 1;

and it gives me the first row but if I change the 1 for a 2 or 3 or 4 or 5 it's says that theres nothing :S

why?????????????????????

but if i change for between 1 and 5 it gave me the 4 rows :S :S

why???????????????????

Your Answer:

Login to answer

Other forums

URL Rewrite issue
Im created a series of Rewrites and on page checks to make sure the correct url is being called. But

Help with page encoding issue and weird characters
I'm trying to write a screen scraper and when I pull out the lines of the html file that I'm interes

Php - mysql store data and use it later?
Hi, i' making a login page at the moment, however my username + password is stored many different pl

how to get sn motherboard
Hello.
I want to get serial number motherboard, cpu and else hardware.
Can You show me sam

Procedure with variable number of columns
Hi, I have a procedure that looks like this:

PROCEDURE PROC(p_cursor OUT sys_refcurso

Need help adding a timestamp to my filename/variable
Hello,

I'm kind of stupid when it comes to php and I need a tiny bit of help. I've got a f

storing video files into mysql in php
hi

i have my video files in my folder ,
i have to store the path of the videos into db an

Pro-rata Billing in Periodic Billing for Rental
Hi guys,

We have a situation, where a rental contract starts at the mid of the month say

Can you help please? Php file
I have to write this php file to allow users to register their nicknames on nickserv

For an I

article site help remaining text
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on