fenway

Sorry, my bad about the parens.... try: $query = "SELECT * FROM books WHERE title LIKE '%$posted%' AND zip = '$zip' AND city = '$city' AND state = '$state' AND country = '$country' ORDER BY ( zip = '$zip' ) DESC, ( city = '$city' ) DESC, ( state = '$state' ) DESC, ( country = '$country' ) DESC";

No, don't report -- check with echo() statements that you're getting where you expect first.

$result is a recordset... echo mysql_result( $result, 0 0 )

Yes, you can do this: $query = "SELECT * FROM books WHERE title LIKE '%$posted%' AND zip = '$zip' AND city = '$city' AND state = '$state' AND country = '$country' ORDER BY ( zip = '$zip' DESC, city = '$city' DESC, state = '$state' DESC, country = '$country' DESC )";

As per the manual: "If the return set has no rows, SUM() returns NULL." Try: SUM( IFNULL( t2.salary, 0 ) ) as t2total

Sigh... I wish ONLY_FULL_GROUP_BY was part of the default SQL mode.

Your last problem was a PHP issue... this maybe as well. You need to check that you're actually getting into the block that deletes from the DB -- and that the query runs.

Please don't mark topic "solved" unless you post the solution for the benefit of others.

I see the two commas. But how do I get to change that. Where does the line come from? mySQL? should I change somethin in the database or does the error come from wp? MySQL is being told to run a query by WP -- so you'd have to figure out which file is doing it, but this sounds ilke an error on their part.

I can only guess what you mean by "this" and "it"... mysql won't let you automatically query EVERY field in a table. That's what full-text is for.

What was wrong with the supplied code?

Drop all those backticks and you won't get any syntax errors. Then you need to move some conditions on the B table to the ON clause -- possibly all of them (untseted) SELECT count(*) FROM cpLinkedProducts as A left join cpProductsValues as B ON (A.id_product = B.id_product AND B.id_productfield = '2' ) WHERE A.id_category = '21' AND (`B.value` LIKE 'a%' OR B.value LIKE 'b%' OR B.value LIKE 'c%');

Please echo the sql query and post it here so that we can see why it doesn't work....

No longer the default as of version 5.

I'm confused about fletch and plank -- what do those mean? why are there booleans being stored in INT columns?

Since we don't know your table structure, we can't guess.

You could do this with the I_S tables in v5, but you'll need to clean it up in php anyway, so why not just start there/

The query you're using to search.

I'm so very confused... your grouping by job_id, not user_id?

It sounds like you're checking the left joined table's fields in the where clause, which would have been NULLed out, so that might explain it... hard to tell without table prefixes.

Very close -- but you really should name those uid fields "user_uid" to make it clear: SELECT u.first, u.last FROM users AS u LEFT JOIN resp AS r ON r.uid = u.uid WHERE r.uid IS NULL;

Yeah, it's a burtal process.

Could you elabortate a bit more?

You need to use a transaction table... or you can cheat with myisam tables in a variety of ways.

Actually, you should jeft join and use IFNULL to decide.