Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Old 11-23-2005, 12:00 PM sql query query
purk's Avatar
Extreme Talker

Posts: 164
Name: James
Location: marbella & surrey
Trades: 0
i'm new to sql so don't laugh if this sounds dumb.

i have a table with an ID and a date column. i want to return the ID for each record which does not match an element in my php array (of dates).

thanks folks


;p
purk is offline
Reply With Quote
View Public Profile Visit purk's homepage!
 
 
Register now for full access!
Old 12-09-2005, 03:06 AM
Experienced Talker

Posts: 46
Trades: 0
select id from DATABASE where date_column NOT IN (date1, date2, ...)

I am not 100% sure, but I believe this should work.
__________________
Rex Trevor
Please login or register to view this content. Registration is FREE
[IM me]
»» 9,000 Entry Full-Text Books for Sale
»» 21,800+ Entry Famous Quotes Database For Sale»»
parahost is offline
Reply With Quote
View Public Profile
 
Old 12-09-2005, 10:22 AM
purk's Avatar
Extreme Talker

Posts: 164
Name: James
Location: marbella & surrey
Trades: 0
awesome, will check it out now.

thanks
purk is offline
Reply With Quote
View Public Profile Visit purk's homepage!
 
Reply     « Reply to sql query query
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.11283 seconds with 12 queries