fenway

You shouldn't use a minus sign in your column name -- underscores are much better!

UNSIGNED will prevent it from being stored... but you'd have to catch the error when trying to set it (strct) or the warning (not strict).

Yes, and that "button" triggers a form action that will get processed by PHP.

Well, not multiple "ORDER BY"s, just separate groupings, is what I meant to say. For example, ORDER BY IF( t.topic_type = 1, 0, 1 ) ASC will always put topic_type 1 first. Then it gets more complicated...

Use STR_TO_DATE().

You didn't read my comment about the "alive" value before... quote it! In fact, quote all of your values! mysql_query("INSERT INTO `users` (username, password, email, activecode, activated, tut, status) VALUES ('$reg_username', '$randompassword', '$email', '$code', 0, 0, 'Alive')"); if (mysql_affected_rows() != 1) die ('Query failed: '.mysql_error());

Well, you'ld need to quote "Alive"... but if you don't want the values, don't list the column name (assuming you have suitable defaults in strict mode, or strict mode is disabled).

Even better, post the actual sql query, not the php variable.

Don't put multiple values into a single field... that's a very BAD idea.

This is more of a php question, really....

Forget about adding another part -- write this separate query first.

You need to use multiple order by clauses... do you still care?

Lots... see here.

Ignore the 3, it's meaningless. it's dispaly width.

You want: SELECT eventtable.EventID FROM eventtable LEFT JOIN usereventtable ON ( eventtable.EventID = usereventtable.EventID AND usereventtable.UserID='{$_SESSION['Current_User']}' ) WHERE eventtable.ActivateUrl='$Url' AND usereventtable.EventID IS NULL ORDER BY RAND() LIMIT 1

I'm still quite confused... how can you aggregate on ID *and* include some values for "each" row?

Why the group by ? Aren't the ID's unique?

No, this is a php quoting issue.

No, you have to alias them, or don't use *.

You'll need to count the number of matches and check it with a HAVING clause to filter out the others... and an IN() clause may prove helpful, too.

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