MySQL returning wrong record

Question

I am running a query on my page and it is returning the wrong results. Here is my code:

$timestamp = time();
$query = "SELECT * FROM videos WHERE expire >= $timestamp AND home = 1 AND active = 1 ORDER BY id DESC LIMIT 1";
$result = mysql_query($query) or die(mysql_error());

if(mysql_num_rows($result) > 0) {
    $row = mysql_fetch_array($result);
    foreach ($row as $key => $value) {
        $$key = $value;
    }
}

The problem is, it is returning the SECOND record, and not the most recent ID. But, strange part is, if I run this in the Query window of MySQL, it returns the correct record.

This is the data on the record it should return: id: 53, videoid: abc123, expire:1335596400, home: 1, active:1

Anyone have any ideas on this?

Have you tried ordering by the expire field instead?

Jeff Lambert
– Jeff Lambert

2012-05-09 18:51:43 +00:00
Commented May 9, 2012 at 18:51 — Jeff Lambert
– Jeff Lambert, Commented May 9, 2012 at 18:51
Maybe it has something to do with your computer's timezone?

Pablo Santa Cruz
– Pablo Santa Cruz

2012-05-09 18:52:12 +00:00
Commented May 9, 2012 at 18:52 — Pablo Santa Cruz
– Pablo Santa Cruz, Commented May 9, 2012 at 18:52
It's because you're ordering by DESC

Norse
– Norse

2012-05-09 18:52:32 +00:00
Commented May 9, 2012 at 18:52 — Norse
– Norse, Commented May 9, 2012 at 18:52

Maxim Krizhanovsky · Accepted Answer · 2012-05-09 18:52:44Z

2

1335596400 is 28 april, so cleary is not the result from time(); It seems that you are runnign the query with another timestamp in MySQL (or without timestamp at all)

answered May 9, 2012 at 18:52

Maxim Krizhanovsky

26.8k5 gold badges62 silver badges91 bronze badges

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

1 Comment

Rick Over a year ago

Funny how you can look right past something when you've been staring at the monitor for so long... Thanks for helping me see my mistake.

Puzzled Boy · Accepted Answer · 2012-05-09 20:04:25Z

0

use $query = "SELECT * FROM videos WHERE expire >= $timestamp AND home = 1 AND active = 1 ORDER BY id DESC LIMIT 0,1";

instead

$query = "SELECT * FROM videos WHERE expire >= $timestamp AND home = 1 AND active = 1 ORDER BY id DESC LIMIT 1";

answered May 9, 2012 at 20:04

Puzzled Boy

274 bronze badges

Collectives™ on Stack Overflow

MySQL returning wrong record

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related