Worcester Web Site Development Blog

mysql update from another table

July 3, 2007

Recently I needed to update a bunch of rows in mysql with information from another table. I will explain how to do this simple process.

1. Open up phpmyadmin or similar database editor
2. view the sql query below

Lets say we have 2 tables one named main and one named updateto and one named updatefrom, In the first line we assign variables to these t tables (p and pp) from there we can call column names using this format table.columname. If we had first_name and last_name in both tables and wanted to update the “updateto” table with the info from “updatefrom” this is how you would write it.

Posted by Anthony LeBoeuf under mysql, Web Technology, PHP | Comments (1)

Create Custom google maps

May 19, 2007

I was browsing the google maps API the other day and came up on something pretty cool, google now allows you to make custom maps right on their website. Previously only the tech savvy knew how to accomplish through server side scripts such as PHP, not anymore! I played around with it a bit making a map for a website I’m working WCMP. You can draw lines, squares and circles and put markers wherever you want on the map. Google also boasts a rich editor to format the description of your marker even going as far as putting in pictures. This is a great tool for your clients website or even document a recent vacation you went one. Check it out, heres the one I made. If you make a cool map feel free to post it here so I can take a look.

Posted by Anthony LeBoeuf under Web Technology | Comments (0)