title: Sorry to be a pain, but another 1064 error in MySQL 5.1.36
body: <p>error msg:</p>
  
  <p><strong>1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'values('name','url','address','city','state','zip','phone'), values('name','url' at line 3</strong></p>
  
  <p>create table:</p>
  
  <pre><code>create table lawyer_info
  (firm_name varchar(100) not null,
  firm_url varchar(100) not null,
  firm_address varchar(100) not null,
  firm_city varchar(100) not null,
  firm_state varchar(100) not null,
  firm_zip varchar(12) not null,
  firm_phone varchar(15) not null);
  </code></pre>
  
  <p>data:</p>
  
  <pre><code>insert into lawyer_info firm_name,firm_url,firm_address,firm_city,firm_state,firm_zip,firm_phone)
  values('name','url','address','city','state','zip','phone'),
  values('name','url','address','city','state','zip','phone'),
  values('name','url','address','city','state','zip','phone'),
  values('name','url','address','city','state','zip','phone'),
  values('name','url','address','city','state','zip','phone'),
  values('name','url','address','city','state','zip','phone'),
  values('name','url','address','city','state','zip','phone');
  </code></pre>