wml with mysql insert statements

[Anon]

I`ve been able to retrieve data from a mysql database and display it on a WAP browser, using PHP, however I can not (haveing tried just about everything) get inputs from wml to insert into the database, using the mysql_query(insert into......... statement.
It connects to the database and creates a record but instead of inserting the values in the inputed variables, it just leaves blank fields. has anyone come across a similar problem or know a solution??

Any help is greatly appreciated 🙂

Bren

[Anon]

There must be problem with ur sql query.
try this
Insert in $table_name (field1,field2) Values (\"$value1\",\$value2\");

I hade the same problem, it got solved after i entered the values in this format.

If this does not solve ur problem then check your mysql table and see what have u entered in the type of values (varchar/char/int)