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 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 dunce
-
correct mySQL syntax?
Thanks for that guys....a bit of a shock as i posted this over two months ago...but thanks anyway. I actually managed it in the end by using the method suggested by eddiebt {BETWEEN}. The reason I used the # sign was that I was familiar with access at the time...whilst mySQL dosen't use this... -
correct mySQL syntax?
Can anyone PLEASE help with the correct syntax for this sql statement? It works fine in Access and gives the desired results but i cannot make it work with mySQL. The table is fine, i have checked field names etc...but it will not run SELECT Count(PageUrl)AS PageCount, PageUrl as URL FROM...
