[Christos Teriakis]

Originally Posted by maineGuy72

the only thing i can think of is its not pulling the id correctly like it was doing with the PM to people watching the ad.

No... It's very difficult to find it:
1.- Because the syntax is 100% correct
2.- It's childish error even for novice coders

Well, the error is that is not really runing the query. Just adds the query in a variable. It says:

$sellerwhois_sql = "SELECT * FROM ".TABLE_PREFIX."microclassifieds_orders WHERE sellerid=$userid AND showrating=1 ORDER BY sreviewdate DESC";

which is 100% correct if you want to store the query in a variable and run it at later time. But if you want to run the query right now the syntax is:

$sellerwhois_sql = $vbulletin->db->query_read("SELECT * FROM ".TABLE_PREFIX."microclassifieds_orders WHERE sellerid=$userid AND showrating=1 ORDER BY sreviewdate DESC");

So simple..............