Choose from a list

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

Archived
Reply
Reply

By andreasml - March 1, 2019

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

Archived
Reply
Reply

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