[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?

[Jessica]

What is line 20? The mysql query?
You don't have spaces between your INTO, table name and values. You have spaces AFTER the closing of the string, not in the string.

try mysql_query ("INSERT INTO $table values (etc)"
OR
mysql_query ('INSERT INTO '.$table.' values (etc)'

[johnwayne77]

this code works:

[code]mysql_query ("INSERT INTO $table values ('',' $idprodus ',' $idcategorie ',' $denumire ',' $um ',' $pret ',' $stoc',' $cat ','')")[/code]

thanks