fenway

You can't just randomly pick whatever columns you want when using group by -- member isn't a "valid" option here. You'll need to join back to the table once you're found the "max" record to get the remaining details.

No, it's because the comma operator and JOIN don't have the same precedence in v5. Moral of the story -- NEVER EVER EVER use the comma operator -- EVER. It's only 3 extra characters to do it properly. In the meanwhile, wrapping the "comma-separated" list of tables in parens will "solve" your problem -- see below. SELECT p.products_id, p.products_image, p.products_tax_class_id, if( s.status, s.specials_new_products_price, p.products_price ) AS products_price FROM (products p, products_description pd, products_to_categories p2c, categories c) LEFT JOIN specials s ON p.products_id = s.products_id WHERE products_status = '1' AND p.products_ordered >0 AND p.products_id = pd.products_id AND pd.language_id = '1' AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND '0' IN ( c.categories_id, c.parent_id ) ORDER BY p.products_ordered DESC LIMIT 10

You have to figure out who is logged in somehow -- I assume you're storing that somehwere.

This is a php issue....

Like this: $sql = mysql_query("SELECT count(*) FROM tbl_maillist_users WHERE ListsID='$ListsID' AND Status='Active'") or die(mysql_error()); $users = mysql_result($sql, 0, 0);

Look at LOAD DATA INFILE... you can specify tab-separated.

The answer is "no" -- what's wrong with a union?

"required info"? what is that?

So use a LEFT JOIN, and COALESCE() the value.

Well, let's see, we have no idea what the query is....

Well, you'll need to pull back some from the session (cookie, session_id, whatever).

NO NO NO.... you're retrieving ALL the rows in each table just to get a simple count! The answer was provided above.

What do you have so far?

First, you need to get the most recent timestamped "thing"... then you need to join it back.

You need to use UNION... not a JOIN.

How about echo-ing the sql statment?

No problem... so, for the record, which index worked???

You can... but not on binary data, only character data.

Why do you have *two* select statements???

That depends... what id are we talking about?

Ignoring the obvious design flaw here, the issue is that you can't use a dynamic column list in sql

What's wrong the mysql refman?

Switch to proper JOINs... then LEFT JOIN to the highlight table on ( user_id ), and use IFNULL() to check.

You can't filtered on LEFT JOIN'ed results -- move that condition to the on clause.

Covers: Part 1: Using the MySQL Improved Extension, mysqli Part 2: Using the MySQL Extension, mysql Part 3: Using the PDO Extension With MySQL Driver, pdo_mysql Part 4: Using the MySQL Native Driver for PHP, mysqlnd Tutorial is here.