on 1/2/04 12:40 PM, Jeremy March wrote:
> What language are you using? It's not clear from your example what language
> you're using (no "$"s, but you also forgot to increment your array so?), so
> I'll give you an example in PHP:
You can still do better than that. IN will be more readable than a bunch of WHERE's.
Also, in your example, you forgot to quote the names in MySQL. Try:
> $query_string = implode("', ', $yourarray);
> mysql_query("UPDATE users SET status = 'no' WHERE name IN ('$query_string')");
--
Bob
IQ2GI5SCP2
Things You Don't Hear Every Day, #'s 16 and 17:
A professor: "It's all right if you come to class high."
A(nother) professor: "I think base 16 is cool."
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
