Search found 9 matches

by allyhazell
Fri Jan 13, 2006 4:36 pm
Forum: PHP - Code
Topic: The Best Way To Count Visitors/Impressions
Replies: 4
Views: 509

Thanks

Thanks for your help and tips folks, really helpful! :-)

Especially liked that article, made me feel a bit better about my struggle for stats.
by allyhazell
Fri Jan 13, 2006 1:52 pm
Forum: PHP - Code
Topic: The Best Way To Count Visitors/Impressions
Replies: 4
Views: 509

The Best Way To Count Visitors/Impressions

Hi, I'm having a few issues with keeping track of visitors and page impressions on my website. No matter how much I search, I can't find the answer to my question. Essentially I have two PHP counter scripts, one for visitors and one for impressions. These interact with our Mysql database. So no prob...
by allyhazell
Thu Sep 23, 2004 1:09 pm
Forum: PHP - Code
Topic: Splitting up search keywords for search engine
Replies: 2
Views: 313

Ok thanks, that's great. I will have a look and see how I get on with it.
by allyhazell
Thu Sep 23, 2004 8:27 am
Forum: PHP - Code
Topic: Splitting up search keywords for search engine
Replies: 2
Views: 313

Splitting up search keywords for search engine

Hi, I am trying to build an abbreviations search system. I have the Mysql database set up. People type in keywords and it searches the database for them. At the moment people are using a mixture of boolean commands and commas to separate their search terms. What I would like to know is which PHP com...
by allyhazell
Thu Sep 23, 2004 8:11 am
Forum: Databases
Topic: Case insensitive Mysql query grouped by case sensitive
Replies: 6
Views: 960

Ok, so if I go in and change it to a binary varchar in the table, will that work ok or will that muck up the data that is already in there?

Sorry if I sound thick.

Alastair
by allyhazell
Thu Sep 23, 2004 6:00 am
Forum: Databases
Topic: Case insensitive Mysql query grouped by case sensitive
Replies: 6
Views: 960

I can see that would work, but..

Thanks for that piece of code. Just one more question, currently the abbreviations are stored in the database as varchars. Am I right in thinking that I would need to change them from varchars for the mysql query to work? Varchar's are case insensitive when searched for aren't they?

Thanks

Alastair
by allyhazell
Wed Sep 22, 2004 8:28 pm
Forum: Databases
Topic: Case insensitive Mysql query grouped by case sensitive
Replies: 6
Views: 960

Case insensitive Mysql query grouped by case sensitive

Hi everyone, I have built a basic search engine for a client of mine, the system works but I don't think it is particularly efficient. The background is that it is a Mysql database of abbreviations. There are thousands of different entries, with abbreviations being in different 'cases'. So there may...
by allyhazell
Tue Sep 14, 2004 2:38 pm
Forum: PHP - Code
Topic: Probs with character encodings when creating XML feed
Replies: 2
Views: 238

That's great, thanks. I shall give it a try. Bloody Word eh!
by allyhazell
Mon Sep 13, 2004 12:53 pm
Forum: PHP - Code
Topic: Probs with character encodings when creating XML feed
Replies: 2
Views: 238

Probs with character encodings when creating XML feed

Hi, I've been struggling to find an answer to my problem, I've tried scouring both the official PHP site and other sites for answers to it. I have created an RSS/XML feed for a client's web site which is automatically generated from the news in a Mysql database each time a new article is added. The ...