RE: [PHP] Troubles Inserting into MYSQL

This syntax fixes the syntax error.. if ($update_type == update_Williams) { mysql_query("INSERT INTO events_Williams ('user', 'detaildesc', 'index', 'reference', 'date_added') VALUES \'$cookiewho\', \'$add_Williams\',\'\',\'$row_num\',\'$last_update\'", $sql4) or print mysql_error(); } this is the output You have an error in your SQL syntax near ''user', 'detaildesc', 'index', 'reference', 'date_added') VALUES \'sgaas-wil\', ' at line 1 Steve Gaas Sr. Systems Engineer, Carrier Markets Riverstone Networks 972.668.8329 (follow-me) 877.713.7063 (pager analog dial) steve.gaas@skytel.com (interactive pager) http://www.rstn.net / Nasdaq: RSTN "Wisdom begins in wonder." -Socrates -----Original Message----- From: Steve Gaas Sent: Sunday, September 08, 2002 2:26 PM To: 'Paul Nicholson'; Steve Gaas; php-general@lists.php.net Subject: RE: [PHP] Troubles Inserting into MYSQL Parse error: parse error, unexpected T_ECHO in /var/www/html/actionreg/doupdate.php on line 24 Forgot I had that function.. I don't understand the error though.. Steve Gaas Sr. Systems Engineer, Carrier Markets Riverstone Networks 972.668.8329 (follow-me) 877.713.7063 (pager analog dial) steve.gaas@skytel.com (interactive pager) http://www.rstn.net / Nasdaq: RSTN "Wisdom begins in wonder." -Socrates -----Original Message----- From: Paul Nicholson [mailto:paul@dtnicholson.com] Sent: Sunday, September 08, 2002 2:21 PM To: Steve Gaas; php-general@lists.php.net Subject: Re: [PHP] Troubles Inserting into MYSQL -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hey, Send the results of mysql_errno() please. :) ~Pauly if ($update_type == update_Williams) { mysql_query("INSERT INTO events ('user', 'detaildesc', 'index', 'reference', 'date_added') VALUES (\'$cookiewho\', \'$add_Williams\',\'\',\'$row_num\',\'$last_update\')", $sql4) or echo mysql_errno()/*die ("could not do update")*/; } On Sunday 08 September 2002 03:07 pm, you wrote: > Hello, > > My code below always dies! I've tried just about every iteration of the > values, etc.. Can anybody show me how to insert into MySQL a value? > > "INSERT INTO events ('user','detaildesc') VALUES > ('$user','$details')" > > I just don't get it! > > > if ($update_type == update_Williams) { > mysql_query("INSERT INTO events ('user', 'detaildesc', > 'index', > 'reference', 'date_added') VALUES (\'$cookiewho\', > > \'$add_Williams\',\'\',\'$row_num\',\'$last_update\')", > $sql4) > or die ("could not do update"); > } - -- ~Paul Nicholson Design Specialist @ WebPower Design "The web....the way you want it!" paul@webpowerdesign.net "It said uses Windows 98 or better, so I loaded Linux!" Registered Linux User #183202 using Register Linux System # 81891 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9e6McDyXNIUN3+UQRAriZAKCTPYsBfypW7N6k8vpG+UDJEZ77BQCfVtEi BmSkmFZDBbXuAm+g3nvw/tc= =InFX -----END PGP SIGNATURE-----