INSERT doesn´t works... 1

[Gast]

Hi all,
i have a, maybe very simple , problem with my database(MySQL+PHP4). if want to use variables in this code it doesen´t works. Would be very happy if you could help:


$verbindung= mysql_connect("localhost","root","root"

if (!$verbindung) { echo "error"; }
else { echo "ok"; }

$name= "Test";
$preis= "12.00";
$Beschreibung= "bla";
$tabel= "angebote";

$query = 'INSERT $tabel (name,preis,beschreibung) VALUES ($name,$preis,$beschreibung)';

$erg = mysql_db_query(shop,$query,$verbindung);

mysql_close($verbindung);

 

[DjangMan]

You might need quote characters (') around your variables in your VALUES clause:

$query = 'INSERT $tabel(name,preis,beschreibung) VALUES ('$name','$preis','$breschreibung')';

DjangMan

 

[riffy]

are you entering the name, preis variables into a table? if so then it should be insert into $tabel..
also i don't think u need the quotes around the INSERT statement..

hope that helped..
arif X-) s-)

 

[Gast]

hmm thx,
but it still doesn´t work.. it seems that the variables are the problem, cause if i put normal text there instead it works..

 

[DjangMan]

Try this:

$query = "INSERT INTO '$tabel'(name,preis,beschreibung) VALUES ('$name','$preis','$breschreibung')";

I've added the " character around the whole string and ' characters around your table name.

DjangMan