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

php forms and database navigatio
Hello,
I'm new to php and i'd like to post the following.
I have written code to get records f

Loop Through Date Range
Hi guys,
I have date range as parameter like 01/JAN/2009 TO 16/JAN/2009 now i want to loop thro

PHP and XML image gallery variable issue
I'm trying to display the large image on the same page as the thumbnails, to do that I'm passing a v

Socket problem
Hello,

Earlier I posted about my problem with my socket script. It took up to 100% CPU usage.

url- go to webpage
i have an input text field and submit button.

how do i make the url entered into the textfiel

How to form a xml form table with a single sql statement..?
Hi everyone,
I don't know if this is going to be a duplicate thread but i couldn't

Call to undefined function mysql_fetch_accoc()
New to php/mysql coding. What's wrong with this sequence, or am I
just not seeing to obvious?

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

output_buffering so rewrite
I'm planning to rewrite some of my scripts so they don't have to use output buffering to accomplish

How to display objects in a row
I have 7 codes that i want to display in a row one next to another.
The first is {$ads->ad