PHP and Postgres

An unsorted collection

HTML radio input onchange

<input type="radio" name="somename" onchange="alert('change')"> The event will only fire if a button is selected. Nothing will happen if the button is unselected by clicking on another button of that name-group. (FF51)

&& vs AND

If you have multiple expressions in PHP, AND will stop checking after the first FALSE, && will not.

Postgres string concat

The glue operator is ||. If you put raw strings and columns together the concat function shows errors. Instead use: update table set anycol=anycol||' heyho '::text||othercol

Update Inner Join

Don't try that. if you want to update connecting 2 tables use this syntax: update table set x=y from table2 where...