SQL - Insert values

[Sketch]

Ok. Here is my script

$dbuser="<USERNAME>";
$dbpass="<PASSWORD>";
$dbname="phone"; //the name of the database
$chandle = mysql_connect("localhost", $dbuser, $dbpass)

or die("Connection Failure to Database");

mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found. " . $dbuser);

$query="INSERT INTO FILE (A_ID, A_PHONE, A_PRICE, A_CAT, A_IMAGE, A_NAME, A_INFO) VALUES ('A0004','Nokia','38','Accessories','image/item/A0003.gif','Nokia Phone','Information')";

mysql_db_query($dbname, $query) or die("Failed Query of " . $query);



FILE is the table that I am trying to put the data into.

Within FILE there are "A_ID, A_PHONE, A_PRICE, A_CAT, A_IMAGE, A_NAME, A_INFO" Columns, no more no less. But still every time I run this page I get the error.

What have done wrong??


Thanks in advance

[littleFella]

did you make sure that:

are data types ok?
does the user have privileges to insert records?
is the table locked by another process?

btw. what does the error say?

[Sketch]

The 'die("Failed Query of " . $query);' thing that trows up the error just says Failed Query of (CODE)

And yer. The data types are Ok. there shouldn't be a problem with that. And the user does have access...

But when you say the table is locked by antoher process? What does that mean? Why would it be locked?

[littleFella]

depending on the version of MySQL there may be a table level lock in effect. In short, a table may be locked if there is already an insert/update/delete/select running against that table. The lock is usually in effect untill a transaction is completed, or the UNLOCK command is issued. If you designed the table and have full control over it then I assume you do not have any locks on the table. Otherwise you would not be asking about what locking is. I also assume that MySQL does't use automatic locking.

In addition to the above, I have no clue what your problem may be

How about trying this:

"INSERT INTO FILE VALUES ('A0004','Nokia','38','Accessories','image/item/A0003.gif','Nokia Phone','Information')";

Notice no field names.
This should work if the number of values is exactly the same as the number of fields in the table, and if the datatypes of fields coincide with respective fieldds data types

Also, debugging the SQL on the command line level, as opposed to wrapping SQL in PHP, may help you better diagnose the reason of the failure.

[Sketch]

Found the problem. I put into the code mysql_error() so it would tell me my problem. I had problem with my Primary Key, I kinda was trying to make 2 things under the same Key :s

So sorry, that was stupid.

:s