Quotes in MySQL Request (best practice)

Syntax in MySql can be tricky. The poor debugging service doesn’t really help. So, when in doubt regarding which type of quote using to write a request, I would suggest something like this : 

`tablefield`= “value”;

First quote for the name of the field in the table is a twisted quote `.
Second one for the value is a regular double quote “.

Easy way to play change select value

<select id=”idSelect”>
 <option val=”1a”>1st</option>
 <option val=”2a”>2nd</option>
</select>

Considering a classic select menu with a lot of options. Sometimes you may have to update your menu yourself when something else happens (content has changed, another navigation, etc.). val() function rocks.

$(“#idSelect”).val([]).val(“2a”);