17.
Holy shit it are correct

At 4/11/08 04:29 PM, EviLudy wrote: about a second between when my swing hits the body and death to occur?

Just leveled up and lost the axe, lol.
Still pretty fast

about a second between when my swing hits the body and death to occur?

I have no experience with INNER JOIN. Where do I go from there?

So I'm on this databse project for my school and I'm having some trouble with getting the right query. What I have is this:

SELECT bezoeker.voornaam, bezoeker.tussenvoegsel, bezoeker.achternaam, bezoeker.woonplaats AS uit, route.film_1 as 'Film 1', route.bios_1 as 'bioscoop 1', route.film_2 as 'Film 2', route.bios_2 as 'bioscoop 2', route.film_3 as 'Film 3', route.bios_3 as 'bioscoop 3', route.film_4 as 'Film 4', route.bios_4 as 'bioscoop 4', route.film_5 as 'Film 5', route.bios_5 as 'bioscoop 5'
FROM bezoeker, route
WHERE route.routenr=bezoeker.routenr
ORDER BY bezoekersnr;

Nou this pops up all records from the table 'bezoeker' and some fields of it, followed by a bunch of numbers (from the table 'route' which holds numbers for 'bioscoop_1' ~ 'bioscoop_5' as well as 'film_1' ~ 'film_5')

Now I have two other tables called 'bioscoop' and 'film.'
For example I will use the table 'film'

Film's contents are something like this:
filmnr | titel
1 | Juno
2 | Eastern Promises

Now when in my query I show 'route.film_3' it shows a number, for example '2'
What I want to do is not show that number but show the text that is in the field of 'titel' in the table 'film' where 'filmnr' is 2. So in this case it would show Eastern Promises
And so on for all fields: film_1, film_2, film_3, film_4 and film_5.

Same goes for bioscoop. Bioscoop has 'bioscoopnr' and 'naam.' And I want it to show what's under the field 'naam' for the corresponding 'bioscoopnr'

My question is: is this possible in one query? (so no messing around with php or whatever. I need to be able to open access or another database tool, enter this one query and get the desired result) And if it is possible, can someone help me with it?

Thanks in advance.
I hope I made clear what my problem is. Below is an image about how relations should be.

At 3/14/08 06:47 PM, Gagsy wrote: IT. Though it's fucked up at the end.

It was too long for it's coolness :(
Insomnia, the shining and Cujo are win. I have yet to read misery

I don't mind waking up.
Getting out of bed that's the problem. as well as being fucking tired the first part of my day.

I'm gonna try and pull it off.
Updates later.

At 1/25/08 09:33 PM, jackripperz wrote: Anyway i like traveling. Right now,im preparing myself for an audition. If i can win that, i can go international! If I can.

I was just about to flame your for staying off topic, but what the hell.
Audition for what? I myself am sort of an actor myself. Been in several plays and got paid for it. I'm auditioning for Drama school pretty soon.

ALL RIGHT FOLKS BACK ON TOPIC

At 1/17/08 10:53 AM, flashsurfer11 wrote: BBS is KH3, there are a two newer games in production 365(?)/2 days which is DS, BBS for a next-gen console, in the english (or jap if you can read it) secret video in KH2 it said birth by sleep is KH3.

All false.
None of the new announced games are sequels to KH2.

- 358/2 days is set before KH2 and is about Axel and Roxas and their days in the organization. Since Roxas has left the organization in KH2, it is set before KH2. For nintendo DS.

- KH: Coded is basically bullshit. It's about people having forgotten about some events and some digital tricks to clear it up and reliving it all. Takes place between KH and KH2. For phones.

