Jessica

What does "doesn't work" mean? You only posted 2 lines of code so we can't tell. Does the query run or fail? Does it work in mysql directly or not? Did you echo the query to see if the search term is filled in?

You should be able to just select all users, if you need to email every user. Are you using a class like PHPMailer?

for one thing, the list is not a list of who did it, it is a list of ideas with the names being who suggested it. Blackjack is already on it, so there's nothing to add. Secondly, pikachu is being facetious and implying you're on a "list" of something. Troublemakers, etc.

This should be added to the list of ideas sticky!

Then you're editing the wrong file or not uploading the file.

Yeah I've seen in the past few weeks a dozen newbies think signatures are part of the posts. Can we use CSS to make the line darker?

In your code in your first post, there is no $a. So you will always be setting $set = 0.

There is still no syntax error in that file.

What is $a?

You should use descriptive aliases, a1, a2 and a3 don't mean anything. Either take out the aliases, or use them on the fields once you've made them.

On this forum you can post your code in special tags so it formats correctly. That is part of my signature however and wasn't to you directly. *SMH*

http://dev.mysql.com/doc/refman/5.0/en/update.html

Uhm, there are no jokers in Blackjack.

Try Select user, homes from tbl group by user order by homes DESC

Ditto.

I think it would be Select distinct user, homes from tbl group by user order by homes

What's the difference between your strings and ALL the ones in the second link?

What have you coded so far?

What DO you want? Why are you selecting the other variable when there is more than one match?

That is the correct result - the owner LordDougy for example is distinct for homes 30, 23, 20.

http://us2.php.net/manual/en/language.types.string.php http://us2.php.net/manual/en/language.types.string.php#language.types.string.parsing

Well, you have preg_match then if... Also if you read the forum a lot you should know to use code tags.

Did you read the sticky we have on that error?

Post the actual error.