Inserting data into a mysql database

gerrymac

I am currently trying to insert data into a table using a script. It seems to work correctly and i get a message saying 1 entry successfully entered into the table etc. However if I go to mysql prompt and type
"select * from personal"(table name = personal)
then it says "1 row in set", but i am unable to see the name that i have entered.(i.e the table heading are present but there is just a blank space where the data i have just enetered should be)

Im pretty sure that the information is stored there because if I try and delete the name that I have just entered, with the command

Delete from personal where firstname = "gerry", the update is performed and it says one row updated.

Has anyone ever encountered this problem before? and if so could you please advise

Thanks
Gerry

concept0020

In your script which inserts the data into the database try adding a line like this;

if (mysql_affected_rows() == 1) {$success_msg = '<p>Information has been added</p>'; }else{ error_log(mysql_error()); $success_msg = '<p>information not added</p>';}

this will tell you if the line has been added. If you have that, create a test script the prints out everything in the table out to the screen to see what if anything is in there.

hope that helps some...

DE2

gerrymac

hi concept0020

thanks for your help, turns out i wasnt entering any data into the database just blank data. no matter what i enter into my textboxes the code just seems to recognise this as two blank fields. wouls you have any idea why this is happening.

Thx
Gerry

cgraz

Try echoing out the variables before INSERTing. My first guess would be that you have globals set to off, but you're coding as if you have it set to on.

that means if your form method equals post, instead of calling a variable using $var_name, you need to call it using $_POST["var_name"]

Cgraz