Help me before i go crazy!

Ok, here's the situation.

I use Frontpage XP, i have bought the rocket add on so i can use php with it. If the code is html/php only it works fine.

Unfortunately the sites i want to work on are not html/php only. They include mysql. When i execute the files i do not get any errors, it just seems to ignore all references to mysql. Which means no data.

FACTS
1. PHP is working on my machine, or how would i be able to edit and execute php code in frontpage?
2. MySQL is set up, i can use the control panel to access and modify the domain database in question from my desktop.
3. Hosting account is set to accept ANY remote requests for access. (which is working, or how could i edit from the desktop?)

Why wont Frontpage read the mysql? Or if it's reading it, why won't it run the query?

Help would be much appreciated here. I could do the job with notpad, that's what i've done until now. But i have reasons for not wanting too, and i'd like to get this sorted asap.

MySql at your server will have separate security permissions - you wouldn't want any remote pc being able to modify your databases.

You could either upload the file with an alternative name to test, or look at modifying you MySql config - it may be best to ask your host about that.

I just reread your post, is the 'control panel' your using a locally run tool or is it a web admin page like myPhpAdmin?

I have full control of the remote hosting security settings. It is ok to use a wild card for now, i'll secure it later. I want to see it work first. I know server side it is all OK because if i use MYSQL control panel (desktop software) it connects instantly and allows me to do what i want. So MySQL is doing what i want both ends. Just not from inside frontpage.

I have to have the php.ini changed server side later, but that's another story entirely.

If i didn't already answer (i posted before seeing your post) it's local.

Are you getting a php error at the mysql commands? if so what is it. If there is no error then it may just me a mistake in the php code.

If you make a page that is just: -

 <?php
$link = mysql_connect("hostname", "mysql_user", "mysql_password" ) or die(mysql_error());
mysql_select_db ("databasename",$link) or die(mysql_error());
?>

you should get an error if there are any communication problems.

The page is an existing page that has been online for 14 months, and it works fine when uploaded. I want to get it to work locally though, which is the only reason i bought Rocket.

I've been going round in circles. Individually everything works fine, but put them together.....

Why, oh why, oh why, did i buy Microsoft?

OK, I've read the rocket guide now

I'm guessing it might be that your local copy of php hasn't got mysql support enabled.

Make a page that is just: -

 <?php
phpinfo();
?>

If you preview that file you should get something like www.showyoulovethem.co.uk/info.php. Check thru you file and see if there is a Mysql section - if there isn't then the copy of php you have installed doesn't have mysql support. If the section is there then I'm stumped (sorry).

Thanks for that, i'm gonna finish me smoke and coffee and then try that. I'll kick myself if it's the case. I'll post either way.

Thanks again.

Sod me coffee :O)

The section is there. This is what it said:

<blockquote><strong><em>Quote:</em></strong><hr>Active Persistent Links
0

Active Links
0

Client API version
3.23.39

MYSQL_MODULE_TYPE
builtin

MYSQL_SOCKET
/var/lib/mysql/mysql.sock

MYSQL_INCLUDE


MYSQL_LIBS



mysql.allow_persistent
On On

mysql.default_host
no value no value

mysql.default_password
no value no value

mysql.default_port
no value no value

mysql.default_socket
no value no value

mysql.default_user
no value no value

mysql.max_links
Unlimited Unlimited

mysql.max_persistent
Unlimited Unlimited[/quote]


So i assume that's not the problem?

I'm clueless! I can't think of a reason why the php engine would just ignore those lines, it should either run them or generate an error. It might mask it if html_errors was set to off, but it's usually set to on (core section of phpinfo).

Do you get the expected results if you run the selects that the file is running via the control panel? It sounds like it is getting zero records returned rather than any other error.

Sorry, I'm clutching at straws now, hopefully Aquanuke (or someone) will pop by soon an put us both out of our missery.

Client API version
3.23.39

Has a security issue regarding remote hi-jacking of databasses. You really need that upgraded to mysql 3.23.54
which fixes that issue.

Maybe this is why its also not working.

Actually a few months back I was doing some remote connections accross two boxes and it was giving me loads of grief... I believe at the time I was running

v. 3.23.49

and as I last ditch effort I upgraded it to i fink

v. 3.23.53

and it worked a treat, so condidering how old your current ver. is I would fink thats the likely cause of the problem.