Only show "x" results

[whare]

Hi All Me again :)

right im trying to work out how to show only the newest entries into the sql db basicly like a preview of what has happend latly but i have no idea how to do (I no I need to get a php book lol well I got one on order lol)

so can anybody tell me how or point me towards something that tells me how

Thanx

Whare

[sorry no code to show you what i got not started working on it yet]

[alecjw]

Instead of:
[code]
while($row=mysql_fetch_row($result))
{
//Some code
}
[/code]
Use:
[code]
$shown=0;
$toshow=12;
while($row=mysql_fetch_row($result))
{
if($show<=$toshow)
{
//Some code
}
}
[/code]


To show the most RECENT mysql rows, put desc after the ORDER BY id bit. (ORDER BY id desc)

EDIT: You can change $toshow=12 to $toshow=the number of rows you want to show.

[whare]

Thanx mate that should help me out alot


:)

[Barand]

If you just want, say, the 10 latest,

[code]SELECT blah1, blah2 FROM mytablename ORDER BY id DESC LIMIT 10[/code]

[Barand]

@alecjw,

You need to increment $show (or $shown depending on which variable name you finally settle on)