2. PHPRunner General questions
  3. Results missing in SQL field ??
This topic is locked

Results missing in SQL field ??

 		4/2/2012 12:40:30 PM
PHPRunner General questions
S
 scoobysteve author

I have the values of 4 fields being joined together in the SQL query section to form a single fields which is a address for my Google map, however in most (about 80%) of the results there is no display. as seen below, this is on PHPRunner this worked fine on ASPRunner before I changed up to PHP.


And here are the results


Sorry the field used fro the zip code is out of screen but its Spare18
C
 		cgphp 4/2/2012

Try this solution:

CONCAT_WS(', ',`State/County`,Country,Spare18) as Spare20
S
 		scoobysteve author 4/2/2012



Try this solution:

CONCAT_WS(', ',`State/County`,Country,Spare18) as Spare20



Thanks that fixed it, much appreciated.