fenway

It seems to be joining the tables the wrong way... use straight join, or try running analyze.

Which query is the problem?

Make sure php error reporting is enabled.

I'm not sure sure what you mean...

Try: select s.*, c.* from classes as c inner join students on c on c.id. = s.classes_id

What is your currect output?

Don't double-post next time.

See here.

You're missing a limit clause.

Too little info to answer your question.

That's full-text searching...

You really shouldn't be storing lists in single fields.

Yes, but how?

You can't use DISTINCT like that... you have to find the most recent comment first, then join back.

Sure... did it not work?

How was this solved?

Well, I don't know which query is the issue... but check mysql_error() after each one ... and echo each query, too.

You can use SELECT INTO OUTFILE.

You're echoing a statement... just echo the right-hand side: echo "select item_color from store_item_color where item_id = $item_id order by item_color";

Say what?

Start with error logs...

Why is this running on the client side?

This doesn't really sound like a DB question... though if that's all in one table, you need to normalize your tables.

Don't quote table identifiers.

You need to join the tables together using the FKs.