"Jeffrey N Dyke" <jeffrey_n_Dyke@xxxxxxxxx> wrote in message news:OFC83F9145.CF6BE5D5-ON85256E7E.0041F0E4@xxxxxxxxxxxx > >$result=mysql_db_query("usr_172_1","UPDATE artikel SET Preis='\$preis\' > WHERE ID='\$id\'"); > >//mysql_error($result); > > Here you're escaping the $ and then the ', have you tried.... > > $result=mysql_db_query("usr_172_1","UPDATE artikel SET Preis='{$preis}' > WHERE ID='{$id}'"); > with those escapes this is the actual query you're sending.... > "UPDATE artikel SET Preis='$preis\' WHERE ID='$id\'" Good point, Jeff. As the id is probably an int one doesn't need quotes at all: "UPDATE artikel SET Preis='" . $preis . "' WHERE ID=" . $id Regards, Torsten > > HTH > Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
