Basic sql query works in phpMyAdmin but not PHP

[genius]

I've searched everywhere for an answer but am at a loss:

 

Here's my query:

 

$query = "INSERT INTO  `" . $database" . "`.`" . $table . "` (

`key_id`

) VALUES (

 

'" . $_SESSION["key_id"] . "'

)";

 

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

 

From PHP I get:

 

"Failed Query of INSERT INTO... etc"

 

in phpMyAdmin, works fine.

 

What am I missing?

[trq]

What is the output of mysql_error ?

[genius]

Simply:

 

"Failed Query of..." and then lists the query as above.

 

If there was some phpMyAdmin error I'd list that but it works fine in phpMyAdmin.

 

to be exact:

 

Failed Query of INSERT INTO  `gallery`.`images` (

  `key_id`

  ) VALUES (

 

  '342'

  )";

 

[trq]

Again, what is the out of mysql_error?

[kickstart]

Hi

 

Seems strange that the error message showing the query includes the closing quote and semi colon.

 

All the best

 

Keith

[aschk]

This is an antequated function now.

You should be using mysql_query() instead.

 

Nevertheless try this instead:

 

<?php

$query = "INSERT INTO {$database}.{$table}(`key_id`) VALUES ('%s')";
mysql_db_query($database, sprintf($query,mysql_real_escape_string($_SESSION["key_id"]))) or die("Failed Query of " .$query);

?>