RE: SQL row number

2003-06-03 Thread Dan Muey
> Thank you, What i meant is that > If i search in a table all people that speaks English. > I want mysql to search for the first 10 people that matche the query, then have an > option next to go from the last person > to the next 10 people. Or something better > would be SELECT FROM tablex START

Re: SQL row number

2003-06-03 Thread Anthony Ward
Hi, Thank you, What i meant is that If i search in a table all people that speaks English. I want mysql to search for the first 10 people that matche the query, then have an option next to go from the last person to the next 10 people. Or something better would be SELECT FROM tablex START FROM PER

RE: SQL row number

2003-06-03 Thread Dan Muey
> Hi, Howdy, > I would like to know if it is possible with perl, when we search for a general > 'thing'( i.e search in the database all > people that speaks english) in a MySQL database, what is the row number of the last > row that matches the SELECT statment? > If so can someone show me an

SQL row number

2003-05-31 Thread anthony
Hi, I would like to know if it is possible with perl, when we search for a general 'thing'( i.e search in the database all people that speaks english) in a MySQL database, what is the row number of the last row that matches the SELECT statment? If so can someone show me an example? I would apprec