[afullcup]

well, I got past that database error above, but now I have another database/code issue... Here's my code segment...

PHP Code:

        $query_string =  "SELECT rebate_id, product, rebate_type, max_value, exp_date
                FROM " . TABLE_PREFIX . "rebate 
                $query_sort
                LIMIT $limitlower, " . $viewrebates['perpage'] . "";

        echo "query:  $query_string";

        $rebate_list = $vbulletin->db->query_first($query_string);

        while ($rebate = $vbulletin->db->fetch_array($rebate_list))
        {
           echo "in while <BR>";
           echo $rebate[product];
           echo $rebate[rebate_type];
        } 


The query_string is fine - I can run the resulting query on my database directly and get rows back. However, I never get "in while". Am I fetching the array wrong?

answered my own question, sorry.... had query_first instead of query_read. it's late, what can i say.

thanks ya'll.