A total mystery

10sJunkie

Any idea why a form and query that were working fine on one server/hosting account would not run on a different server/hosting account? The new server runs the same OS, same php and mySql versions ... I have the same rights and privileges ...

I'm going crazy!

anakadote

Any error messages to share?

bradgrafelman

10sJunkie wrote:
Any idea why a form and query that were working fine on one server/hosting account would not run on a different server/hosting account?

Yes - many, many ideas.

Without showing some examples of code that doesn't work as well as some relevant error messages (both from PHP and from MySQL), however, there's no way we can tell you exactly what the problem is.

10sJunkie

There are no error messages.... In messing with it, I have created and resolved errors - so I know it is connecting to the database - and I know the database is intact but no results from the query are printed and I am not even getting the "No records found" response which works perfectly on the original set up.

halojoy

As told 🙂
give us the code where you suspect the issue will be caused.
You are not an absolute beginner, so you might have some idea.

You know, almost none web server is 100% same in settings to the other.
Also, no PHP 4 or 5 version has yet been the same as any other.
Things change.
And move your webstuff, scripts to another Server
is a BIG, BIG change. If we compare to other small things.

bradgrafelman said it short

Any idea why ... on a different server/hosting account?
Yes - many, many ideas.

I will make the short story, longer:
- Not only MySQL can or will be another relase version.
- Apache Modules, extensions can and do differ.
- PHP Modules, extensions can and do differe.
- How the server+php was compiled do very often differ.
- Apache settings httpd.conf differs a lot between servers
- PHP settings php.ini certainly differs from host to host
- MySQL settings my.ini or my.cnf differs
.... Iam sure I could go on for some hour
but I have other things to do, too

See you 🙂

Myth_UK_

Halojoy is correct, but most ISP's that provide these services normally have examples on how to use them on their servers.

If the PHP version on the server is suitable for your code, I would first look at the php extensions, (enabled, disabled, what version?).
And the MySql version. But, I don't think we can help you unless it's a problem with code.

Pikachu2000

You aren't using the short php open '<?' instead of the full '<?php' tag by chance, are you?