Reply to thread

Message: <blockquote data-quote="doe" data-source="post: 467823" data-attributes="member: 98944">I see... The problem is:  You only get the values from your rp_jobs table without a connection to your users table. You need to build a relation with the users table. Try this query instead:[CODE=sql]$q = mysql_query("SELECT * FROM rp_jobs AS rp LEFT JOIN users AS u ON rp.userid = u.id WHERE rp.type = 'Skilled' and rp.hidden = 0");[/CODE]I'm not sure where the "hidden" columns is from. If you encounter errors try to the change the text "rp.hidden = 0" to "u.hidden = 0". If you still encounter problems delete "rp.hidden = 0" from your query.</blockquote>