- Birth by sleep is the most promising new game thus far. It's a story with all new characters, set 10 years before the events of Kingdom Hearts. This game probably explains all items that eventually caused the events of Kingdom Hearts. It features a guy who looks just like Roxas but since Sora only got heartless in KH2, he didn't have a Nobody 10 years before that. So either it's a weird look-a-like or we're getting a weird ass explanation. Why did we see a trailer at the end of KH2 about this? That's easy. Seeing the trailer doesn't mean it's the next sequel. It has little to do with what happened in KH or KH2, just what happened before. Just because KH's bonus video's were about a sequel doesn't mean KH2's is. It said 'birth by sleep' and not 'kingdom hearts 3'. Also, birth by sleep is coming to PSP.

The actual Kingdom Hearts III, well I got my hopes up. The only one of the above games I REALLY want to play is birth by sleep and possibly the days one. I only saw a recap of all cutscenes of Chain of Memories and I understood KH2 fine. The reason I put up with Kingdom Hearts games is because I really really like the story. I totally enjoyed KH and KH2 though, but KH2 was pretty easy and CoM sucked balls.

Let's all hope we get KH3 confirmed as soon as possible and we get to follow the adventures of Sora, Riku and Kairi in another kick-ass console game. (no handheld bullshit)

I wonder where that fish has gone.

My best friend once fainted on me in class, he was sitting next to me and suddenly he was laying on my shoulder so I was like "dude, get the fuck off" and then I noticed he was all fucked up and it scared me shitless.

I ought to try it once though.

At 1/12/08 03:52 AM, q13qew wrote: awesome the shooter game was great

At 1/12/08 04:25 AM, Cyberdevil wrote: Breakpoint twas pretty cool :)

Thanks =D

Hot Fuzz not making the top 10?

Jet - Are you gonna be my girl.

At 12/21/07 07:39 PM, Kuro wrote: WHAT'S THIS?

There's something very wrong.

At 12/18/07 06:45 PM, MetalDart wrote: Offtopic but is your eye better? :)

Pretty much, it's open but the eye itself is still slightly red and area around it purple. Yay

At 12/18/07 06:42 PM, SouthAsian wrote: 30 hours?but your in Europe.When I visited England from America it took me 8 hours.

We're going by bus, which sucks. In total (way to go there and back) we're going to be in the bus longer than in London. Plus I'm not leaving yet. The bus will be leaving exactly 24 hours from now.

At 12/18/07 06:37 PM, BananaBreadMuffin wrote: Have sex with me.

Pick me up at the Globe, or buckingham palace. Whatsever closer to a dark alley for the act :D

At 12/18/07 06:38 PM, Gagsy wrote: Go to a show in the evening for sure.

I wanted to go see Wicked which I've listened to for ages, but still haven't seen the show. It fucks up my departure plans though, I could see half an hour of the show before I'd have to get out of there to catch my bus.

What should I do in the one free day I have there?

Working link

It's genius :D

The greatest game ever made.

At 11/30/07 11:56 AM, Lucy wrote: I can jiggle.

That's hot.

At 11/30/07 11:55 AM, Lucozadedude wrote: I'm sure I've seen this exact thread before...

False. Not the exact, but something like it. I posted before searching but NOBODY CARES.
I'm referring to actual dances. Ballroom/Latin/whatever

I can do quickstep, cha-cha, tango, waltz and my favourite, the jive. Though I'm pretty basic. I'm thinking of taking lessons to become kickass.

So do you dance?

How could I forget about Ray?

Now baby listen, baby don't you treat me this way...

Perfume
The Departed
Trainspotting

still have an unsponsored unreleased game

At 11/3/07 12:53 PM, Mechabloby wrote: What are you doing a show for? Can you post it on youtube for us, after? =)

It's a play based on some german book about a murderer who kills 25 girls.

That's right. In half an hour I have to be at the theatre. I'm playing the second male lead in a play and this is our 5th show. Now I didn't get nervous ever since the opening night of a play I was in 2 years ago.

Why am I nervous as shit?
1. It's a big theatre. And it's sold out. But I've done that before.
2. There are a dozen of my closest friends coming, waaay more than usual.
3. There is a professional team using 7 camera's making our tv/dvd recording.

Newgrounds, how do I stop being nervous?