[SOLVED] SMF problem with limit

[rockinaway]

	$articles = db_query("
		SELECT date, author, subject, body, id
		FROM {$db_prefix}tp_articles 
		ORDER BY date DESC LIMIT 0,2", __FILE__,__LINE__);

 

That is my code, I want the latest article but when I have the LIMIT set to 0,1 then no article is shown, even though there is a newer article.. what could be the problem?

[toplay]

You can just use "limit 1" also "date" is a reserved word in MySQL so you should change the column name to something more meaningful or enclose the column name in backtick marks (i.e. `date`).

 

Try the query outside of php code first (like using sqlyog or phpmyadmin). When it works there, put it into the code. As part of debugging this, display the full query to make sure it's what you expect.

[rockinaway]

It works in phpMyAdmin, but not in the file or webpage :S

[bubblegum.anarchy]

Make this change:

 

$articles = db_query($query = "
		SELECT date, author, subject, body, id
		FROM {$db_prefix}tp_articles 
		ORDER BY date DESC LIMIT 0,2", __FILE__,__LINE__);

print '<PRE>'.$query.'</PRE>';

 

And post the query here.

[rockinaway]

SELECT date, author, subject, body, id
		FROM smf_tp_articles 
		ORDER BY date DESC LIMIT 0,2

 

That is what it returns.... :S

[bubblegum.anarchy]

What happens when you add backticks to the date column?

 

$articles = db_query("
		SELECT `date`, author, subject, body, id
		FROM {$db_prefix}tp_articles 
		ORDER BY date DESC LIMIT 0,2", __FILE__,__LINE__);

[rockinaway]

Fixed ... it was due to another mysql_fetch_array called earlier in the script.