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!

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

Search results for query: *

  1. mm0ckr

    Multiple WHERE clause (complex query)

    Daniel, Thank You. Works perfectly. I am away to read more about this now, SQL really is powerful when you scratch below the surface :) Just one more question. Does anyone know of a really good tutorial about MySQL that goes into a bit more depth than ones on DevShed and sites like it...
  2. mm0ckr

    Multiple WHERE clause (complex query)

    Quite simply the date is stpored in 3 seperate fields to allow some features such as re-occuring messages. I think I'll have to put a seperate date field in the table and compare against this. A lot of the problem is that I am trying to alter someone else's code (Lucid Calendar - now...
  3. mm0ckr

    Multiple WHERE clause (complex query)

    Thanks for the reply, You are absolutely right about using AND's in the WHERE. I have partly solved the problem as it would appear that the syntax error was caused by the ordering of the conditions, i.e the WHERE clause must come before the ORDER BY and LIMIT. Now I have a new problem! This...
  4. mm0ckr

    Multiple WHERE clause (complex query)

    Hi Danial, Thanks for the reply. Unfortunately it is still not working with $query = "SELECT * FROM calendar_messages ORDER BY msg_year, msg_month, msg_day WHERE msg_year >= '$year',msg_month >= '$month', msg_day >= '$day' LIMIT 0,5"; Ther Error is 1064, Syntax error near...
  5. mm0ckr

    Multiple WHERE clause (complex query)

    Hi Folks, I am currently hacking Lucid Calendar and need to do a fairly complex query (complex for me anyway :) ). I am adding a function to show the next 5 events on my index page. I use the following sql with PHP $query = "SELECT * FROM calendar_messages ORDER BY msg_year...
  6. mm0ckr

    Pattern Matching NEwbie Questions

    Hi goBoating, Cheers for the reply and Yep can eay wait a day or more - can you let me know when you have it up and going. I feel I really need to learn this but my intelligence is limited!! Cheers again Mike
  7. mm0ckr

    Can I upload CGI scripts through Front Page 2000? It won't let me!

    I Agree with Tanderso! I have tried every possible way to get FP and CGI to coexist - they just will not. FP will not upload in ascii only binary which kills cgi script dead. Even if you get the script uploaded OK then you will not be able to set permissions (chmod). FTP kills FP servers so...
  8. mm0ckr

    Pattern Matching NEwbie Questions

    Hi there, I am trying to learn Perl at present but am coming very unstuck at pattern matching. I understand the principles but not the syntax or how t use the data matched. I am trying to read files [.txt & .html] (with permission, from remote server) for inclusion to my site (just the...

Part and Inventory Search

Back
Top