What's wrong with my code??

[KyleEW]

Below is a code for enting form information into the database....I can't figure out what's wrong. It won't enter any info into the database.

$db = mysql_connect("localhost", "kwilli_kwilliams", "******");

mysql_select_db("kwilli_veritas",$db);

$query="INSERT INTO TABLE 'users' ('login', 'password', 'name', 'phone', 'description', 'email', 'column', 'id') VALUES ('$login', '$password', '$name', '$phone', '$informaton', '$email', '$column', '$id')";

$result = mysql_query($query,$db);

[tomhath]

Let mysql tell you what's wrong:

http://www.phpbuilder.com/manual/function.mysql-error.php

[KyleEW]

it returns no errors

[tomhath]

After the call to mysql_query you echoed out what's returned from a call to mysql_error and there was nothing reported? That's very strange.

Try echoing out what is in your $query variable and running that exact string in a mysql command line (phpmyadmin or something like that).

Is the 'id' column a character field? It kind of looks like it might be an integer; if so the $id variable should not have quotes around it.

[[deleted]]

get rid of "TABLE" and the single quotes...

INSERT INTO users (login, password, name, phone, description, email, column, id) VALUES ('$login', '$password', '$name', '$phone', '$informaton', '$email', '$column', '$id')

[Bunkermaster]

use backward single quotes (`) around table and field names and regular single quotes (') for values