Search for non-duplicates bettween two tables.

Categories Information Technology, MySQL, PHP, Programming, Web Development

I recently had some issues trying to make sure that two columns from two different tables were the same.  After some random code writing, I came up with the following MySQL code…  Hope it helps others…

/* return from first table */
$checkTable1=@mysql_query("SELECT table1.column1 FROM table1 LEFT JOIN table2 ON table2.column2 = table1.coumn1 WHERE table2.column2 IS NULL");

/* return from second table */
$checkTable1=@mysql_query("SELECT table2.column2FROM table2 LEFT JOIN table1 ON table1.column1 = table2.column2 WHERE table1.column1 IS NULL");

I’m sure there is a better way to accomplish it, but this worked for my needs…  Just a quick search, and then I added some extra code to update the tables if there are any discrepancies.


Easy GPS Coordinates

Categories Google, Google Maps, JavaScript, Web Development

Ever need to find the GPS coordinates for a location?
Try the simple step below to get the GPS coordinates for any location, using Google Maps:

  1. Open Google Maps, and find the areayou wish GPS coordinates for
  2. Right click at the specific spot you would like GPS coordinates for
  3. Select “center map here” from the list
  4. Paste this JavaScript code into the address bar
    • javascript:void(prompt(”,gApplication.getMap().getCenter()));
  5. Press Enter on your keyboard
  6. A pop-up will appear showing the coordinates of the center of the map. It should look something like this: (43.60336, -110.7362)
  7. Right click on the coordinates to copy, and click either “OK” or “Cancel”

The IT Project-Tracking Database: Keep Your Key People in the Loop

Categories Information Technology, Information Technology Links, Web Development

via E-Commerce Times

A project-tracking database should not just be a nominal entity that exists for the sake of existence; rather, it should contain some key attributes that every person in the company can draw important conclusions from — and use them to form the basis of key decisions that impact not just the project itself, but also the overall vision and direction of the company.

Information Technology is a project-centric industry. Every task is either performed as a part of a project or constitutes rollup toward creating a new project. No individual, organization, department or company can escape the rigor of discipline and perseverance that project management enforces as prerequisites for success. However, information Technology often receives a bad rap for the relatively small number of successful initiatives as a percent of the total initiatives launched, compared with other departments.

Technologists are viewed as inherently more disciplined — and more capable of thinking and planning in a structured manner — than their “non-technical” counterparts. I believe this classification is unjust. No matter how trained the human mind, it still cannot replace the uber-productivity tools that assist project discipline today. Initiatives fail mid-stream or fail to take off not because they are not good initiatives, but because of the improper amalgamation of the prowess of the human mind with the appropriate technology (read tools) that it has created for its assistance….

Chrome Passes Safari

Categories Browsers, Chrome, Google, Google News, Information Technology, Safari, Web Development

via Website Magazine

Web analytics provider StatCounter is reporting that Google’s Chrom browsre has overtaken Apple’s Safari in the US for the first time. Research is from the firm’s StatCounter Global Stats report for the week beginning June 21.

Chrome with 8.97% took third place in the US browser market ahead of Safari with 8.88%. Microsoft’s Internet Explorer still dominates the US Internet browser market with 52%, followed by Firefox (28.5%).

“This is quite a coup for Google as they have gone from zero to almost 10% of the US market in under two years,” commented Aodhan Cullen, CEO, StatCounter. “There is a battle royal going on between Google and Apple in the internet browser space (Chrome v Safari) as well as in the mobile market (Android v iPhone).”

The data is based on an analysis of 3.6 billion page views (874 million from the US) for the week 21 to 27 June 2010 collected from the StatCounter network of over three million websites