PHP: get the last row in database using mysql

Question

I have three rows in a table. I'm trying to get and display the last row of my table and, instead, its always displaying the result of the middle row.

I have tried to used the "DESC" or "DESC LIMIT 1" but still its not working.

Example:

I have a 3 rows in my table of tbldata.

The query for this:

$result = mysql_query("SELECT fldBldgName, fldTimestamp,   
MIN(fldTotalDuration)fldTotalDuration   
FROM tbldata    
WHERE  fldNetname = '".$network."'   
AND fldBldgName = '".$bldg[$i]."'    
AND  fldWeek = '".$week."'   
AND fldMonth = '".$month."'   
GROUP BY fldBldgName   
ORDER BY  fldBldgName,fldTimestamp, fldTotalDuration DESC");

I already tried also the ID to order by but still its not working. I tried the timestamp, but still its not working.

The result for that query is always the "0:10", the correct output should be "0:15".

But then if I have 2 rows only:

0:5

0:10

the result is : 0:10 which is correct

And so, I also tried it to manually query it in phpmyadmin, but it still does not display the last row.

@T_01...yeh ...oh yeah! thanks! but why its working like that? is there a different with your query in my query? — Princess Toledo
– Princess Toledo, Commented Aug 18, 2013 at 13:16

RiggsFolly · Accepted Answer · 2013-08-18 13:22:18Z

3

Assuming you have an id field with AUTO_INCREMENT set.

Then try this

SELECT * FROM tbl ORDER BY id DESC LIMIT 1;

Your use of MIN(fldTotalDuration) and GROUP BY was totally confusing the result you were after.

edited Aug 18, 2013 at 13:22

user1082944

answered Aug 18, 2013 at 13:14

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP: get the last row in database using mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related