fenway

Sigh... use mysql_error() next time... you have your fields in single quotes.

Depends how common it is... read the refman page, fulltext is funny.

The display has nothing to do with the query -- does the latter work?

Sounds like this should be in the php help forum... please confirm.

Just when you thought normalizing databases had nothing to do with the real world... some (perhaps sarcastic) food for thought -- http://qntm.org/?gay -- I was going to post this in Misc, but maybe there's actually something to learn here.

Don't open a new topic for the same issue.....

Let's see... you're running a query called $ggroup1, but your query string is in $ggroup. Catching mysql_error() will help in the future.

Then you've double-posted... careful now.

I don't understand.

Right... so change this in your php.ini file.

Missing quotes.

You need to echo some queries.

Or, don't do either and don't use reserved keywords as column names.

What errors?

Could you give some real-world examples? And you table structure, too?

No, you'd have flag_id = 1 a thousand times in your table...

You may not need them per se... you're just taking a few values and adding them ... subqueries can help you here.

I have no idea what you're talking about... ?

Whatever expressions are valid for WHERE are valid for HAVING -- so you can use BETWEEN just like before.

You mean like select username, count(*) from fans where dateadded = <the-date-you-want> group by username ?

It happens... don't forget it mark it "solved"... LOL.

Yikes! Why is everything of type TEXT? And why don't you store the flag_id in the infobase table?

Not sure what you mean by "inaccurate" -- how do you want the month logic to work?

That's simply becuase the rank is an alias, which gets "renamed" after the WHERE clause... try HAVING.

Sounds like you need a join... post your table structure.