I have found it is considerably quicker to do the query without the rand, then get the record count in php and pick a random record. Don't know if that helps anybody infuture.

I actually only get 2 fields, but I'd paraphrased my query to shorten it.

I've got quite a slow query, that I need to get a random record from, however this is proving painfully slow, can anyobdy suggest ways to speed up the following query.

SELECT * FROM people WHERE...

I have an rss feed on one of my servers, that changes constantly, however I think that it is been caches somewhere down stream, is their any way I can stop it from been cached?

I have 2 tables with the basic structure

town, latitude, longitude
postcode, latitude, longitude

where latitude and longitude are both floats, and the town and postcode are just descriptive...

I've got 3 date fields on a form, each is set using the standard datetimepicker.js, however I have set the resulting text field to readonly to prevent users entering silly date formats into the...

I'm trying to access a USB serial port, using a CLI PHP script in an XP machine.

I thought I'd got it sussed using fopen, however I have since discovered that the script on works if I have...

I'm experimenting with ruby and watir for parsing data from the web.

I'm having no problem getting info from standard fields, however I've come across a listbox on one of the pages I'm looking at,...

But you gave me a good idea, if when I've done the javascript lookup etc. rather than jump to the refering page using window.location, I can use history.go that way if the user clicks back on the...

I already have a link back to the query form but people tend to use back on thoolbar, don't suppose you can blame them it's probably just habit.

Looking at our logs, I notice that quite a few users, look at the page then go back, probably to change some details or similar, however back doesn't work because of the intermediary page. Any ideas...

Anybody any ideas?

Is there any easy way of mirroring a mysql database, without having access to the config files??

Reason I ask is that I have 3 servers all running of the same mysql databases. 95% of the access to...

I knew that honest :$

I'd spent best part of day starring at that, and rejigging it, never spotted my mistake, even though once it's pointed out, I know it's wrong.

Once again thanks r0bb0b

I'm trying to detect googlebot, or more to the point have some code not run when googlebot is viewing the page

This is what I am using

if (strpos(strtolower($_SERVER[‘HTTP_USER_AGENT’]),...

Thanks

Think I've got that to work now. It's not pretty yet, but see what you think.

www.route-information.co.uk

I suppose I could have a "Processing" page that does the javascript and bounces back, suppose that could work.

The javascript gets details from googlemaps, then submits the to a php script whic formats them, and stores them in a mysql database as a cache.

The lookup needs to be triggered by data entered...

I have a javascript that looks up some details on googlemaps for me, then returns them to a php script that does the web bit I actually need doing. I actually works by filling in a form and...