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 error.
My [...]

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 no [...]




Please Support Our Sponsors

A Payday advance can be a great way to get back on track.

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.