[iceman-x]

Originally Posted by amykhar

I did not incorporate it into register.php because my members have to register first before they can become premium members. The paypal integration requires that their username already exist. Therefore, people registering can only choose from the non-premium styles.

Regarding the second question, I would simply change This:

$allstyles=$DB_site->query("SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect=1 GROUP BY user.styleid");

to this:

if ($bbuserinfo[premium]{
$allstyles=$DB_site->query("SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect>0 GROUP BY user.styleid");
}
else {
 $allstyles=$DB_site->query("SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect=1 GROUP BY user.styleid");
}

Hey, i cant make this work. i get the same error every time i tryed. error at line 67.

this line:

$allstyles=$DB_site->query("SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect>0 GROUP BY user.styleid");

Can any one help me. thanks.