<div>
First, you should use mysqli instead of mysql extension: mysql extension is deprecated and it will be no more supported.<br />
<br />
Secondly, error() function in mysqli (or mysql_error() function in mysql) is useful to debug your script, in order to get the exact error infos. In production server is a security issue to show mysql and php messages to the users and you can safely replace them with another error message:<br />
<br />

<pre><code id="code-20-40265335-1">$error_msg = 'Sorry, this is my error message';
mysql_query(&quot;UPDATE table SET column1=something&quot;) or die($error_msg);</code></pre>
</div>


First, you should use mysqli instead of mysql extension: mysql extension is deprecated and it will be no more supported.

Secondly, error() function in mysqli (or mysql_error() function in mysql) is useful to debug your script, in order to get the exact error infos. In production server is a security issue to show mysql and php messages to the users and you can safely replace them with another error message:



$error_msg = 'Sorry, this is my error message';
mysql_query("UPDATE table SET column1=something") or die($error_msg);

<div>
Thanks, I can work with that code. It gives me the actual error message which allows me to address each error uniquely.<br />
Have a good weekend,<br />
Sas
</div>


Thanks, I can work with that code. It gives me the actual error message which allows me to address each error uniquely.
Have a good weekend,
Sas

<div>
<div class="content wysiwyg-content">
Hi Guys,<br />
Is there a way to capture the results of a <b>mysql_error())</b> into a variable such as <b>$mysql_error = &quot;???&quot;;</b>?<br />
I want to state what the error is in my own words.<br />
Thanks,<br />
Sas<br />

<pre><code id="code-10-28499208-1">mysql_query(&quot;UPDATE table SET column1=something&quot;) or die(mysql_error() );</code></pre>
</div>
</div>


Hi Guys,
Is there a way to capture the results of a mysql_error()) into a variable such as $mysql_error = "???";?
I want to state what the error is in my own words.
Thanks,
Sas
(CODE)

How to create a $variable from a mysql_error()

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.