Help w/ pulling subscribers out of the database

[goblues]

This is what I have and I am getting an error stating that userid is abiguous. Please help. By the way running 3.5.1.

PHP Code:

// query active subscriptions
    $getusers = $db->query_read("
        SELECT user.userid,username
        FROM " . TABLE_PREFIX . "user
        LEFT JOIN " . TABLE_PREFIX . "subscriptionlog as subscriptionlog ON (subscriptionlog.userid = user.userid)
        WHERE subscriptionlog.status = '1' ORDER BY regdate DESC LIMIT 10
    "); 


[Marco van Herwaarden]

Are you sure you're getting the error from the above line? You shouldn't get it here.

PS You should change:

PHP Code:

FROM " . TABLE_PREFIX . "user 


to:

PHP Code:

FROM " . TABLE_PREFIX . "user AS user 


[goblues]

Well that little change you told me to make worked. Whether it was supposed to work, I don't know but that took care of the problem. Thanks!!!!!

EDIT.....Actually as I looked closer I was using $DB instead of $db. Would that make a difference. Also, what is the difference between $db and $db_site? As you can probably tell, I am just learning. Thanks for your time!

[Marco van Herwaarden]

Yes $db or $DB makes a difference. $DB_site is the vB3.0 notation, in vB3.5 replaced by $vbulletin->db, or simply $db depending on the scope in the script.

[goblues]

Originally Posted by MarcoH64

Yes $db or $DB makes a difference. $DB_site is the vB3.0 notation, in vB3.5 replaced by $vbulletin->db, or simply $db depending on the scope in the script.

10-4 Thanks for the info!!