Only get the last 20 records

[DrTrans]

<?php
     $connect = mysql_connect("localhost","damgears_evil","damgears");
     mysql_select_db("damgears_evil");
     $query = mysql_query("SELECT * FROM titles ORDER BY id DESC");

     while($row = mysql_fetch_assoc($query))
	{
		$dbid = $row['id'];
		$dbfname = $row['fname'];
		$dblname = $row['lname'];
		$dbkey = $row['key'];
		$dbskey = $row['skey'];
		$dbname = $row['sname'];
		$title = $row['title'];
		$dbstatus = $row['status'];
		$dbdate = $row['date'];
		$region = $row['region'];
	print "<center>\"$title\"<br>";
	print "by $dbname <i>for $dbfname $dblname</i><br><br></center>";

	}
    ?>

[Maq]

LIMIT 20

[GoneNowBye]

he means

 

select * from table where x=y group by whatever LIMIT 20

 

this will limit it to 20 reconds

 

if you want to limit it to 20 records after the first 10

LIMIT 10,20

 

[Maq]

if you want to limit it to 20 records after the first 10

 

Why would he want that?

[GoneNowBye]

I was just noting the alternate syntax incase he ever needed it.

 

or did why i did and not research and just make PHP (or whatever) ignore the first ten and limit 30.

[Maq]

I was just noting the alternate syntax incase he ever needed it.

 

or did why i did and not research and just make PHP (or whatever) ignore the first ten and limit 30.

 

It's not an "alternate syntax" for the desired results.  That would imply that using LIMIT 10,20 would yield the same results as LIMIT 20.  Which it doesn't.  Using LIMIT 0,20 would be considered an alternative syntax.

[GoneNowBye]

limit y,x is a different (and thus alternate) syntax to limit x.....

 

 

the OP now knows both versions of it... okay?