<div>
The second field is attempting to create a SQL INSERT statement, but the INSERT statement is never run. The out of this is the series of INSERTs, which you should then copy into a script file -- then run the script. <br />
<br />
If you really want the INSERTs to fire, then this should look more like INSERT INTO table SELECT ... syntax. 
</div>


<div>
I agree with above on the reason. You will need to use a MySQL prepared statement to run the dynamic sql created - <a href="http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.html" rel="ugc nofollow">http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.html</a><br />
<br />
What exactly are you wanting to do? Just note that UPDATE WITH JOIN in MySQL is in the UPDATE, i.e.:<br />

<pre><code class="code-1 nolinks" id="code-20-36937727-1"><span>UPDATE a, b</span>
<span>SET a.column = b.column</span>
<span>WHERE a.key = b.key</span>
<span>;</span>
</code></pre>
<br />
or <br />

<pre><code class="code-1 nolinks" id="code-20-36937727-2"><span>UPDATE a JOIN b ON a.key = b.key</span>
<span>SET a.column = b.column</span>
<span>;</span>
</code></pre>
<br />
Otherwise, the syntax shown by Mark should work.
</div>


<div>
Thanks, helps me a great deal.<br />
regards<br />
M
</div>


<div>
<div class="content wysiwyg-content">
SELECT itemid, CONCAT( &nbsp;&quot;insert into tblmembers (ID,&quot;, GROUP_CONCAT( b.fieldname ) , &nbsp;&quot;) values (&quot;, itemid, &nbsp;&quot;,&quot;, GROUP_CONCAT( &nbsp;&quot;'&quot;, data_txt, &nbsp;&quot;'&quot; ) , &nbsp;&quot;);&quot; ) <br />
FROM jos_sobi2_fields_data AS a<br />
JOIN tablefields AS b ON (<br />
a.`fieldid` = b.`fieldid`<br />
)<br />
GROUP BY itemid<br />
ORDER BY itemid<br />
LIMIT 0 , 30<br />
<br />
Can anyone tell me why this statement doesn't create records in the table 'tblmembers'<br />
tblmembers &amp;&nbsp;jos_sobi2_fields_data &amp;&nbsp;tablesfields all exist and are structured properly.<br />
<br />

</div>
</div>


SELECT itemid, CONCAT(  "insert into tblmembers (ID,", GROUP_CONCAT( b.fieldname ) ,  ") values (", itemid,  ",", GROUP_CONCAT(  "'", data_txt,  "'" ) ,  ");" ) 
FROM jos_sobi2_fields_data AS a
JOIN tablefields AS b ON (
a.`fieldid` = b.`fieldid`
)
GROUP BY itemid
ORDER BY itemid
LIMIT 0 , 30

Can anyone tell me why this statement doesn't create records in the table 'tblmembers'
tblmembers & jos_sobi2_fields_data & tablesfields all exist and are structured properly.



SQL Statement not working

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.