RE: [PHP-DB] Parsing CSV files into a MySQL Table
| From: | Alex Bovey | Date: | Tue, 02 Nov 2004 16:10:29 +0000 |
| Subject: | RE: [PHP-DB] Parsing CSV files into a MySQL Table | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37145@lists.php.net to get a copy of this message | ||
> mysql_query ("INSERT INTO 'footable' (foo1, foo2, foo3,
> foo4, foo5, foo6, foo7)
> VALUES '$foo1', '$foo2', '$foo3', '$foo4',
> '$foo5', '$foo6', '$foo7')"); }
You're also missing an opening bracket after 'VALUES'. The statement should
be:
mysql_query ("INSERT INTO 'footable' (foo1, foo2, foo3, foo4, foo5, foo6,
foo7)
VALUES ('$foo1', '$foo2', '$foo3', '$foo4',
'$foo5', '$foo6', '$foo7')");