TalkPHP - View Single Post

Nor · 01-25-2008, 01:05 PM

Okay after realizing that this wasn't what I wanted when I went home, I thought I'd mention this is more as of a blog type script. My sql is set up like this atm:

Code:

$db->set_query("SELECT t.*, u.user_id,u.user_name FROM `{$config['db_prefix']}topics` t, `{$config['db_prefix']}users` u WHERE t.topic_parent = '{$id}' AND u.user_name = t.topic_author ORDER BY `topic_last_posted` DESC");

Now I just need to get the latest reply to this topic and everything will be well, i tried different approaches like GROUP BY didn't work and now I'm back here.

01-25-2008, 01:05 PM	#6 (permalink)
Nor The Addict Join Date: Nov 2007 Posts: 282 Thanks: 61	Okay after realizing that this wasn't what I wanted when I went home, I thought I'd mention this is more as of a blog type script. My sql is set up like this atm: Code: $db->set_query("SELECT t., u.user_id,u.user_name FROM `{$config['db_prefix']}topics` t, `{$config['db_prefix']}users` u WHERE t.topic_parent = '{$id}' AND u.user_name = t.topic_author ORDER BY `topic_last_posted` DESC"); Now I just need to get the latest reply to this topic and everything will be well, i tried different approaches like GROUP BY didn't work and now I'm back here. __________________ PHP/XHTML Freelancer:* Cleanscript.com v3 - Programming starting at just $5 act now!