mysql

[pchsmvp]

i have this table..
http://i5.photobucket.com/albums/y17...alam/dbase.jpg

and i want to have an output like this..
http://i5.photobucket.com/albums/y17...lam/output.jpg

i don't know how to select the subjects once.. I've already tried the DISTINCT function and GROUP BY function but the subjects only gone out of placed in the table, they were not properly arranged..

[zimonyi]

I am not sure you can.

It would be easier to select them all like your dbase.jpg and then have some logic that removes the multiple subjects and displays them like your output.jpg.

Archie

[pchsmvp]

I've already tried several logic but i failed

[zimonyi]

Well, what I would do is most likely make a query that simply returns all the rows that you present there (let us say it is for a week).

So a query might look like this:

SELECT time, weekday, subject FROM table WHERE week = <some week>

each row looks like this then

time | weekday | subject
7:30 | monday | PRGLF - IT
8:30 | monday | PRGLF - IT
9:30 | monday | PRGLF - IT
10:30 | monday | PROG2 - IT
etc

Then in your PHP I would create a class (for example Subject) that represents each subject, with a an array that has the keys mathing the weekdays and entries for the times (in another array).

class Subject {
$subjectName;
$weekdays = array(<for each weekday, you have an array of the times))
}

Then you can create your table and use the length of the times as colspan for each subject.

Hope that helps,

Archie

[pchsmvp]

i got it.. thanks for the help