Select last records

[Donn]

Hi

I have a table of 4 fields, field 2 is a field that will have more than 1 entry being the same i.e there may be 50 passcodes of which will all be enetered more than once in a day. Field 3 is a datetime stamp and field 4 is a staus i.e. in / out


  id
  Passcode
  Date 
  status
 
How would I find the last record of the passcode entered and return the last fields value.

to give an example I would like to now all the passcodes that have a current status of In.

any help much appreciated.

Donn

[The Little Guy]

$sql = mysql_query("SELECT *, MAX(id) FROM table_name");

[craygo]

You are talking about 2 different queries. I imagine id is an auto increment field.

Last row would be like this
[code]<?php
$sql = "SELECT * FROM table ORDER BY id DESC LIMIT 1";
$res = mysql_query($sql) or die (mysql_error());
$r = mysql_fetch_assoc($res);
print_r($r);
?>[/code]

For the status part
[code]<?php
$sql = "SELECT * FROM tabke WHERE status = 'In' ORDER BY id DESC";
$res = mysql_query($sql) or die (mysql_error());
$r = mysql_fetch_assoc($res);
print_r($r);
?>[/code]

Ray

[Donn]

Ray thanks for you help, the second one works great, however this shows the last time they where in, If they where to have a status of 'out' after the last staus of 'in' I could do with it not showing.


cheers