At 12:54 AM +0000 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->execute; > > > >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; > > >Any idea why?
Because you're not checking for errors (and apparently don't have RaiseError enabled). If you had done either of these things, you would have found out that the statement is illegal. (In particular, LIMIT goes at the end of the query.) > > > >MySQL table query > > >M. >-- >Work:- postmasterAThinwick.demon.co.uk WEB:- http://www.hinwick.demon.co.uk >Work:- mworsdallATshaftesburysoc.org.uk REPLACE AT with @ >Home:- hinwickATworsdall.demon.co.uk WEB:- http://www.worsdall.demon.co.uk >Shadow:- webmasterATshadow.org.uk WEB:- http://www.shadow.org.uk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
