This topic is locked

Multiple field values for QR Code

1/31/2015 1:44:07 PM
PHPRunner General questions
S
schaet author

Hello, I see how to display a QR Code for one specific field, however how would I do this for multiple fields; IE. fname, lname, address DOB etc ...
Thanks!

Steven

Sergey Kornilov admin 2/1/2015

Set 'View as' type for all of those fields to 'QR code'.

S
schaet author 2/1/2015



Set 'View as' type for all of those fields to 'QR code'.


Won't that give me multiple QR codes? I'm looking for all the information to be on one code.

Sergey Kornilov admin 2/2/2015

Modify your SQL query to create a one calculated field with all that info in there. If your database is MySQL you can use CONCAT() function:

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat