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

session variables not working anymore
hello,
i use sessions to handle authentication within my site. my host has been changing a lot of

Any help with my email script?
I have an email script, I have not tested it, although someone tested it for me and said it worked f

split string
Hi all

i have some names (imploded by comma):
Code: toronto,paris,madrid
Now, i would

function not returning the correct value
I have a program that needs to return a value from a function. I have an output statement inside the

firefox wouldnt stream mp3 files completely from my php page
hi everyone,
I have a php file trying to read and stream mp3 files. It works fine in IE but my pr

PHP Code reffering to database, doing something wrong.. pls help
Well i am quite new with PHP
and for school we have to make a PHP script which reffers to a Data

IF Statement & Two Tables With Different Echoes
I'm retrieving two tables in a single query using UNION ALL, like so:

Code: $query = "SE

php title problem
Hi,

I am having a problem managing my page title with PHP.

Currently I have my <

Aris, Netweaver BPM, Visual composer and X'app
Dear Experts,

Whats the relationship between the following components: Aris, Netweaver BP

how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s