[Find row number]

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 realize how lame this is...]

I believe that is what Metalblend is saying ...

The DB columns are shown horizontally in this view ...

[How to query birthdays ...]

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

on 31 december ?

[How to query birthdays ...]

Concerning the change of year (2003-2004),

would it work completely if I queried a UNIX timestamp?

 

thx for the replys, really appreciate it!

[How to query birthdays ...]

but the year is 1982, 1983, ...

[How to query birthdays ...]

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!

[Select info from a table that's not inside another table....]

Thx for your reply, it works!

 

But what does the

WHERE t1.id IS NULL

part do?

[Select info from a table that's not inside another table....]

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

 

HELP!

[Select info from a table that's not inside another table....]

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 !

[Select info from a table that's not inside another table....]

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]

[Select info from a table that's not inside another table....]

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!