Search results for 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...

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...

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...

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...

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...

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

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...

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...