A user's language is obscene. What should I do?
Troublesome complex fetching from database
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		  
Зарегистрируйся!
QAIX > Java Programming > Troublesome complex fetching from database 1 October 2001 05:58:22
  Recent blog posts: 
How to make a Christmas photo…
Every Christmas people take a off from their busy schedule. This is the time they can enjoy with their…

Car web design, motorbike…
If you are looking for Car website design, Auto web design, bike web design, or anything similar our…

The Best Video Converter-a…
iOrgSoft Inc. has released the powerful Video Converter - iOrgSoft Video Converter 1.6.0, the latest…

Photo DVD Maker New Website…
AnvSoft Inc., the multimedia software developer, unveils a new website…

How to rip DVD movie, convert…
It is no doubt that PSP is an excellent game player. However, it is not playing games all the time; you…

World’s Most Unusual Christmas…
This Christmas, don’t go with that ho-hum, run-of-the-tree-far­­m tree your family always gets…

Facebook account cracker
facebook account cracker (50 GBP) Before you're told what this tool does, it's worth noting that…

BlackBerry Storm review…
As BlackBerry fans, you can’t miss the BlackBerry Storm. At Nov 6th, 2008, the word on the street is…

Review on Any DVD Cloner
Have you ever had a DVD Movie collection broken or lost? Have you ever wanted to backup movies but…

All recruitment agencys come…
What is RCCSS? RCCSS is a new unique peice of software which will scan millions of major sites and…

  They have birthday today: 
akram mellice
Daffy little vampire
  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
[EJB 3.0] - PersistenceContext…
I have tried to inject a PersistenceContext into a JSF managed bean POJO as is outlined here. The…

[JBoss jBPM] - Re…
Raj, as I just stated in the other thread you will have to lock on processInstance. What seems to be…

Passing LARGE (1500-2500 chars)…
I want to pass a large (easily 1500-2500 characters) variable between a DHTML object using Jscript over…

Rebuild trailer not found…
Hi, in an application that read information from an Oracle database and create a PDF I get this error…
  Recent forum topics: 
Rakudo bug reports still go to…
Some of you may have seen the announcements on the Parrot lists that Parrot will be starting to use…

Stop sql Injection attacks and…
HI there, not long ago I found a website explaining a feature of a dbi-addon (or catalyst-addon) which…

[JCA/JBoss] - getOutputStream()…
Hi Guru, My project was developed by using JDeveloper10g. I have deployed the EAR file to…
  Recent forum comments:
RE: Macro: Substitution font and…
Not a macro approach, but after you have the data in the page you could just use Edit Select All in…

RE: Macro: Substitution font and…
You wouldn't want to use points to size your characters on the web page. Use pixels, em, en, ex…

RE: Problem with uploader
Matthew Whipple wrote: If the open failed then wouldn't the die kick in and at least say something in…

RE: [JCA/JBoss] - getOutputStream()…
Put Your Java Code in Servlet. It will work fine Try to avoid scriplet in jsp

RE: ASP Access Recordset Paging
Thanks a lot! You've been really helpful. What eventually solved the problem was moving the DB from…

RE: ASP Access Recordset Paging
e.l. wrote: You are not using odbc, so you should have removed those groups from the crosspost. I…

RE: ASP Access Recordset Paging
Thanks for the quick reply. 1. I use MS Office Access 2003 (11.8166.8202) SP3 2. The code of my…

RE: ASP Access Recordset Paging
e.l. wrote: We can't answer without seeing: 1. your database type and version 2. your connection string…

RE: ASP Access Recordset Paging
Hi, I'm having a different problem, but the same error message (ADODB.Recordset (0x800A0CB3) ). I…

RE: how to retrieve CheckBox value…
Evertjan. wrote: More like .Count…
  Moderators:
 Administrator
 Protorioris

Troublesome complex fetching from database

Kath 1 October 2001 05:58:22
 Quite an interesting quandry I have.

What I have is this:

Table schooltypes:
(typeid is a unique# iding the type, schooltypes is the type of school, say
"Elementary School" or "High School")

| typeid | schooltypes |

Table schools:
(typeid is the type the school falls under, schoolid is the unique# iding
the school, schoolname is the general name like "Park Shore High School")

| typeid | schoolid | schoolname |

Table teachers:
(tuserid is their unique id, salutation is the Mr/Mrs/Miss/Ms/Dr, last name
is well, duh :)­

| tuserid | salutation | last name |

