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.

[Dark_Wizard]

PHP Code:

$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
        AND h.sid > 0
        ORDER BY h.date
    ");