title: MySQL SELECT while UPDATE
body: <p>I wrote a query, and Im sure that it was right form.
  But I get an error. :)
  May I do this query else?</p>
  
  <pre><code>UPDATE pages SET 
      p_name = 'Activites', 
      p_active = 1, 
      p_parent = 'sport', 
      p_parent_id=(
      SELECT p_id FROM pages WHERE p_link='sport' LIMIT 1
      ), 
      p_link = 'activites' 
      WHERE p_id = 9;
  </code></pre>
  
  <p>Thank you.</p>