Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by McNugget

  1. McNugget

    A joined delete?

    Yeah.. that's the thing I've thought of .. but it'd be a lot easier to do this with one single command. Damnit. ^_^ Thanks though.
  2. McNugget

    A joined delete?

    How could I delete rows from say.. 3 tables that are linked.. I can join them in a SELECT with no problem, but I have no idea how i'd delete em.. tables: thread - threadID topic - topicthreadID reply - replythreadID that's how i wanted them linked, thanks if you can help! :D
  3. McNugget

    A complicated select (for me at least)

    The only real problem *I* have is that the DATE field is both date/time.. and I don't know how to make it only count the date part, otherwise I suppose I'd be perfectly fine.
  4. McNugget

    A complicated select (for me at least)

    okay.. here's the *HUGE PLAN*.. table news.. is "ta2knews" the important field for finding the last 5 used dates is "date" and that's what i want it to be JOINED ON.. and for the outputted news data.. "body" basically.. so like.. i want this: - Day 1 -- News Item...
  5. McNugget

    A complicated select (for me at least)

    This *may not* be the same type of question.. but I want to select all the news from the last *5 days posted in* (so.. maybe one's 3 days ago and the next is 5 days ago.. and so on) and INNER JOIN THEM so that news items in similar days are listed under one heading.. the only idea that came to...
See more

Part and Inventory Search

Back
Top