logs

[Fusionew]

Hi

Can someone fix me this? i'm trying to make a limit of 2 logs. but it seems it doesn't work.

Can someone explain me what i'm doing wrong?

 <?php
         $q = mysql_query('SELECT user, rank, notes, admin, date FROM logs ORDER BY date DESC LIMIT 0,2');
         echo "O usuario <strong>".mysql_result($q, 0, 'user')."</strong> Foi mudado para o rank <strong>".mysql_result($q, 0, 'rank')."</strong> Com a razão de <strong>".mysql_result($q, 0, 'notes')."</strong> Pelo o administrador <strong>".mysql_result($q, 0, 'admin')."</strong> na data <strong>".mysql_result($q, 0, 'date')." </strong>.";
         ?>

ty

 

[Caustik]

What is the error you're getting?

 

[Fusionew]

What is the error you're getting?

I'm only getting 1 log, i want it to be 2.

 

[Caustik]

Try dumping your result...
(var_dump() I think..)

 

[Fusionew]

Try dumping your result...
(var_dump() I think..)

I'm sure that wont work.

 

[Caustik]

You're pulling 1 result.

You must be registered to see links

 

[Fusionew]

You're pulling 1 result.

You must be registered to see links

Should i do like this?

<strong>".mysql_result($q, 2, 'user')."</strong>

 

[Caustik]

If you want all the logs loop over the collection.