RE: [PHP] MySql help #1
| From: | Lawrence dot Sheed at dfait-maeci dot gc dot ca | Date: | Thu, 02 Aug 2001 07:39:05 +0000 |
| Subject: | RE: [PHP] MySql help #1 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-60866@lists.php.net to get a copy of this message | ||
Sounds like a strange request, what are you trying to do?
I don't think you can do this directly in mysql, but you could build an
array of results in php.
eg something like (crappy code below)
//Grab results
$db = mysql_connect($db_domain, $db_user,$db_password);
mysql_select_db($db_databasename,$db);
$sqlquery="select ID from table1 where condition1";
$result = mysql_query ($sqlstring,$db);
$count=0;
while ($resultset = mysql_fetch_array ($result)) {
$array[$count]=$resultset ["ID"];
$count++;
}
for ($count=0;$count<2;$count++){
"update table1 set field='VALUE' WHERE ID=".$array[$count]";
$result = mysql_query ($sqlstring,$db) or die (mysql_error());
}
-----Original Message-----
From: elias [mailto:elias_bachaalany@yahoo.com]
Sent: August 2, 2001 4:30 PM
To: php-general@lists.php.net
Subject: [PHP] MySql help #1
How can I update only N fields from the database?
usually we do:
UPDATE table1 SET field='VALUE' WHERE condition1
now I want to update fields with a certain condition but only X fields out N
total fields.
ie:
id value
--- -------
1 a
2 b
3 c
4 d
5 e
how can i update such like:
UPDATE table1 SET {only 2 records} value='aa'
so I have any two fields now have the 'aa' value
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net