whats wrong here?

[thoand]

Can anyone check the code,
the query is ok, but I can't seem to tie $article and $article together

CODE:

				$articles = $db->get_results("SELECT 
				a.id, a.pageid, a.priority, a.title, a.abstract, a.frontpageabstract,
				a.body, a.showlink, a.button, a.substurl, a.pubdate, a.expdate, a.published, a.author, TO_DAYS(a.expdate) - TO_DAYS(NOW()) AS daysleft
				, p.* FROM articles a, pages p WHERE a.pageid = p.pid AND (a.title LIKE '%".$q."%')";
				$articles .= "  ORDER BY a.pubdate DESC");

thanks,

regards Thomas A

[HalfaBee]

Have a look at what you are trying to do.

$articles is = to whatever $db->get_results(some select string) returns without the 'ORDER BY' clause.

Try indenting properly and you will see what is happening.

HalfaBee