Re: [PHP-DB] how to update field without using UPDATE query? youare kidding?
In order o update fields without using a UPDATE statement you have to use a cursor. In general, this is how ADO (the technology used by ASP) performs its updates in the manner you outlined below. There are no extensions bundled with PHP of which I am aware that allow you to update data via a cursor. -- bob On Mon, 9 Jun 2003, Steve B. wrote: Hi in asp it lets me say ~get a record into dbrec which is a database object. dbrec['field1'] = 'wow' dbrec.update; is there no way to do this in linux? thats lame if it is then that means my 25 web sites have to be re-written to work on Linux. --- Becoming Digital [EMAIL PROTECTED] wrote: I assume you lack update permissions, which means you probably don't have the other permissions necessary to change data. Assuming you actually do, you could use REPLACE or DELETE followed by INSERT. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Steve B. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, 09 June, 2003 19:29 Subject: [PHP-DB] how to update field without using UPDATE query? how to update field without using UPDATE query? I open the db at a certain ID then set $dbrec['field'] = new value How do you update the db? Thanks -steve - Do you Yahoo!? Free online calendar with sync to Outlook(TM). -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how to update field without using UPDATE query? you are kidding?
I assume that dbrec is an object. There are many classes you can get in PHP that handle database management and manipulation. Check out www.phpclasses.org. I believe everyone's frustration is that the question was not asked properly, you confused PHP with Linux, you insulted the OS of choice for most users here, and you use Winblows. Just find a class that hides all the code from you so you don't have to think about how the update works. The you can do something like: dbrec = new DBClass(); $dbrec-field1='wow'; $dbrec-update(); --- Steve B. [EMAIL PROTECTED] wrote: It sounds like you are crying John. Perhaps you know this function? I'm trying to learn PHP holmes. Keep the insults to yourself and help out if you know the answer. --- John W. Holmes [EMAIL PROTECTED] wrote: in asp it lets me say ~get a record into dbrec which is a database object. dbrec['field1'] = 'wow' dbrec.update; is there no way to do this in linux? thats lame if it is then that means my 25 web sites have to be re-written to work on Linux. Okay, you're still confused. This has nothing to do with Linux. It's PHP vs. ASP. ASP has provided you a function to use instead of making an UPDATE query yourself. Learn some PHP so you can write your own update() query. Don't cry because someone hasn't done it for you already. ---John W. Holmes... Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Mark Weinstock [EMAIL PROTECTED] *** You can't demand something as a right unless you are willing to fight to death to defend everyone else's right to the same thing. *** __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] how to update field without using UPDATE query?
how to update field without using UPDATE query? I open the db at a certain ID then set $dbrec['field'] = new value How do you update the db? Thanks -steve - Do you Yahoo!? Free online calendar with sync to Outlook(TM).
Re: [PHP-DB] how to update field without using UPDATE query?
I assume you lack update permissions, which means you probably don't have the other permissions necessary to change data. Assuming you actually do, you could use REPLACE or DELETE followed by INSERT. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Steve B. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, 09 June, 2003 19:29 Subject: [PHP-DB] how to update field without using UPDATE query? how to update field without using UPDATE query? I open the db at a certain ID then set $dbrec['field'] = new value How do you update the db? Thanks -steve - Do you Yahoo!? Free online calendar with sync to Outlook(TM). -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] how to update field without using UPDATE query? you are kidding?
Hi in asp it lets me say ~get a record into dbrec which is a database object. dbrec['field1'] = 'wow' dbrec.update; is there no way to do this in linux? thats lame if it is then that means my 25 web sites have to be re-written to work on Linux. --- Becoming Digital [EMAIL PROTECTED] wrote: I assume you lack update permissions, which means you probably don't have the other permissions necessary to change data. Assuming you actually do, you could use REPLACE or DELETE followed by INSERT. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Steve B. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, 09 June, 2003 19:29 Subject: [PHP-DB] how to update field without using UPDATE query? how to update field without using UPDATE query? I open the db at a certain ID then set $dbrec['field'] = new value How do you update the db? Thanks -steve - Do you Yahoo!? Free online calendar with sync to Outlook(TM). -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] how to update field without using UPDATE query? you arekidding?
I'm sorry, but that is the most confusing question I've heard in some time. The operating system has nothing to do with your ability to update the DB. That is a user permissions issue. If you're referring to PHP as Linux, I can see where the confusion came from. I'd like to help you. So I can attempt to do that, let's see the ASP code you're trying to convert to PHP. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Steve B. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, 09 June, 2003 22:14 Subject: Re: [PHP-DB] how to update field without using UPDATE query? you are kidding? Hi in asp it lets me say ~get a record into dbrec which is a database object. dbrec['field1'] = 'wow' dbrec.update; is there no way to do this in linux? thats lame if it is then that means my 25 web sites have to be re-written to work on Linux. --- Becoming Digital [EMAIL PROTECTED] wrote: I assume you lack update permissions, which means you probably don't have the other permissions necessary to change data. Assuming you actually do, you could use REPLACE or DELETE followed by INSERT. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Steve B. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, 09 June, 2003 19:29 Subject: [PHP-DB] how to update field without using UPDATE query? how to update field without using UPDATE query? I open the db at a certain ID then set $dbrec['field'] = new value How do you update the db? Thanks -steve - Do you Yahoo!? Free online calendar with sync to Outlook(TM). -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how to update field without using UPDATE query? you are kidding?
in asp it lets me say ~get a record into dbrec which is a database object. dbrec['field1'] = 'wow' dbrec.update; is there no way to do this in linux? thats lame if it is then that means my 25 web sites have to be re-written to work on Linux. Okay, you're still confused. This has nothing to do with Linux. It's PHP vs. ASP. ASP has provided you a function to use instead of making an UPDATE query yourself. Learn some PHP so you can write your own update() query. Don't cry because someone hasn't done it for you already. ---John W. Holmes... Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how to update field without using UPDATE query? you are kidding?
It sounds like you are crying John. Perhaps you know this function? I'm trying to learn PHP holmes. Keep the insults to yourself and help out if you know the answer. --- John W. Holmes [EMAIL PROTECTED] wrote: in asp it lets me say ~get a record into dbrec which is a database object. dbrec['field1'] = 'wow' dbrec.update; is there no way to do this in linux? thats lame if it is then that means my 25 web sites have to be re-written to work on Linux. Okay, you're still confused. This has nothing to do with Linux. It's PHP vs. ASP. ASP has provided you a function to use instead of making an UPDATE query yourself. Learn some PHP so you can write your own update() query. Don't cry because someone hasn't done it for you already. ---John W. Holmes... Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how to update field without using UPDATE query? you are kidding?
Don't take that the wrong way. You've already posted 3-4 messages on here complaining that PHP/Linux doesn't have a dbrec.update function. I am helping out and I do know the answer: create an UPDATE query. If you have 125 fields, then, yeah, it'll be a long query. Nothing says you have to type out the entire thing yourself, though. Loop through your $dbrec array and create the UPDATE query... ---John W. Holmes... Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -Original Message- From: Steve B. [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 11:08 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] how to update field without using UPDATE query? you are kidding? It sounds like you are crying John. Perhaps you know this function? I'm trying to learn PHP holmes. Keep the insults to yourself and help out if you know the answer. --- John W. Holmes [EMAIL PROTECTED] wrote: in asp it lets me say ~get a record into dbrec which is a database object. dbrec['field1'] = 'wow' dbrec.update; is there no way to do this in linux? thats lame if it is then that means my 25 web sites have to be re-written to work on Linux. Okay, you're still confused. This has nothing to do with Linux. It's PHP vs. ASP. ASP has provided you a function to use instead of making an UPDATE query yourself. Learn some PHP so you can write your own update() query. Don't cry because someone hasn't done it for you already. ---John W. Holmes... Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
