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

how to remove in php string display
My code is

$message="We're looking at developing our website.";

$body= "

Question about ShowWindow()
Hello....

I'm struggling with sumpin, and I hope y'all can help.

I've got a CFormView

Solution to the FindControl problem
I have seen may posts about having problems with the FindControl method. Most seem to come about bec

Typedef struct vs just struct
Anyone know the rationale for using typedef for structs when a struct is itself a typedef? I have s

checkbox update
I am having a brain fart right now and i cant remember how to do this. if anyone could help that wou

storing results of a function - previous result overwritten with new result
I have created a function to validate input.

function validate_dimension($value,$name) {
<

IIS & NW MII on the same server
Hi,

We're weighing the possibility to run both IIS and MII (NetWeaver) on the same server

Redirecting Admin
In my members table, I have a field called "perm" and it's set to zero for all members. Ho

printing links
Hi every1

i am connecting to a table in sql and the looping through with a while ($ var = my

Web Host List
Here is a list of web hosts that offer PHP and MySQL. It is no where near a full list, but it is mos