Table teachers_schools:
(tuserid is the teacher's id, next to the school they are assigned to. Note
the possiblity for a teacher assigned to more than one school (hello,
cutbacks and skeleton budgets)).

| tuserid | schoolid |

What I need to be able to do is list all this information as such:

School type:

+ School 1
- Teacher and their Teacher ID
- Teacher and their Teacher ID

+ School 2
- Teacher and their Teacher ID
- Teacher and their Teacher ID
- Teacher and their Teacher ID

+ School 3
- Teacher and their Teacher ID
- Teacher and their Teacher ID

Another School Type:

+ School 5
- Teacher and their Teacher ID
- Teacher and their Teacher ID

+ School 7
- Teacher and their Teacher ID
- Teacher and their Teacher ID

Currently, I AM able to list the school type and the school correctly.
However, when I come to listing the teachers in the school, every teacher is
listed under every school, some more than one time.

Any ideas/code snips on how to do this?

In what direction should be I solving this?

Going from type->school->teach­ers assigned->teacher info?

Or teachers assigned->teacher info->schools->type­?

Right now I am doing the first, sorta.

- k

Add comment
Justin Garrett 1 October 2001 05:58:22 [ permanent link ]
 Try the following to organize your results. You'll have to check the table
names and typos etc.

$sql = "SELECT schooltypes.schoolt­ypes,
schools.schoolname,­
teachers.lastname,
teachers.tuserid
FROM schooltypes,
schools,
teachers,
teachers_school
WHERE schooltypes.typeid = schools.typeid
AND schools.schoolid = teachers_schools.sc­hoolid
AND teacher_schools.tus­erid = teachers.tuserid";

$result = /* perform query */;

while($row = mysql_fetch_object(­$result)){

$data[$row->schooltypes][$row->schoolname][] = "$row->tuserid
$row->lastname";

}

/* organize */

for(reset($data); $school_type = key($data); next($data)){
echo "$school_type<br><b­r>";
$schools = $data[$school_type];
for(reset($schools)­; $school_name = key($schools); next($schools)){
echo "$school_name<br><b­r>";
$teachers = $data[$school_type][$school_name];
$count = count($teachers);
for($i = 0; $i < $count; $i++){
echo "$teachers[$i]<br>";
}
}
}

--
Justin Garrett


"Kath" <kath@kathweb.net> wrote in message
news:002601c149f3$7­dec4000$82e53181@res­net.sunysb.edu...> Quite an interesting quandry I have.>
What I have is this:>
Table schooltypes:> (typeid is a unique# iding the type, schooltypes is the type of school,
"Elementary School" or "High School")>
| typeid | schooltypes |>
Table schools:> (typeid is the type the school falls under, schoolid is the unique# iding> the school, schoolname is the general name like "Park Shore High School")>
| typeid | schoolid | schoolname |>
Table teachers:> (tuserid is their unique id, salutation is the Mr/Mrs/Miss/Ms/Dr, last
name> is well, duh :)­>
| tuserid | salutation | last name |>
Table teachers_schools:> (tuserid is the teacher's id, next to the school they are assigned to.
Note> the possiblity for a teacher assigned to more than one school (hello,> cutbacks and skeleton budgets)).>
| tuserid | schoolid |>
What I need to be able to do is list all this information as such:>
School type:>
+ School 1> - Teacher and their Teacher ID> - Teacher and their Teacher ID>
+ School 2> - Teacher and their Teacher ID> - Teacher and their Teacher ID> - Teacher and their Teacher ID>
+ School 3> - Teacher and their Teacher ID> - Teacher and their Teacher ID>
Another School Type:>
+ School 5> - Teacher and their Teacher ID> - Teacher and their Teacher ID>
+ School 7> - Teacher and their Teacher ID> - Teacher and their Teacher ID>
Currently, I AM able to list the school type and the school correctly.> However, when I come to listing the teachers in the school, every teacher
listed under every school, some more than one time.>
Any ideas/code snips on how to do this?>
In what direction should be I solving this?>
Going from type->school->teach­ers assigned->teacher info?>
Or teachers assigned->teacher info->schools->type­?>
Right now I am doing the first, sorta.>
- k>


Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

QAIX > Java Programming > Troublesome complex fetching from database 1 October 2001 05:58:22
see also:
[PATCH MM] (was Re: VMS (non-perl)…
[PATCH MM_VMS.pm@15662] disttest tweak…
vms_pipe_torture.t
пройди тесты:
see also:
How to strip DRM off iTunes M4P music…
How to transfer iTunes M4P music to…
How to import iTunes M4P music to…
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .