Latest ads

Kandy Welcome all my all new pet shop Bark.lk
- dilumrane
- Updated: Today at 12:26 PM
Windows RDP Only Rs.500 a month
- Blogerwiki
- Updated: Yesterday at 12:41 PM
Ad icon
V2ray VPN for Tunneling
- hu KANNA
- Updated: Oct 22, 2026
FREE SEO Check & Google Maps Check for Sri Lankan Businesses | Web Design, Website Price Rs 14,900 |
- LankaSolve
- Updated: Oct 20, 2026
ඕනම රටකට සෙට් වෙන CV එකක්
- ErMurazor
- Updated: Oct 17, 2026

Reply to thread

Message: <blockquote data-quote="Ayeshlive" data-source="post: 19848561" data-attributes="member: 363439"><p>MySQL wala "key" kiyala field name ekak thiyenna widihak na eka reserved keyword ekak nisa. </p><p></p><p>Mama red colour eken danne oyage thiyena tables and fields. </p><p></p><p>SELECT m.<span style="color: Red">mail</span>, m.<span style="color: Red">member_id</span>, fn.<span style="color: Red">value</span> AS first_name, ln.<span style="color: Red">value</span> AS last_name FROM <span style="color: SeaGreen">members</span> m LEFT JOIN <span style="color: SeaGreen">member_meta_data</span> fn ON fn.<span style="color: Red">member_id</span> = m.<span style="color: Red">member_id</span> AND fn.<span style="color: Red">key </span>= <span style="color: Magenta">first_name</span> LEFT JOIN <span style="color: SeaGreen">member_meta_data</span> ln ON ln.<span style="color: Red">member_id</span> = m.<span style="color: Red">member_id</span> AND ln.<span style="color: Red">key </span>= <span style="color: Magenta">last_name</span></p><p>purple colour eken thiyenne table eke thiyena data. </p><p>red colour eken tiyuenne table field names. </p><p>green colour eken thiyenne table names.</p></blockquote><p></p>

Verification: Winadiyakata thappara keeyak tibeda?

Top Bottom