linein designs

Archive for the ‘mysql’ Category

10 Nov, 2008

MySQL Full-Text Stopwords Array

Posted by: john In: mysql|php

Below is an easy to use array of the default full-text stopwords in MySQL taken from MySQL.com.

I was going to be a good Bellsouth customer and try out their new “free” personality test when I get this SQL error. This can mean a whole heap of personal issues I’m going to have to deal with: I really do have a twin brother! I’m so common I get a SQL duplcate enty [...]

Quite a few times during projects I only want to find a single value from the database. But rather than setting up WHILE loop, I’ve been using a quick function that does two things perfectly. Here’s the function: // returns single result function mysql_one_data($query) { $one=mysql_query($query); $r=mysql_fetch_row($one); return($r[0]); } // returns single array function mysql_one_array($query) [...]

01 Feb, 2007

Compare Two MySQL Tables

Posted by: john In: mysql

The other day I needed to compare two tables and see what data was in one but not in the other. table_a is my main table that I want to update and table_b is my storage table that I have my updates in. The query below will return all records that are in table_b, but [...]



  • john: There's no easy way to stop it within the InnerFade plugin, but you could just erase all the list items after you've cycled through them using jQuery.
  • Steven: Rachid, did you find an answer? Is there a way to stop by a picture at the end? Can anyone help? Thanks in advance!
  • htc smartphone: WP togo is going to be a great little example of just what kind of super-power these droids will offer like the htc aria and other htc mobile phones l


Please Support Our Friends

Send emails with ease on this SMTP server by JangoSmtp.com.

Banner

About

My name is John Veldboom and have been in design and web programing for just over 8 years now. Started off as a hobby in high school but it has developed into a full time job now. I always tell people that if I wasn't doing this at work each day, I would be at home doing it for free. I love it!

Please visit the contact page to drop me a message.