vhkristof

Well, I don\'t know if this will work, but I know that in Oracle you have a statement called ROWID...so this would be like SELECT ROWID AS \'rank\', column1, column2 FROM table WHERE rank = 2 I don\'t know if this will work ..., let me know

I believe that is what Metalblend is saying ... The DB columns are shown horizontally in this view ...

but when the birthday is on 1 january and i query the db on 31 december ?

Concerning the change of year (2003-2004), would it work completely if I queried a UNIX timestamp? thx for the replys, really appreciate it!

but the year is 1982, 1983, ...

Hey, Here is what I want to do ... I\'ve got a table with the birthdays (when they were born, year eg 1982). I wan\'t to select the people who will celebrate their birthday between tomorrow and 8 days from now ... Is there a way? Problem is the years are 1982, 1983, ... and not 2003 Thx!

Thx for your reply, it works! But what does the WHERE t1.id IS NULL part do?

I tried it in dozen ways, but it just won\'t work HELP!

Nope, it ain\'t working :\'( This is my code: [php:1:8651aac6a3]<?php $sql = mysql_query(\"SELECT * FROM kalender WHERE ploegid = \'$ploegid\' AND matchid NOT EXISTS ( SELECT verslag.matchid FROM wedstrijdverslagen verslag, kalender WHERE kalender.matchid = verslag.matchid ) \") or die(mysql_error()); ?>[/php:1:8651aac6a3] I also tried removin\' matchid from AND matchid NOT EXISTS ... Thx for your reply\'s !

This is my code, and it gives an error [php:1:a2640e58e6]<?php $sql = mysql_query(\"SELECT * FROM kalender WHERE ploegid = \'$ploegid\' AND matchid NOT IN (SELECT matchid FROM wedstrijdverslagen)\") or die(mysql_error()); ?>[/php:1:a2640e58e6]

Hello, I\'ve got 2 tables: Table1: id name city Table2: id level These are not my actual tables, but ... What I want to do is: Get al the id\'s from Table2 that are NOT in Table1 Something like the MINUS-property in Oracle Can anyone help me? Thx!