How to Concatenate Column Values from Multiple Rows

Submitted by admin on

Just want to share with you on how to concatenate or combine one or more values from multiple rows. This SQL code is part of my “Online Hotel Reservation” project.

The idea here is to group column values while concatenating the other column to avoid duplicate records.

Here’s an example:

I have the following record on my table:

Student Administration System

Submitted by Lakmal on

User *Administrator = admin123 *Accountant = reg123 *Register == acc123 *some system password == admin@123 Note:First Install Componant & run Programme ======================================================== this project is created for the Institute ======================================================= Student Administration system by: Lakmal Buddhi Gunasekara(0713356190) lakmalbuddhi2@gmail

Facebook Timeline Clone Script

Submitted by argie on
In this code you will learn how to make a timeline like facebook. It also includes live search, wall post, delete wall post, add other that can be found in this application. This system allows the user to post picture. The user can also add and delete friends with instant notification. this system has a comment counter and can determine the interval of time from the date posted. database name

Number Only in TextBox

Submitted by admin on
After receiving a lot of emails about how to filter keys that accepts only number character, I decided to post this simple code to illustrate on how easy it is to allow only numbers and other character like comma (,), Period (.) and Backspace key. So far this is the best code that filters character on a textbox. There are lots of codes on the internet but some don’t allow backspace and a comma