PHP problem - database not updating?

[Seanie]

anyone got any idea, it'd suck if we had to go back to manually managing archives

[Lynne]

Have you tried running the page/form through an html validator? It could be that your server is more 'strict' than your other server and it doesn't like things like type="Submit" (the capitalized Submit isn't standard, it should be "submit"). That's just one small thing, but you may want to just run it through a validator and make sure it validates correctly.

[Seanie]

just tried it, changed a few bits as you suggested and still getting the problem.

Its getting a bit ridiculous now

[Lynne]

OK, you have this line:

$query1 = "INSERT INTO $release_sched_db(act, title, type, release_date, taken_from) VALUES('$act1', '$title', '$type', '$release_date', '$taken_from')";

You are only getting the title inserted. However, I can't find the other variables, $type, $release_date, etc, even defined. You have this:

            $content = $_POST['type'];

            $contact = $_POST['release_date'];

But that variables $contact and $content are not the ones you are using in your query. So, where are $type, $release_date, etc defined?

[Seanie]

i never even noticed those before.

But to answer your question they're defined in the form, when the user inputs into the form, hits submit it should carry it through to the database.


changing them doesn't make any difference:

INSERT INTO release_sched(act, title, type, release_date, taken_from) VALUES('', 'qq', '', '', '')

[Lynne]

They may be defined in the form, but when they get passed, they don't automatically become $type or $release_date. They get passed as $_POST['type'] and $_POST['release_date']. Those aren't the variables you are using though.

[Seanie]

They may be defined in the form, but when they get passed, they don't automatically become $type or $release_date. They get passed as $_POST['type'] and $_POST['release_date']. Those aren't the variables you are using though.

they are now though?

I dont understand how it could work before, its not isolated to this script, every other database adding script I have on the site isn't working in the same way. (apart from vBulletin)

[Lynne]

To be honest, I don't know how they were working before when I look at your script. Perhaps it is some server setting that automatically makes $_POST['variable'] into $variable? I remember once when I changed servers, I had to change all my $_POST to $_REQUEST in some custom scripts I had. I don't know enough about server settings to suggest what to look for. You may want to post in the Server Configuration forum and maybe someone in there would know if there is some server setting that you may toggle/set that helps to pass your variables differently? George, or someone else in that forum, may know exactly what to do.

Sorry I can't be of more help, Seanie.