problem inserting data to mysql

[jpretti]

Unfortunatley I have been given the daunting task of taking over a website. I am having troubles getting some code to work for a home grown classifieds of sorts. I have posted the php code snip at http://www.stateamind.com/sample.txt

It appears that what is happening is that the code is being processed, because the pictures upload into the directory; however none of the values ever get entered into the database. Please note that this script did work before and now it does not.

I have checked to make sure this is not an access issue with the db, by manualing entering data into it from the command line. Here is how the database looks. http://www.stateamind.com/sql.txt

I am at a total loss, any help is much appreciated.

Thanks,
John

[chintupintu03]

Hello jpretti ,

I saw the code attached. Just try the some of the methods of checking the working of ur code.

For each value, u r concatenating the query. "echo " the query formed at each stage and at the end before it gets executed.

"copy and paste" the query displayed on the screen and execute it with replacing the parameter values in it without changing the code itself. Check whether the corresponding table gets affected or not. (affected --> update / insert / delete delete as per the query formed.)

Also check the datatypes of each fields with single quotes used for those variables in the query.