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

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