PHP/MYSQL What am i doing wrong -
so need stuff. in photo bellow, "kompanijos savininkas" should display "last name, name" of users in opened list. every user_id has different color. name should colored color code is. doing wrong because color code showing not colored name. here photo , codes changed. please.
// collect users company owner list $q = new dbquery; $q->addtable('users','u'); $q->addtable('contacts','con'); $q->addquery('user_id'); $q->addquery('user_color'); $q->addquery('concat_ws(", ",contact_last_name,contact_first_name)'); $q->addorder('contact_last_name'); $q->addwhere('u.user_contact = con.contact_id'); $owners = $q->loadhashlist(); <tr> <td align="right"><?php echo $appui->_('kompanijos savininkas'); ?>:</td> <td> <?php echo arrayselect($owners, 'company_owner', 'size="1" class="text" style="color:"$user_color"', ((@$obj->company_owner) ? $obj->company_owner : $appui->user_id)); ?> </td> </tr>
<?php echo arrayselect($owners, 'company_owner', 'size="1" class="text" style="color:'.$user_color.';"', ((@$obj->company_owner) ? $obj->company_owner : $appui->user_id)); ?>
Comments
Post a Comment