DW8.02 - PHP & MySql connection problems

Report · Apr 16, 2007

Am absolutely new to PHP and MySql having been using ASP & MSSql for a
long while.

I have the latest versions of PHP and MySql installed which would both
appear to be working correctly.

When I go to create a recordset in the usual manner - if I press test I
can see the correct data, when I click OK to finish I get a series of
JavaScipt errors "while executing findSeverBehaviours in recordset.htm"
(line 53??) etc etc cannot find TomLR-PHP-AdvRS.htm

DW puts the code in the page, but the Bindings window remains empty.

I've cleared the winfilecache - anyone got any other suggestions??

TIA!!

--
Buzby
There's nothing more dangerous than a resourceful idiot

Report · Apr 16, 2007

Buzby

I too am trying to convert some apps to mysql

CAn you please post how you got this to work with DW8

I am getting an error trying to setup the RS
when i try to 'select database"
i get this:
Your PHP server doesn't have the MySQL module loaded or you can't use the mysql_(p)connect functions.

I am running php/mysql on my xp pro workstation....with dw8 on it

??? loss......

Report · Apr 16, 2007

twindude wrote:

> Buzby
>
> I too am trying to convert some apps to mysql
>
> CAn you please post how you got this to work with DW8
>
> I am getting an error trying to setup the RS
> when i try to 'select database"
> i get this:
> Your PHP server doesn't have the MySQL module loaded or you can't
> use the mysql_(p)connect functions.
>
> I am running php/mysql on my xp pro workstation....with dw8 on it
>
> ??? loss......

Sounds like you haven't installed the mysql module.

I'm sure someone who knows much much more about it than me will be
along in a moment.

However - possibly the easiest way to do it without getting your hands
dirty is to delete and then reinstall PHP - make sure you do the
detailed route and look out for the modules section and check all the
MySql ones (sorry can't remember exactly what they were called - I've
only done this twice - the first one I bodged up!) - otherwise it's
trawl through your php.ini file and uncomment all the mysql components
that you think you may need!

HTH

--
Buzby
There's nothing more dangerous than a resourceful idiot