RE: [PHP] Limit 15 where "Newest"

[Tim Ward]

If (!$start) $start=0;
$sql="select author, title, chapter from table order by date DESC
limit $start, 15";
...

and a link on the same page:
echo("next");

or something like that

Tim
www.chessish.com <http://www.chessish.com> 


--
From:  Tyler Longren [SMTP:[EMAIL PROTECTED]]
Sent:  05 February 2002 04:49
To:  WIll; [EMAIL PROTECTED]
    Subject:  Re: [PHP] Limit 15 where  "Newest"

$sql="select author, title, chapter from table order by date DESC
limit 15";

That's how you'd go about getting the 15 most recent table entries.
The
"next 15" thing will require a bit more though.

Tyler

- Original Message -
From: "WIll" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 9:37 PM
Subject: [PHP] Limit 15 where "Newest"


> I am trying to write a limit statement for my database. I want to
say
> something like
>
> $sql="select author, title, chapter from database where
last_update =
> "Newest" order by date limit 15";
>
> My question is how do you say " Newest" in php MySQL?
> And how do you put t link on the bottom of the page that will
select the
> next 15 items in the database?
>
> Thank you.
>
> --WIll
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Limit 15 where "Newest"

[Tyler Longren]

$sql="select author, title, chapter from table order by date DESC limit 15";

That's how you'd go about getting the 15 most recent table entries.  The
"next 15" thing will require a bit more though.

Tyler

- Original Message -
From: "WIll" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 9:37 PM
Subject: [PHP] Limit 15 where "Newest"


> I am trying to write a limit statement for my database. I want to say
> something like
>
> $sql="select author, title, chapter from database where last_update =
> "Newest" order by date limit 15";
>
> My question is how do you say " Newest" in php MySQL?
> And how do you put t link on the bottom of the page that will select the
> next 15 items in the database?
>
> Thank you.
>
> --WIll
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php