www.dynamic-coders.com

Hi All,
From now onwards all my recent posts and blogs can be found on http://www.dynamic-coders.com .
Including the blogs listed on this blog.
visit: www.dynamic-coders.com

How to execute update query by applying join on two different tables in different databases on same server

update <dbname of 1st table>.<table name of 1st table> A INNER JOIN <dbname of 2nd table>.<table name of 2nd table> RA ON A.<field name of table 1>=RA.<field name of table 2> SET A.<field name of table 1 to be updated>=RA.<field name of table 2 to set value in table 1>


Replace data in < > with your appropriate values.

Thats It.
 

How to replace degree(°) with " & deg;" using php

$myvalue=" +1°C to +10°C";
$r=preg_replace("/\xB0/", '&deg;', $myvalue);

$myvalue will contain value that you want to replace.