Choose from a list

2 posts by 1 authors in: Forums > CMS Builder
Last Post: March 1, 2019   (RSS)

By andreasml - March 1, 2019

Hi

I am writing the following code in the List options of a field and it does not work.  Can I have some help?

(I assume that the problem would be at the <?php echo $CURRENT_USER['hospital'] ?> part because if i change it to a value it works fine. 

Regards

Andreas

SELECT CONCAT (fullname, " ", name)
  FROM `<?php echo $TABLE_PREFIX ?>accounts`
  WHERE hospital=<?php echo $CURRENT_USER['hospital'] ?>
  ORDER BY fullname

By andreasml - March 1, 2019

I think i fixed the problem. Just a pair of '' were missing. 

SELECT CONCAT (fullname, " ", name)
  FROM `<?php echo $TABLE_PREFIX ?>accounts`
  WHERE hospital='<?php echo $CURRENT_USER['hospital'] ?>'
  ORDER BY fullname