inserting product into table selected by user

[xchrisx]

I'm designing a simple product catelog script, well i thought i would be until i ran into this problem. I am trying it to add a product into a category (read from a table) in a selection box. However when i do so it's not able to link to the table.

code snippet:
$ Category = the selection made without white space. Works fine, when display is the proper category listed in database. It is used when Category is added to database.

$query = "INSERT INTO $Category ( pname, cat, price, description, image ) values( '$txtPName', '$Category', '$txtPPrice', '$taDesc', '$slImage' )";

I know it probably doesn't make any sense but some help would be appreciated .

[bastien]

can't really use tablename fieldname as the same word...bad form

when running the query try this:

$query= "INSERT INTO $Category ( pname, cat, price, description, image ) values( '$txtPName', '$Category', '$txtPPrice', '$taDesc', '$slImage' )"; 

echo $query;  //check for well formedness

//run the query..if it fails it will give a meaningful error
$result=mysql_query($query) or die ("can't proceed because ".mysql_error());

hth