Hit enter to search or ESC to close
Web Development Kansas City | ProdjexWeb Development Kansas City | Prodjex
  • Home
  • Web
    • Web Development
      • ASP.NET Development Services
      • Bootstrap Development
      • Laravel Development
      • PHP Development
      • Rest API Development
      • Web Development
    • Other Development
      • Invision Power Board Plugins
      • Rest API Development
  • Mobile
    • Android App Development
    • iOS App Development
    • React Native
    • Xamarin
  • WordPress
    • WooCommerce Development
    • WordPress Development
    • WordPress Plugins
  • Database
    • Microsoft SQL Server Development
    • MySQL Development
  • Tutorials
  • About
  • Contact
Tag

mysql Archives | Web Development Kansas City | Prodjex

Apr 09
Love1
Database Driven Google Map

Database Driven Google Map

By Prodjex API, Google, jQuery, PHP No Comments
Using the Google Maps API you can generate a map with markers and on click or hover show an information tooltip.  Here's an example of how to accomplish this. First...
Read More
Jan 15
Love0
MySQL Trim

MyISAM vs InnoDB

By Prodjex mySQL, SQL No Comments

An application I’ve been troubleshooting has had major performance issues last week.  I spent a few hours on it banging my head against a wall.  Finally after doing some research…

Read More
Aug 14
Love0
MySQL Trim

MySQL Trim

By Prodjex mySQL No Comments

I have a column within my MySQL table that holds city and states for records. The dataset looks like the following: Clay County, AL Cleburne County, AL Coffee County, AL…

Read More
Aug 07
Love0
Username Availability Check

Username Availability Check

By Prodjex HTML, jQuery, PHP, SQL No Comments

This will be a walk-through on how to create a submit form that checks the database to make sure the username is not taken.  If it is taken it will…

Read More
Aug 06
Love0
MySQL - find in set vs in

MySQL – find in set vs in

By Prodjex mySQL, SQL No Comments

These are two different commands with different outputs when added to a SQL query. MySQL “in” command for example: select * from assets a left outer join assetInterests ai on…

Read More
Aug 06
Love0
Simple Twitter Auto Poster

Simple Twitter Auto Poster

By Prodjex PHP, SQL, Twitter No Comments

This is the first in what will end up being a several part tutorial on creating a Twitter posting program.  These tutorials will show how to create the bot using…

Read More
Aug 01
Love0
MySQL - find in set vs in

WordPress SQL Syntax Example

By Prodjex SQL, Wordpress No Comments

I have a couple of tables I’m joining and only want to return users that a field missing in the joined table. Users id fname lname userMeta id metaKey metaValue…

Read More
Jul 31
Love0
MySQL Trim

Delete Duplicates from mySQL Database Table

By Prodjex mySQL, SQL No Comments

I was trying to figure out a query to count the IP addresses I had in a table, tell me how many are the same, then delete duplicates only leaving…

Read More
Jul 31
Love0
MySQL Trim

SQL Syntax for Summing an Alias and Grouping by ID

By Prodjex SQL No Comments

Simple SQL query to sum an alias column and group by ID. Initial query user needed help with: select dt.member_id, dt.NumberOfMonthsBetween FROM ( select member_id, DATEDIFF(month,date_credentialed,renewal_date) as NumberOfMonthsBetween from member_credential…

Read More

Categories

  • Announcements
  • Apache
  • API
  • AWS
  • Azure
  • Bootstrap
  • Code Editor
  • Composer
  • CSS
  • DevOps
  • DNS
  • Google
  • HTML
  • IP.Board
  • Javascript
  • jQuery
  • JSON
  • Laravel
  • Linux
  • mySQL
  • node.js
  • PHP
  • Prodjex
  • SEO
  • SQL
  • Twitter
  • Webserver
  • WHM/cPanel
  • Windows
  • WooCommerce
  • Wordpress

Tags

.htaccess Apache artisan AWS bootstrap Centos composer cpanel css disable Elastic Load Balancer ELB fontawesome function html HTTP HTTPS ip.board javascript jquery JSON laravel linux meta mysql node.js php plugin pm2 posts query redirect rss select sql sql syntax ssh strtotime syntax Webserver whm Windows woocommerce wordpress xml
Prodjex Logo

Prodjex

888 Haines, Suite 218
Liberty, MO 64068

Email Us

info@prodjex.com

Call Us

(816) 219-1899

Quick Links

  • Home
  • About
  • Contact
  • IP.Board Plugins
  • Web Development Forums
  • Web Development Blog
  • WordPress Plugins

Web Development

  • Bootstrap Development
  • Database Development
  • Laravel Development
  • MSSQL Server Development
  • MySQL Development
  • PHP Web Development
  • Rest API Development
  • Web Development
  • WooCommerce Development
  • WordPress Development

About Us

Prodjex is a Kansas City web development company that provides end-to-end web development services for all things web related. Founded in 2017, we’ve grown quickly and provide web consulting services to clients not only in Kansas City, but across the US.

© 2021 Prodjex. All Rights Reserved. | Privacy Policy

  • Home
  • Web
    • Web Development
      • ASP.NET Development Services
      • Bootstrap Development
      • Laravel Development
      • PHP Development
      • Rest API Development
      • Web Development
    • Other Development
      • Invision Power Board Plugins
      • Rest API Development
  • Mobile
    • Android App Development
    • iOS App Development
    • React Native
    • Xamarin
  • WordPress
    • WooCommerce Development
    • WordPress Development
    • WordPress Plugins
  • Database
    • Microsoft SQL Server Development
    • MySQL Development
  • Tutorials
  • About
  • Contact