view data from table

Question

karet 0 Newbie Poster

14 Years Ago

hello everyone..
im student from indonesia n im newbie
ihave a problem n i need your help

ihave data from table, like that:

TGL || Tahun || semester || Keterangan

2010-1-1 || 2010 || Genap || LIbur tahun baru
2010-1-2 || 2010 || Genap || LIbur UAS
2010-1-3 || 2010 || Genap || LIbur UAS
2010-1-4 || 2010 || Genap || LIbur UAS
2010-1-15 || 2010 || Genap || LIbur UTS
2010-2-10 || 2010 || Genap || LIbur Semester genap
2010-2-11 || 2010 || Genap || LIbur Semester genap

ihave select tahun & semester to show this data.but iwant show the data like that:

TGL Libur || tahun-semester || keterangan

2010-1-1 || 2010-genap || LIbur tahun baru
2010-1-2 till 2010-1-4 || 2010-genap || LIbur UAS
2010-1-15 || 2010- Genap || LIbur UTS
2010-2-10 till 2010-2-11 || 2010-genap || LIbur Semester genap

how ican solved this problem?
what function php n query should i use?
before n after i said thanks very much for your help.

php

Edited 14 Years Ago by karet because: sorry,,bad writed

3 Contributors
3 Replies
69 Views
13 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by asaizanm

urtrivedi 276 Nearly a Posting Virtuoso

14 Years Ago

use following query for expected result

SELECT concat(min(TGL ),' till ',max(TGL )) as tgl_libur,
concat(tahun,'-',semester) as tahun_semester, kererangan
FROM `table_name` group by 
tahun,semester , keterangan

Edited 14 Years Ago by urtrivedi because: n/a

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

karet 0 Newbie Poster · Answer 1 · 2010-03-11T15:32:26+00:00

thank you very much bro urtrivedi. i will learn your clue. it will be some meaning for me.thanks

asaizanm 0 Newbie Poster · Answer 2 · 2010-03-11T17:54:56+00:00

hello everyone..
im student from indonesia n im newbie
ihave a problem n i need your help
ihave data from table, like that:
TGL || Tahun || semester || Keterangan
2010-1-1 || 2010 || Genap || LIbur tahun baru
2010-1-2 || 2010 || Genap || LIbur UAS
2010-1-3 || 2010 || Genap || LIbur UAS
2010-1-4 || 2010 || Genap || LIbur UAS
2010-1-15 || 2010 || Genap || LIbur UTS
2010-2-10 || 2010 || Genap || LIbur Semester genap
2010-2-11 || 2010 || Genap || LIbur Semester genap
ihave select tahun & semester to show this data.but iwant show the data like that:
TGL Libur || tahun-semester || keterangan
2010-1-1 || 2010-genap || LIbur tahun baru
2010-1-2 till 2010-1-4 || 2010-genap || LIbur UAS
2010-1-15 || 2010- Genap || LIbur UTS
2010-2-10 till 2010-2-11 || 2010-genap || LIbur Semester genap
how ican solved this problem?
what function php n query should i use?
before n after i said thanks very much for your help.

Hello i'm from malaysia ..u can do the query like this, SELECT nameoftable."TGL Libur" ,nameoftable.keterangan
CONCAT(nameoftable.tahun,' - ',nameoftable.semester) AS tahunsemester
FROM nameoftable
ORDER BY nameoftable.tahun, nameoftable.keterangan

hope this will give u a piece of help ,i will not solve the issue but you the keyword for join together the column in temporary column is CONCAT ..OK.