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