[RESOLVED] values not inputting into database!! HELP

pnarendran

Hi guys,
Here is a code that was working fine, all the

data was getting inputted into the mysql table

inside the database. However now on submit it

does't populate the table.

The query output shows all the entries in the form

correctly also.......In fact even if I replace the

table name with something that doesn't exist in

the db still the query shows that it has been

inputted! The only time it will throw me out and

give an error is if I have the wrong db name or

password........very weird can you please help me

Thanks so much!!

bradgrafelman

You never check if the query ran successfully. You should always be checking the return value of [man]mysql_query/man to see if it is boolean false (indicating an error has occurred) and, if so, outputting or logging useful debug information (e.g. the query itself, the MySQL error message, etc.).

pnarendran

bradgrafelman;10987951 wrote:
You never check if the query ran successfully. You should always be checking the return value of [man]mysql_query/man to see if it is boolean false (indicating an error has occurred) and, if so, outputting or logging useful debug information (e.g. the query itself, the MySQL error message, etc.).

but isn't that what I'm doing when I do:


mysql_query($query);

echo $query;

the echo actually says insert into tablename values and all the values I entered in the form are showing up - doesn't that mean values have been inserted into table?

but the actual table is empty. Is there any special way the database or table itself needs to be setup?

bradgrafelman

pnarendran;10987954 wrote:
but isn't that what I'm doing when I do:
mysql_query($query);

echo $query;

Uh... no. You're just echo'ing a string you defined earlier. That's no different than doing:

$foo = 'Hello world!';
echo $foo;

. You never check the returned value from the [man]mysql_query/man function. Since you don't even store that value in a variable, you're just throwing it away.

pnarendran;10987954 wrote:
the echo actually says insert into tablename values and all the values I entered in the form are showing up - doesn't that mean values have been inserted into table?

No, that means PHP managed to echo out the same string you defined earlier... which doesn't tell you anything.

Read the PHP manual for [man]mysql_query/man (especially the coding examples) and/or find some very, very basic tutorials.

pnarendran

bradgrafelman;10987955 wrote:
Uh... no. You're just echo'ing a string you defined earlier. That's no different than doing:
$foo = 'Hello world!';
echo $foo;
. You never check the returned value from the [man]mysql_query/man function. Since you don't even store that value in a variable, you're just throwing it away.

No, that means PHP managed to echo out the same string you defined earlier... which doesn't tell you anything.

Read the PHP manual for [man]mysql_query/man (especially the coding examples) and/or find some very, very basic tutorials.

Yes. I will read the manual. But what still gets me is the fact that just two days back I was able to run the same code and when I saw in the table values were physically inserted, but now hwne I do the same operation the values are not getting inserted.
Is there a possible reason?