Re: Having trouble using LIMIT

2001-10-31 Thread Mark Worsdall
In message <[EMAIL PROTECTED]>, Steve Meyers <[EMAIL PROTECTED]> writes >> But when I add in the LIMIT statement it returns no records >> >> $prep = "SELECT id,name FROM go.objectives WHERE subjects_id='1' AND >> subjectHeadings_id='2' LIMIT 1,5 ORDER BY displayOrder"; >> >> $sth = $dbh->prepare(

Re: Having trouble using LIMIT

2001-10-30 Thread Paul DuBois
At 12:54 AM + 10/31/01, Mark Worsdall wrote: >Hi, > >When I do the following in a perl script I get back all the records I want: > >$prep = "SELECT id,name FROM go.objectives WHERE subjects_id='1' AND >subjectHeadings_id='2' ORDER BY displayOrder"; > >$sth = $dbh->prepare($prep); > >$sth->exe

Re: Having trouble using LIMIT

2001-10-30 Thread Steve Meyers
> But when I add in the LIMIT statement it returns no records > > $prep = "SELECT id,name FROM go.objectives WHERE subjects_id='1' AND > subjectHeadings_id='2' LIMIT 1,5 ORDER BY displayOrder"; > > $sth = $dbh->prepare($prep); > > $sth->execute; > > http://www.mysql.com/doc/S/E/SELECT.html

Having trouble using LIMIT

2001-10-30 Thread Mark Worsdall
Hi, When I do the following in a perl script I get back all the records I want: $prep = "SELECT id,name FROM go.objectives WHERE subjects_id='1' AND subjectHeadings_id='2' ORDER BY displayOrder"; $sth = $dbh->prepare($prep); $sth->execute; But when I add in the LIMIT statement it returns