Here's a good one.

[Squally]

Ok, I have a table that has a sid and a tid. I want to pull the names from my user table for each but only if sid isn't 0. this is what i have so far.

$get_points = $DB_site->query("
		SELECT h.id, h.sid, h.house, h.date, h.points, h.comments, u.username as tid_name
		FROM housepoints h, 1user u
		WHERE h.tid = u.userid
		AND h.points != 0
		ORDER BY h.date
	");

That gets all the info I need so far except i need to get the username for sid if it's not 0.