fenway

Sounds like you need some cross joins....

That error message means you didn't execute a sucessful query... but MAX(id) is the better way to go... the question is why you need this.

I'm not sure what you mean by this.

You have multiple statements in your TRIGGER, so you can't use ";" to end your statements and your trigger -- you need to change the delimiter first.

Silly me... both is a reserved keyword... I had no idea. SELECT e.* FROM events AS e INNER JOIN ( SELECT `organization_id` FROM `events` WHERE MATCH (events.theme, events.contact_name, events.contact_email, events.contact_phone) AGAINST ('southern' IN BOOLEAN MODE) UNION ALL SELECT `id` AS organization_id FROM `organizations` WHERE MATCH (organizations.church_name, organizations.city, organizations.contact_name, organizations.email) AGAINST ('southern' IN BOOLEAN MODE) ) AS sub ON ( sub.organization_id = e.organization_id ) My bad.

You assume? Didn't you check? How are they separated?

That's great -- the EXPLAIN should indicate that FULLTEXT is being used for both ... and I would all UNION ALL to save a filesort. All of you need to do know is join the events to able to this union'ed table: SELECT e.* FROM events INNER JOIN ((SELECT `organization_id` FROM `events` WHERE MATCH (events.theme, events.contact_name, events.contact_email, events.contact_phone) AGAINST ('southern' IN BOOLEAN MODE)) UNION ALL (SELECT `id` AS organization_id FROM `organizations` WHERE MATCH (organizations.church_name, organizations.city, organizations.contact_name, organizations.email) AGAINST ('southern' IN BOOLEAN MODE)) ) AS both ON ( both.organization_id = e.organization_id )

Yes, but the error message you posted is from the query in the commented code -- so what's the actual problem?

Forget the JOIN for a minute... just UNION each table with it's own FULLTEXT index.

I still have no idea what the M_addtn field looks like, I'm sorry. You're describing the destination, not hte souce.

Huh? I'm talking about: /*$entered = "UPDATE $player SET gm1 1 = 'Giants' WHERE id ='10' LIMIT 1" ; $entered = "UPDATE $player SET gm1 1 = $pick WHERE id = '$myid'";//$p_name $result = mysql_query($entered, $link) or die (mysql_error());*/ [code] [/code]

the atrribute for it says BINARY, thats all that is list Field: m_addtn Type: blob Attribute: binary Null: No The format of the data being stored inside this field.

Well, a FULLTEXT index (or any index, for that matter) cannot cross tables, so that's why you need to use separate MATCH...AGAINST clauses. But why not just UNION the results of two separate queries?

That doesn't answer my question... what is the format of this BLOB field?

Not only that, but your column name has a space in it????

Sections? Please clarify.

No mysql_error()?

Hopefully this presentation will stay online at scribd... it's simply fantastic, probably the best I've come across in recent memory. At 220 slides, it's quite lengthy -- but the lessons learned are invaluable, so be sure to read all the way to the end. A MUST READ!!!! EDIT: This year's version of the presentation -- some really great stuff in here, particuarly about hierarchies.

At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets (PDF).

This resource covers a very broad range of topics... it's worth a look, though, especially if you're stumbling in the early stages of configuration.

Basically, this blog contains a regularly-updated run-down of MySQL functions, with a short description and a few hints on how to use them; RSS feed here.

Please read the excellent FAQ thread on this issue by our very own wildteen88.

To ensure that your post gets answered as soon as possible, please make sure you've included the following: your MySQL server version -- absolutely required! the raw MySQL statement in question [in a CODE block, and without any PHP variables] any errors that MySQL returns to the client [from mysql_error()] the table structure & column indexes of the relevant tables [via SHOW CREATE TABLE is preferred] the EXPLAIN output for your query, if applicable a clear and concise description of what you want this statement to achieve a description of what it's currently doing that's not to your liking a brief listing of the types of things you've attempted so far If you don't provide any or all of the above, don't be surprised if your post never gets the attention it deserves. --fenway

You'll find a very good list of do's and don'ts written by Matt Kruse here -- highly recommended.

MySQL's tech resource article on database normal forms is an excellent read. NEW!!! - A large (160MB, 4M record) sample database with test suite for MySQL -- fantastic for running "real" queries. In addition, MySQL provides a number of sample databases for testing purposes; personally, I find this one to be the most useful for playing around with SQL statements and such. The Zip Code Database Project exists to provide US Zip Codes in their entirety; latitude and longitude coordinates included! The downloads are in CSV and MySQL table dump formats. Also, there's an pretty good online "data generator", and SQL is one of the options... although personally, I prefer the integers table approach (courtesy of Baron Schwartz): set @num_gamers := 10000, @num_countries := 5, @num_games := 10; drop table if exists gamer; drop table if exists game; drop table if exists country; drop table if exists score; drop table if exists semaphore; create table gamer( gamer int not null, country int not null, name varchar(20) not null, primary key(gamer) ); create table game( game int not null, name varchar(20) not null, primary key(game) ); create table score( gamer int not null, game int not null, score int not null, primary key(gamer, game), index(game, score), index(score) ); create table country( country int not null, name varchar(20) not null, primary key(country) ); -- I use the integers table to generate large result sets. drop table if exists integers; create table integers(i int not null primary key); insert into integers(i) values(0),(1),(2),(3),(4),(5),(6),(7),(,(9); insert into country(country, name) select t.i * 10 + u.i, concat('country', t.i * 10 + u.i) from integers as u cross join integers as t where t.i * 10 + u.i < @num_countries; insert into game(game, name) select t.i * 10 + u.i, concat('game', t.i * 10 + u.i) from integers as u cross join integers as t where t.i * 10 + u.i < @num_games; insert into gamer(gamer, name, country) select th.i * 1000 + h.i * 100 + t.i * 10 + u.i, concat('gamer', th.i * 1000 + h.i * 100 + t.i * 10 + u.i), floor(rand() * @num_countries) from integers as u cross join integers as t cross join integers as h cross join integers as th; insert into score(gamer, game, score) select gamer.gamer, game.game, floor(rand() * @num_gamers * 10) from gamer cross join game;