Cotton Rohrscheib

The Cotton Club Blog & Podcast

  • Home
  • About
  • Blog
    • Collecting
    • Faith & Family
    • Marketing & Tech
    • Farm & Business
    • Entertainment
    • Health & Wellness
    • Urban Farming
    • Weekend Projects
  • Podcast
  • Newsletter
  • Media
    • Photo Galleries
    • Video Archives
    • Apple Music Playlists
  • Marketplace
  • Connect
You are here: Home / Archives for MySQL

SQL Truncate & mt_rand()

September 18, 2008 by Cotton Rohrscheib Leave a Comment

For anyone that may have wondered why the upgrade to 2.6.2 was so important, here’s a pretty good explanation I found on WordPress Developers Blog tonight.  It has to do with a SQL column truncation issue that could basically alter users login credentials, etc. Stefan Esser recently warned developers of the dangers of SQL Column […]

Filed Under: Marketing & Tech Tagged With: MySQL, PHP, Wordpress™

Adding Form to DB Record in PHPR

August 14, 2008 by Cotton Rohrscheib Leave a Comment

I recently had a pretty intensive PHPR project where I had to create a page for a client that called in records from their database as well as displaying a form that visitors could us to contact the “name” and “email” from that particular record.  In theory this isn’t a complicated thing to get your […]

Filed Under: Marketing & Tech Tagged With: MySQL, PHP, PHPRunner IDE

PHPR Project Management

August 11, 2008 by Cotton Rohrscheib Leave a Comment

I found this interesting post on the Xlinesoft forum tonight. (Best Practices) It relates to Best Practices for using PHPRunner & Subversioning.  I currently don’t have a use for this in anything I am working on but thought that it was pretty interesting so I decided to include it here… —————————————————— 1.0 Summary: Setting up […]

Filed Under: Marketing & Tech Tagged With: MySQL, PHP, PHPRunner IDE, Project Management

Table Events Bug w/ Catalog – Registration App

April 10, 2008 by Cotton Rohrscheib 3 Comments

I put together a class catalog and registration application a while back for a client and it’s been working great with the exception of one small bug that I can’t seem to be able to locate.  I have it setup using Table Events (After Record Added) in PHPR to send an email once someone registers […]

Filed Under: Marketing & Tech Tagged With: MySQL, PHP, PHPRunner IDE

Create a table with the list of US states

February 22, 2008 by Cotton Rohrscheib Leave a Comment

I had another PHPR user email me the other day and ask how was the best way to go about adding a table for US states that already had all of the states already listed.  I had to think for a minute because what I usually do is build a table for states and leave […]

Filed Under: Marketing & Tech Tagged With: MySQL, PHPRunner IDE

Project: Class Catalog & Registration Process

February 21, 2008 by Cotton Rohrscheib Leave a Comment

I was approached by a long-time client last month to help her put together a dynamic class catalog application that she could manage in-house that listed the reflexology and massage classes that she offers.  In addition to the class catalog management process she also wanted to develop a system that would enable her potential students […]

Filed Under: Marketing & Tech Tagged With: MySQL, PHP, PHPRunner IDE

Project: Powersite Document Manager v1.0

February 18, 2008 by Cotton Rohrscheib Leave a Comment

This is a small utility / script that I put together that allows administrators of a website or intranet application to easily add documents such as .pdf files to an online listing that can be accessed by visitors to their website or users on their corporate intranet.  I have a few solutions like this one […]

Filed Under: Marketing & Tech Tagged With: MySQL, PHP, PHPRunner IDE

Book Review: PHP 5 / MySQL Programming

February 17, 2008 by Cotton Rohrscheib Leave a Comment

I actually picked this book up a while back so that I could get up to speed w/ PHP and MySQL programming and I really enjoyed it.  It was an easy read and I still refer back to it from time to time to find things, it stays on the bookshelf behind my desk. If […]

Filed Under: Blog Tagged With: Amazon, MySQL, PHP

Book Review: PHP & MySQL for Dummies

January 29, 2008 by Cotton Rohrscheib Leave a Comment

This is another book that I purchased a while back to help me get up to speed on PHP and MySQL development.  It’s a pretty straightforward book like a lot of the “for dummies” books are.  Needless to say that a lot of the info in the book is kind of basic but it can […]

Filed Under: Blog Tagged With: Amazon, MySQL, PHP

Project: Powersite Business Directory v1.0

January 21, 2008 by Cotton Rohrscheib Leave a Comment

This is a project that I have been working on for Chambers of Commerce’s and Associations that need an easy to use web-based content management solution for managing their membership database. There are a few examples of this solution online at: Heber Springs Chamber of Commerce Greers Ferry Lake & Little Red River Association As […]

Filed Under: Marketing & Tech Tagged With: MySQL, PHP, PHPRunner IDE

  • « Previous Page
  • 1
  • 2
  • 3
  • Next Page »

Recent Updates

  • Why Are American Cattle Producers Upset About More Beef Imports?
  • Frustrations with PSA in the Trading Card Industry
  • Corn and Soybean Prices Are Finally Showing Some Life — What Should Growers Expect Next?
  • Tariffs and the American Farmer: How the Trade Fight Has Hit Agriculture This Season
  • Arkansas Rice Farmers Are Being Squeezed: Why 2026 Has Become Such a Difficult Year

Blog Categories

  • Blog (457)
  • Collecting (10)
  • Entertainment (381)
  • Faith & Family (156)
  • Farm & Business (311)
  • Health & Wellness (38)
  • Marketing & Tech (595)
  • Podcasts (34)
  • Urban Farming (25)
  • Weekend Projects (16)

Blog Archives

Content Copyright © 2000-2026
Cotton Rohrscheib | Rohrscheib Capital
Disclaimer | Privacy Policy | Account Manager | View Cart

All opinions expressed on this website are 100% Cotton (see my disclaimer). All content, including text, images, and media, are the intellectual property of Rohrscheib Capital unless otherwise noted. To learn how we use your private information, checkout our privacy policy.