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???????????????????

No comments posted yet

Your Answer:

Login to answer
120 Like 6 Dislike
Previous forums Next forums
Other forums

big pagination problem in php
<?php

$connect = mysql_connect("localhost", "root", "")

onclick problem
I have <input type="text" name="message">
<a href=page2.

How do I create a 2D game "camera" to follow player?
In J2ME programming I'm targeting MIDP 2.0 devices.

I'm using gamecanvas and I was thinking t

Polymorphism
Was wondering if someone could explain this a little better to me. I had always assumed that it had

array_diff weirdness
I'm using the following bit of code

$diff = array_diff($pids, $pidlist);
$diff = array_va

fire away
i launched about 4 months ago as a lagit co. i have 2 paying clients, 1probono, 1 side progect, and

Update Database
Hi All,


I have a problem with this:

Code: [Select]<?php
session_start();

mod_rewrite.c on windows ??
why it's not working on windows while it's working on other hosts???

this is the code i got

Help With editting and deleting form
Hallo !!

So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.pn

Cannot Connect to Database
I am writing an application to do annual reviews. I cannot get my script to work. Whenever it runs I

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash