Limit logs 2

Hello.

I'm trying to do a limit of 2 logs, but it just appear 1, does anyone know what i'm doing wrong?




Thanks.

I could be off, but I think mysql_result() returns only one row at a time, as many of the other mysql functions do unless they explicitly say they return multiple rows. You were already told in another threat to stay away from the mysql functions and use PDO or mysqli, so I won't repeat that advice.

However, you don't need to specify the offset in LIMIT, just doing "LIMIT 2" will retrieve a max of two rows, by default it starts at the 0 row.

Something to also think about, as it mentions on mysql_result() is to use a function that returns the entire row, rather than calling mysql_result() three times.

MANY problems here. One your using a deprecated extension which will soon start yelling at you with an E_DEPRECATE error. Second the mysql_result only selects a single row from a mysql result resource.

Mysql_result(RESOURCE,int ROW,mixed FIELD)

While you could use this method just copy the code again and take the next row. sense you know how many rows you want before hand.

Alternatively you could use while($row=mysql_get_asoc($q)){
CODE
}