Please replace the ??? with your data!

• Your URL: http://private
• The browser used: NA
• cforms version: 2.6
• Your Wordpress version: 2.6

I am working with cforms and have a custom plugin that works with cforms.  It lists all the submitted data in a list format (by date).  I am trying to get it add the Company name before the date.  I'm a little baffled and was wondering if I could get some help to figure out why it's not showing up (the company name.. everything else works fine)

------------

    if($userdata->user_level == "10"){$selectby = FALSE;}else{$selectby = "WHERE u_id = '$userdata->ID'";}
    $date = $wpdb->get_results("SELECT DISTINCT(sdate) FROM $wpdb->cformsdata $selectby");
       $company = $wpdb->get_results("SELECT field_val FROM $wpdb->cformsdata WHERE u_id = '$userdata->ID' AND field_name = 'Company' AND date = '$dates->sdate'");
     foreach ($date as $dates)
     
     {

      echo "<a href=\"{$_SERVER['REQUEST_URI']}&by_date=$dates->sdate\">". $company->field_val .$dates->sdate."</a><br />
      ";
     }

It is defined earlier :-)  I didn't to mess up the post by posting a really long file :-D  so I just added the code that was relavent.  It is supposed to be in the foreach loop, I was putting it in different spots to see if that would work and didnt put it back heh sorry!  I will play around some more with it and let you know what I figure out!

Thanks so much for the quick response!  I really love this plugin.

Well it was custom build for this specific system :-)  Sorry!