re: Change from loop to single query

[Jeremy March]

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:

$query_string = implode(" OR name = ", $yourarray);
mysql_query("UPDATE users SET status = no WHERE name = $query_string;");
_________________________________________________________________
Take advantage of our limited-time introductory offer for dial-up Internet 
access. http://join.msn.com/?page=dept/dialup

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]