Limit SQL query by users

Sama34 · 12-14-2012 06:36 PM

SQL Code

				$query = $db->query('
					SELECT a.aid, a.name, a.image, p.uid
					FROM '.TABLE_PREFIX.'ougc_awards a
					JOIN '.TABLE_PREFIX.'ougc_awards_users ag ON (ag.aid=a.aid)
					JOIN '.TABLE_PREFIX.'posts p ON (p.uid=ag.uid)
					WHERE p.'.$pids.' AND a.visible=\'1\' AND a.type!=\'1\'
					ORDER BY ag.date desc'
				);

i want to limit the number of rows by UID, how?

xD

Now seriously, I have no idea. Some clue please?

Threaded Mode \| Linear Mode Standard Tools
Forum Jump: View a Printable Version Send this Thread to a Friend Subscribe to this thread