[SOLVED] Return previously entered result

[project3]

I am trying to get this done in one query. I want to return the results and not just last inserted id.

see in my code below i get the last id just fine but I want to get all the other Fields too not just the id.

is there a way i can do this?

 

$query = "SELECT LAST_INSERT_ID() from members";

$result = mysql_query($query);

if ($result) {

$nrows = mysql_num_rows($result);

$row = mysql_fetch_row($result);

$lastID = $row[0];

 

echo "<br><br>$lastID<br><br>";

[thomashw]

$query = "SELECT * from members";

$result = mysql_query($query);

if ($result) {

$row = mysql_fetch_row($result);

$lastID = $row[0];

 

echo "

 

$lastID

 

";

[revraz]

What about

 

SELECT * FROM members ORDER BY id DESC LIMIT 1;

 

[project3]

yeah that would work ok.

 

thanks.