No, that was just an exapmle to explain better. Of course this is not the
REAL code. :)
And there are some more thing to do inside while loop.
Thanks.
-afan
> It looks very much as if you did:
>
> update members set member_name = 'N/A' where member_name = null
>
> Nevertheless, I would rather keep null within the database and use 'N/A'
> at
> the presentation level. My rule is that the data in the database
> should
> be in a machine oriented format. For example, I store timestamps, never
> formated dates, numbers as actual numerical datatypes, not as strings,
> though PHP can cope with either. 'N/A' is a way to present that
> information
> to the user, which might even be, for example, language dependant.
>
> On displaying, you could well do:
>
> SELECT member_id, ifnull(member_name,'N/A') FROM members
>
> Satyam
>
>
> ----- Original Message -----
> From: <afan@xxxxxxxx>
> To: <php-general@xxxxxxxxxxxxx>
> Sent: Wednesday, June 14, 2006 11:37 PM
> Subject: can I do this: update table while selecting data from
> table?
>
>
>> Am I allowde to do this:
>>
>> $query = mysql_query("SELECT member_id, member_name FROM members");
>> while($result = mysql_fetch_array($query))
>> {
>> if(empty($result['member_name']))
>> {
>> mysql_query("UPDATE members SET member_name = 'N/A' WHERE member_id =
>> ".$result['member_id']."");
>> }
>> }
>>
>> As far as I know, after "SELECT" query, data are in buffer and I AM able
>> to connect to the same table and do UPDATE, right?
>>
>> Thanks
>>
>> -afan
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
