Change database values

This is a discussion on Change database values within the alt.comp.lang.php forums, part of the PHP Programming Forums category; I have a script that outputs all the values on a certain row in a MySQL table. I would to ...


Go Back   Usenet Forums > PHP Programming Forums > alt.comp.lang.php

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 10-27-2003
TresWBL
 
Posts: n/a
Default Change database values

I have a script that outputs all the values on a certain row in a MySQL
table. I would to be able to change those values. I don't need any login
authentication or anything, I just want the simplest and easiest way to edit
the values. I want to be able to edit multiple ones at a time. What do you
guys think would be the best way to go about doing that? Thanks.

--
TresWBL
telconstar99@NOSPAMhotmail.com


Reply With Quote
  #2 (permalink)  
Old 10-28-2003
pouzzler
 
Posts: n/a
Default Re: Change database values

MySql function UPDATE
like this


UPDATE $tablename ($field1, $field2,....) VALUES ($value1, $value2,
....) WHERE (primarykey = $key_to_update)


"TresWBL" <telconstar99@NOSPAMhotmail.com> wrote in message news:<rjZmb.480$pH3.446@newssvr22.news.prodigy.com >...
> I have a script that outputs all the values on a certain row in a MySQL
> table. I would to be able to change those values. I don't need any login
> authentication or anything, I just want the simplest and easiest way to edit
> the values. I want to be able to edit multiple ones at a time. What do you
> guys think would be the best way to go about doing that? Thanks.

Reply With Quote
  #3 (permalink)  
Old 10-30-2003
TresWBL
 
Posts: n/a
Default Re: Change database values

pouzzler wrote:
> MySql function UPDATE
> like this
>
>
> UPDATE $tablename ($field1, $field2,....) VALUES ($value1, $value2,
> ...) WHERE (primarykey = $key_to_update)
>


I don't quite follow. What is field1 and 2? Are those column names? value1
and 2 would be what I wanted it changed to? And key would be the what? The
column I wanted to update? Thanks.

--
TresWBL
telconstar99@NOSPAMhotmail.com


Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:02 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0