linein designs

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)
{
[...]

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