|
|
 |
|
|
Thread Tools | Display Modes |
|
|
Mar 31st, 2006, 10:39 AM
|
#1 |
|
Newbie
Join Date: Feb 2006
Posts: 5
Rep Power: 0
 |
Project List!
Hi, Need a bit of help.
ive designed a web-based system that allows to add a student project to a project list. The Project list has the following fields- PROJECT ID, PROJECT DETAILS, PROJECT TITLE, PROJECT ORIGINATOR. The project list will have around 100 student projects. What i would like to do is to click on the project orginator title and all the project originators would be shown in alphabetical order. How can that be done? Any1 have any idea how to do this....... plz let me know. thanx........ |
|
|
|
Mar 31st, 2006, 11:44 AM
|
#2 |
|
Professional Programmer
Join Date: May 2005
Location: Detroit
Posts: 254
Rep Power: 4
  |
select * from projects WHERE PROJECT_ORIGINATOR = person ORDER by PROJECT_ORIGINATOR;
|
|
|
|
|
Mar 31st, 2006, 1:20 PM
|
#3 |
|
Professional Programmer
Join Date: Oct 2004
Location: .ro
Posts: 406
Rep Power: 5
 |
@raf_123 - Perhaps giving sql a look wouldn't hurt
__________________
Don't take life too seriously, it's not permanent ! |
|
|
|
|
Mar 31st, 2006, 3:32 PM
|
#4 |
|
Programming Guru
 
Join Date: Jul 2004
Location: United States
Posts: 3,473
Rep Power: 8
|
depends on how / where your information is stored.
__________________
http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root." |
|
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Hybrid Mode
