Re: SQL syntax error in PHP script. dunno what's wrong

mike cullerton schrieb am Freitag, 3. August 2001, 15:59:03: > on 8/3/01 2:49 AM, Werner Stuerenburg at ws@art-quarter.com wrote: >>>> insert into test values (0,''; DELETE FROM test; ',1); >>>> ERROR 1064: You have an error in your SQL syntax near '' at line 1 >> insert into test values (0,'\'; DELETE FROM test; ',1); > nope. this just adds a row to the table with > '; DELETE FROM test; > in the 2nd field I thought that's what you wanna do. It certainly is what you issue in sql. INSERT INTO table VALUES (...); So you wanna do first insert into test values (0,''); and then DELETE FROM test WHERE id = 1; or what? Leaves me puzzled as to what you want. -- Herzlich Werner Stuerenburg _________________________________________________ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de