<div>
can you give us the update query as it is written now?
</div>


can you give us the update query as it is written now?

<div>
@nanharbison<br />
<br />
$q = &quot;UPDATE exp_weblog_data SET field_id_29='$field_id_29'<wbr />, field_id_30='$field_id_30'<wbr />, field_id_31='$field_id_31'<wbr /> &nbsp;WHERE field_id_215='$field_id_21<wbr />5'&quot;; <br />
<br />
<br />

</div>


@nanharbison

$q = "UPDATE exp_weblog_data SET field_id_29='$field_id_29', field_id_30='$field_id_30', field_id_31='$field_id_31'  WHERE field_id_215='$field_id_215'";




<div>
Do you know how to send email in PHP? You could include the values you updated if you want to see them.
</div>


Do you know how to send email in PHP? You could include the values you updated if you want to see them.

<div>
I want to print the return on screen. &nbsp;Can I echo $q?
</div>


I want to print the return on screen.  Can I echo $q?

<div>
Absolutely, you can echo the query!
</div>


<div>
You can do this<br />

<pre><code id="code-7988226">$q = &quot;UPDATE exp_weblog_data SET field_id_29='$field_id_29', field_id_30='$field_id_30', field_id_31='$field_id_31'  WHERE field_id_215='$field_id_215'&quot;; 

if ($return = mysql_query($q, $yourconnection))
{
	echo $q;
)</code></pre>
</div>


You can do this


$q = "UPDATE exp_weblog_data SET field_id_29='$field_id_29', field_id_30='$field_id_30', field_id_31='$field_id_31'  WHERE field_id_215='$field_id_215'"; 

if ($return = mysql_query($q, $yourconnection))
{
	echo $q;
)

<div>
<div class="content wysiwyg-content">
I have a script that updates a database. &nbsp;It updates about 100 field from information that is being parsed from a feed. &nbsp;What type of query code would I need to write so that the UPDATE that ran would report to me the fields that were updated?<br />

</div>
</div>


I have a script that updates a database.  It updates about 100 field from information that is being parsed from a feed.  What type of query code would I need to write so that the UPDATE that ran would report to me the fields that were updated?


Query UPDATE report

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.