Suljettu

Very simple code/mySQL I think

Hi there,

I have a piece of code:

$sth = $dbh->prepare("SELECT id, userid, retailer, amount, date FROM accounts WHERE cd=? AND status=? ORDER by date DESC LIMIT 1500");

Currently sets the limited to 1500. However what I want to do is then do a query for the limited to be 1500-2500 does that make sense?

So instead of the range being the first 1500 its the 1500-2500?

Thanks! That is it.

Matt.

Taidot: Perl

Näytä lisää: range query, id to code, first code, simple query, retailer, mysql query, desc, dbh, status code, 1500 mysql, code status, amount code, piece code, userid, mysql status, order mysql, perl date, mysql code, simple limit order, order status mysql, code mysql, limit order, perl code, mysql date, select code

About the Employer:
( 115 reviews ) Newark, United Kingdom

Projektin tunnus: #454921

5 freelanceria on tarjonnut keskimäärin 54 $ tähän työhön

webdreamer

Please check your PMB for the solution.

30 $ USD 0 päivässä
(1 arvostelu)
2.8
mfranco

Immediate delivery.

30 $ USD 1 päivässä
(1 arvostelu)
0.7
balalinux

$sth = $dbh->prepare("SELECT id, userid, retailer, amount, date FROM accounts WHERE cd=? AND status=? ORDER by date DESC LIMIT 1500,1000");

30 $ USD 1 päivässä
(0 arvostelua)
0.0
krishnamohan19

i can do immediately, please send ur [url removed, login to view] is for only $10.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
yjyothirao

Hi, I am interested in doing this project. Thanks, Jyothi

150 $ USD 15 päivässä
(0 arvostelua)
0.0