How to link to a MySQL database from Actinic V8

[hadlow]

Hi from a newbie!
I'm designing a store for a company with branches nationwide who want to integrate a store locator on to their home page so that a visitor keys in their postcode and it displays their nearest store. They have bought a piece of software written by a third party which holds the store information in a MySQL database and accesses it via a PHP function. There's also some Javascript involved but as I haven't seen the code yet, I can't give any more detail. Sorry!

The question is, could anyone recommend a hosting solution for this configuration as Actinic hosting, our preferred option, does not support mySQL.

Thanks.

[Darren B]

you might want to take a look at gabes solution, he has been working on bits like this

try a search for actinet this should bring up information on it

D

[Mike Hughes]

1and1 are usually pretty good and include MySQL.

You need to go for the Business package or higher for the cgi-bin functionality.

The only thing to watch out for is that the servers are based in germany so unless you have .co.uk domain the search engines might get confused about geolocation.

Mike

[hadlow]

OK thanks guys. We've got a .co.uk domain so the server location shouldn't be a problem.

Not sure at first sight how the Actinet solution directly helps with the MySQL issue but I guess I need to look into it a bit more.

What about if I converted the MySQL database into a MS Access database? Is that a possibility and, if so, what would I have to do to get the data out of it?

Thanks,

Derek

[Mike Hughes]

Hi Derek,

Why would you want to change to ms access?

The store finder feature needs to run on the server so people can enter their postcode. This what the PHP code will be doing.

If the php code and results page are self contained then you could just link to them in a pop-up from your actinic pages.

Mike

[hadlow]

Hi Mike,

Don't know where the Access idea came from, a mental aberration probably. Still haven't seen the PHP code but I presume it does what you suggest.

Thanks,

Derek

[Darren B]

OK thanks guys. We've got a .co.uk domain so the server location shouldn't be a problem.

Not sure at first sight how the Actinet solution directly helps with the MySQL issue but I guess I need to look into it a bit more.

What about if I converted the MySQL database into a MS Access database? Is that a possibility and, if so, what would I have to do to get the data out of it?

Thanks,

Derek

sorry gabe has also created a php script that will create all the tables from actinic on to your own mysql db, this is being worked on and i also belive teclan are workign with this too

the actinet was more of a pointer to Gabe

D