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

TabControl Inside ListView Not Editing
Hello everybodyI have a ListView on my page. Inside the ListView I put a TabControl, cuz I want to p

simple ping code
been searchin the site/web and found code thats simple but doesnt work.

I have a personal we

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

Implementing Single Sign-On using SAML 1.1, x.509, LDAP in C#.net
Hi, I got a requirement from the client i.e implementing single sing on using SAML 1.1( LDAP &

Generate multilayered array from string.
ok so i have a string that looks like this:
Code: [Select]blog:edit_all,delete_all|users:edit_all

PHP page is blank
Hi Everyone,

I have a site in which I am able to open the first PHP webpage in my browser but

Pspell with my own dictionary
Hello!
I've tested two cases using pspell functions.
1)
Code: $dictionary_link = pspell_new

Is there a quick way to do this?
Hi all,

I need to create a mysql table from php that goes a little something like this

Page doesn't expand for content
Hi. I've been testing a query I made. It's here http://lapr1.6te.net/inquerito.php
The page doesn

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne