fenway

Huh?

Echo $query.

Depends what you're trying to do... INNER JOIN is better unless you want to retrieve posts that don't have matching categories/users.

Have you issued a CHECK TABLES?

I'm not sure I know what you mean... if you have the ID of the corresponding row, you can issue a DELETE statement for that ID.

That's because modID is going to be null for everyone else, and null sorts differently.... if you use IFNULL() and set it to -1, ASC should be fine.

Are you sure you've selected the right DB?

Simply join the users and categories table to the posts table.

With wildcards LIKE is the same as =.

It's not different as much as it is unsupported. Try this (untested): SELECT DISTINCT order_number FROM orders INNER JOIN ordercart ON orders.order_number = ordercart.id INNER JOIN categories ON orders.product = categories.catid WHERE orders.confirmed =1 AND thedate = '2008-04-03' AND categories.designerid =9 I'm just guessing at tables here.

DATE_FORMAT() always returns a string regardless... but the only reason to get an error like that with a subquery (i.e. at the SELECT keyword) is a version issue.

Hmmm... we'll, I'd quote those string literals.

Which db version?

Don't... preprend this code for display only.

Though I'd prefer a left join.

What do you think the first operand to LEFT() is doing? You can't string concat that way.

double-post -- topic locked.

I don't know what you mean by "work"... this is simply a very big associated array.

Can be used anywhere an expression is alid.

You mean "WHERE col1 = CONCAT( col2, col3 )"?

I mean this: SELECT count(student_answer.choice_No) 'counted', choice.choice_No 'no', choice.choice_Desc 'desc' FROM student_answer LEFT JOIN choice ON ( choice.choice_No = student_answer.choice_No AND choice.question_ID = '2') WHERE student_answer.question_ID = '2' and choice.choice_No IS NULL GROUP BY choice.choice_No ORDER BY choice.choice_No

You have to move the non-null part of the where clause on the on clause (which you don't even have) and then switch the OR to AND.

You need to see for choice.question_ID IS NULL.

If you define the column as AUTO_INCREMENT, it will do it for you if you pass it a NULL value.

Are those single quotes?