NYCPHP Meetup

[Chris Shiflett]

--- Phil Powell <soazine at erols.com> wrote:
> This is the mySQL insert statement

And you got this by echoing your $sql variable or something from your script,
right? If not, that is something to try, just to make sure the query is exactly
what you think it is.

You can also not execute the query through PHP and just echo it instead. From
the MySQL interactive prompt, try to see if you can reproduce the problem by
entering the query yourself (copy/paste):

mysql> select foo from bar;
+-----+
| foo |
+-----+
|blah |
+-----+
1 row in set (0.00 sec)

mysql> insert into bar...
Query OK, 1 row affected (0.00 sec)

mysql> select foo from bar;
+-----+
| foo |
+-----+
|blah |
+-----+
1 row in set (0.00 sec)

> And here is the SQL that created the table in the first place

Can you show us the output of "desc nnet_usermetadata" as well? I think that
would be helpful.

I can't explain the behavior you described (yet).

Chris

=====
Become a better Web developer with the HTTP Developer's Handbook
http://httphandbook.org/