<div>
You will want to use the php function mysql_real_escape_string()<wbr /> to sanitize the data for your query.
</div>


You will want to use the php function mysql_real_escape_string() to sanitize the data for your query.

<div>
I like both answers. Thank you
</div>


<div>
<div class="content wysiwyg-content">
So I posted earlier and got help on running update and insert queries, but now I have a different problem. I want to know what the best way is to run a select query based on an input field.<br />
<br />
So for example, I have a field which posts to a page and is included in the WHERE statement: &quot;SELECT * FROM table WHERE UserID=$userID AND Field1='$input'<br />
<br />
The $input variable is the field the user enters on the prior page. But if I use an apostrophe, it errors out. How can I do this??<br />
<br />
Also..... Quotes work, but I really don't care about that. I'd rather be able to use an apostrophe if I had to choose...
</div>
</div>


So I posted earlier and got help on running update and insert queries, but now I have a different problem. I want to know what the best way is to run a select query based on an input field.

So for example, I have a field which posts to a page and is included in the WHERE statement: "SELECT * FROM table WHERE UserID=$userID AND Field1='$input'

The $input variable is the field the user enters on the prior page. But if I use an apostrophe, it errors out. How can I do this??

Also..... Quotes work, but I really don't care about that. I'd rather be able to use an apostrophe if I had to choose...

MySQL Query Using Quotes and Apostrophes

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

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.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.