Hi all,

I am new to php and so far have done well with online tutorials and books etc. I have successfully installed php and mysql locally and have successfully created a database and table with values that I input through the mysql admin interface.

I went to this site and went through the tutorial
http://www.freewebmasterhelp.com/tutorials/phpmysql/1


I was able to grab the data from the table i created using the code that was presented in part 4 of the tutorial presented by david. I tried the inserting section in part 3 but when i run the page i only get a blank page and when i check the database through its admin tool there are no new values.

I am hoping someone out there can help me in the right direction as to why this is happenning. I am using the same login details in both retrieving and entering and have followed the tutorial to a tea. Once I understand what the problem is and can enter data then the sky is the limit.

If anyone can offer some advice as to why the data is not being inserted but can be retrieved then i would be most grateful.

I look forward to any replies in regards to what i am doing wrong.

Thanx

phpMan,

Try posting your code and results here in the forum. Enclose the code within [php ] and [/php ] tags (minus the spaces).

I will assume that you have verified that you are inputting a valid INSERT statement.

One thing that you can try is to write some debug into your PHP that will print out your INSERT statement. Cut and paste it and run it in your SQL admin tool (whatever program you are using). These programs sometimes give much better error messages than a script (which may have errors suppressed).