[SOLVED] php / form fields to insert into mysql database

[johnwayne77]

I am trying to make an 'add products control panel' for my shop to add new products via a script instead of PhpMyAdmin.

Here is where I gather the form fields info:

[code]$idprodus = stripslashes($_GET['idprodus']);
$idcategorie = stripslashes($_GET['idcategorie']);
$denumire = stripslashes($_GET['denumire']);
$um = stripslashes($_GET['um']);
$pret = stripslashes($_GET['pret']);
$stoc = stripslashes($_GET['stoc']);
$cat = stripslashes($_GET['cat']);[/code]

Now I connect to the database:

[code]include "config.php";
$conexiune=mysql_connect($server,$cont,$parola)or die("Eroare la conectarea la server.");
mysql_select_db($resursa, $conexiune)or die("Eroare la selectarea bazei de date <b>$resursa</b>.");[/code]

And now I'm trying to add the values into the mysql table:

[code]$table = 'produse';
mysql_query ('INSERT INTO' . $table . 'values ('',\'' . $idprodus . '\',\'' . $idcategorie . '\',\'' . $denumire . '\',\'' . $um . '\',\'' . $pret . '\',\'' . $stoc . '\',\'' . $cat . '\)') or die(mysql_error());[/code]

This is the error I get:
[b]
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\WebSites\anul_4_informatica_2006_2007\1081_borisov\catalog\script.php on line 20[/b]

Any ideas? Is the mysql_query () valid?

[fenway]

Use double-quotes for the query and single quotes on the inside... I can't possibly parse that myself.

[johnwayne77]

it works

thank you!