Re: [PHP] Update mailing list docs - How to unsubscribe?

On Mon, 23 Jan 2012, Matty Sarro wrote: I have been trying to unsubscribe from this list. I've gone through the directions at http://www.ezmlm.org/ezman/ezman1.html as suggested by http://us.php.net/mailing-lists.php. They don't seem to apply for these lists as written (the method listed for uns

Re: [PHP] update von php 4.4.6 zu 5.2.8

Merlin Morgenstern wrote: Hello everybody, I want to upgrade my system and do face some trouble with pdflib. compile says: Notice: Following unknown configure options were used: --enable-gd-imgstrttf --with-pdflib I guess the gd functionality is enabled now anyway? How about the pdflib? Is

Re: [PHP] Update does not work...but no errors either

Hey DB, Thanks for replying, I did solve it though was running a lot of tests and checking a lot of stuff with the fill before i finally added the database stuff... but forgot to include() the connection file :) Thanks for writing though! Cheers! R -- PHP General Mailing List (ht

Re: [PHP] Update does not work...but no errors either

On Sat, May 31, 2008 at 4:23 AM, Ryan S <[EMAIL PROTECTED]> wrote: > > > Hey, > > This is my code: > == > $update_sql="update greetings_final set > heading='$heading',message='$message',signature='$signature',font_size='$font_size',font_

Re: [PHP] UPDATE and redirect

Marcelo Wolfgang wrote: and what if $_GET['id'] is something like "1; DROP TABLE tb_emails;" ?? SQL injection just waits to happen Something I just thought, he could do a drop table inside an update statement ? because the query is : UPDATE tb_emails SET bol_active = $action WHERE auto_id

Re: [PHP] UPDATE and redirect

and what if $_GET['id'] is something like "1; DROP TABLE tb_emails;" ?? SQL injection just waits to happen Something I just thought, he could do a drop table inside an update statement ? because the query is : UPDATE tb_emails SET bol_active = $action WHERE auto_id = $id so if he changed t

Re: [PHP] UPDATE and redirect

2007. 04. 11, szerda keltezéssel 17.36-kor Marcelo Wolfgang ezt írta: > > and what if $_GET['id'] is something like > > "1; DROP TABLE tb_emails;" > > ?? > > > > SQL injection just waits to happen > > I think tha tit will be too much of a hacker effort just to kill a table > of contact emails,

Re: [PHP] UPDATE and redirect

Marcelo Wolfgang wrote: and what if $_GET['id'] is something like "1; DROP TABLE tb_emails;" ?? SQL injection just waits to happen I think tha tit will be too much of a hacker effort just to kill a table of contact emails, and also he will have to guess ( is there other way ? ) the table na

Re: [PHP] UPDATE and redirect

and what if $_GET['id'] is something like "1; DROP TABLE tb_emails;" ?? SQL injection just waits to happen I think tha tit will be too much of a hacker effort just to kill a table of contact emails, and also he will have to guess ( is there other way ? ) the table name, but just to be on a s

Re: [PHP] UPDATE and redirect

2007. 04. 11, szerda keltezéssel 16.57-kor Fredrik Thunberg ezt írta: > marcelo Wolfgang skrev: > > Hi all, > > > > I'm new to this list and new to php programming so sorry if I do > > something wrong here :) > > > > Ok, now to my problem. > > > > I've created a query to update a mysql db, and

Re: [PHP] UPDATE and redirect

Hi, It's fixed, I think the problem where at the '==' ... I have to remember that in PHP this is like ActionScript. Also, what if $_GET['act'] is neither 'a' or 'd'? Again, what if $_GET['id'] is null? The only way to not be 'a' or 'd' or to be null is if someone mess with url, which shoul

Re: [PHP] UPDATE and redirect

marcelo Wolfgang skrev: Hi all, I'm new to this list and new to php programming so sorry if I do something wrong here :) Ok, now to my problem. I've created a query to update a mysql db, and it isn't working, and it's not throwing me any errors, so I need some help to figure out what's wro

Re: [PHP] UPDATE and redirect

marcelo Wolfgang wrote: Hi all, I'm new to this list and new to php programming so sorry if I do something wrong here :) Ok, now to my problem. I've created a query to update a mysql db, and it isn't working, and it's not throwing me any errors, so I need some help to figure out what's wro

Re: [PHP] Update function for content of existing CD?

Frank Arensmeier wrote: > Hello all. > > I am looking for some ideas on how to design / structure a script which > checks for updates on files on a existing CD ROM. > > Every week, I generate content for a CD ROM containing a large number of > html pages and PDF files (the CD is distributed to 20

Re: [PHP] Update or add?

Brian Dunning wrote: I have a table where I want to update each record with today's date as it's hit, or add the record if it's not in there: +--+-++ | id | creation_date | last_hit | +--+-++ I'm trying to do this with a min

Re: [PHP] Update or add?

Hi All, there is not-so-used format of SQL format that is INSERT INTO table SET col1=data1, col2=data2... ON DUPLICATE KEY UPDATE col1=data1, col2=data2...; you have to define a primary or unique key in the table and all will work well. for more info http://dev.mysql.com/doc/refman/4.1/en/

Re: [PHP] Update or add?

Good advice , Thank you! -- Paul Nowosielski Webmaster On Friday 30 June 2006 15:45, Adam Zey wrote: > Paul Nowosielski wrote: > > On Friday 30 June 2006 14:37, Brian Dunning wrote: > >> I have a table where I want to update each record with today's date > >> as it's hit, or add the record if

Re: [PHP] Update or add?

Paul Nowosielski wrote: On Friday 30 June 2006 14:37, Brian Dunning wrote: I have a table where I want to update each record with today's date as it's hit, or add the record if it's not in there: +--+-++ | id | creation_date | last_hit | +--+-

Re: [PHP] Update or add?

On Friday 30 June 2006 14:37, Brian Dunning wrote: > I have a table where I want to update each record with today's date > as it's hit, or add the record if it's not in there: > > +--+-++ > > | id | creation_date | last_hit | > > +--+-+-

RE: [PHP] Update or add?

> > I have a table where I want to update each record with today's date > as it's hit, or add the record if it's not in there: > > +--+-++ > | id | creation_date | last_hit | > +--+-++ > > I'm trying to do this with a minimu

Re: [PHP] Update site through email

Nathanael Merrill wrote: I will be on vacation from June 26th through July 17th. I will have limited access to email and will get back to you as soon as I can. Thank you. - nathanael merrill You just made the list Nathanael. -- John C. Nichel IV Programmer/System Admin (ÜberGeek) Dot Com Ho

Re: [PHP] Update site through email

Jim Moseby wrote: Hy guys I'd like to know if there is a way to update a site through sending an email. Something like this, you send an email and the body of the email substitutes a text you use in your site. Igreat apreciate any help since I couldn't find anything on this topic. How much time

Re: [PHP] Update site through email

Hello, At my last job there were several companies that would send us text invoices by email. These email accounts were on a Linux box, and when the mail would come in the message was sent to scripts via STDIN. I'm not sure HOW it was done but I know that it CAN be done. I would be concerned abou

RE: [PHP] Update site through email

> > Hy guys I'd like to know if there is a way to update a site through > sending an email. Something like this, you send an email and the body > of the email substitutes a text you use in your site. Igreat apreciate > any help since I couldn't find anything on this topic. How much time did you s

Re: [PHP] Update table to get consecutive Primary keys

On Thursday 08 June 2006 23:58, Antonio Bassinger wrote: > Hi All! > > I've a MySQL table: > > table (id INT NOT NULL AUTO_INCREMENT, > flag TINYINT NOT NULL, > msgID VARCHAR(30) NOT NULL, >

Re: [PHP] Update table to get consecutive Primary keys

Antonio Bassinger wrote: Hi All! I've a MySQL table: table (id INT NOT NULL AUTO_INCREMENT, flag TINYINT NOT NULL, msgID VARCHAR(30) NOT NULL, msgName VARCHAR(30),

Re: [PHP] update blues

On Fri, 2005-05-20 at 23:54, Jim & Sara Feldman wrote: > Warning: session_start(): Cannot send session cookie - headers > already sent by (output started at > /Library/WebServer/Documents/testit/Logsafe_project/db_fns.php:212) > in /Library/WebServer/Documents/testit/Logsafe_project/member.php o

Re: [PHP] update blues

Jim & Sara Feldman wrote: Hi: I have a partially finished app using PHP and MySQL that runs on Mac G4 running System 10.3.9. Undoubtedly, I upgraded too many things all at the same time. Something broke. PHP and MySQL are both running. I can use the latest phpMyADMIN and everything is there

Re: [PHP] Update db with $_POST

On Wed, 2005-03-16 at 16:50 +1000, Ligaya Turmelle wrote: > assuming you are using PEAR DB - > > $result =& $db->query("UPDATE items SET (item_name, item_desc, > item_price, extraprice) VALUES (?,?,?,?) WHERE item_id = 3", > array($_POST['title'], $_POST['description'], $_POST['price'], > $_PO

Re: [PHP] Update db with $_POST

assuming you are using PEAR DB - $result =& $db->query("UPDATE items SET (item_name, item_desc, item_price, extraprice) VALUES (?,?,?,?) WHERE item_id = 3", array($_POST['title'], $_POST['description'], $_POST['price'], $_POST['extraprice'])); if (PEAR::isError($result)) { echo "Error: There

Re: [PHP] update of mysql to 4.1

Peter, I have done this on redhat 7 using an rpm to go from mysql 3.x to 4.x beta in the past and it worked fine without recompiling php. Of course I would try to test this on a non-production server first in case of any serious problems. If you do have to recompile php for some reason don't fo

Re: [PHP] update of mysql to 4.x

Peter wrote: sorry, i googled again, read nearly every post wich containes mysql and upgrade but i can't find a useful answer in this list. perhaps its me... so my question is still the same, would i have to recompile php or not peter @NG what means need? nobody needs an internet,using mysql4 wou

Re: [PHP] update of mysql to 4.x

Peter wrote: sorry, i googled again, read nearly every post wich containes mysql and upgrade but i can't find a useful answer in this list. perhaps its me... so my question is still the same, would i have to recompile php or not No, you don't. However, mysql >= 4.1 uses new authentication protoco

Re: [PHP] update of mysql to 4.x

sorry, i googled again, read nearly every post wich containes mysql and upgrade but i can't find a useful answer in this list. perhaps its me... so my question is still the same, would i have to recompile php or not peter @NG what means need? nobody needs an internet,using mysql4 would just makes

Re: [PHP] update of mysql to 4.x

Peter wrote: Hi, i'm thinking of updating my mysql-server from 3.23 to 4.1.10, and i can't find any serious information if i would have to rebuild php too. anybody tryed this already?? system: debian linux, apache 1.3.31, php 4.3.9, mysql 3.23.52 thanks peter Please don't spam the list with multi

Re: [PHP] UPDATE

Steve Marquez wrote: I am trying to insert information into the database, have it automatically place an ID Number, then update that particular record and replace the word "delete" with the link. The "mysql_insert_id()" does seem to be working. It does put in an id number of "0" However, the code i

Re: [PHP] UPDATE

On Wed, 15 Dec 2004 10:10:22 -0600, Steve Marquez <[EMAIL PROTECTED]> wrote: > I am trying to insert information into the database, have it automatically > place an ID Number, then update that particular record and replace the word > "delete" with the link. `delete` is a reserved word. Try wrappi

Re: [PHP] UPDATE

Quoting Steve Marquez <[EMAIL PROTECTED]>: > I am trying to insert information into the database, have it automatically > place an ID Number, then update that particular record and replace the word > "delete" with the link. > > The "mysql_insert_id()" does seem to be working. It does put in an id

Re: [PHP] Update mysql.so problems

Posted this yesterday, still having problems. I've used various combinations with --with-mysql. I removed all the old mysql binaries and libs from /usr/lib, /usr/include and /usr/bin. I removed the old mysql.so from /usr/lib/php4/ I even went as far as upgrading to PHP5. It is still using the

Re: [PHP] UPDATE...

On Sunday 11 July 2004 09:28, Harlequin wrote: > Jason. Thanks very much. Truly...! I looked at it, stared at it, growled at > it and then finally realised about 30 seconds before I raed your post: > > SET Comments='$Comments', You also have the date and column-name switched: ... $UserMail=Use

Re: [PHP] UPDATE...

Laugh...? I nearly wet mesen...! Jason. Thanks very much. Truly...! I looked at it, stared at it, growled at it and then finally realised about 30 seconds before I raed your post: SET Comments='$Comments', What an idiot...! Hey - thanks for your patience mate. I don't suppose you'd care to hel

Re: [PHP] UPDATE...

On Sunday 11 July 2004 09:00, Harlequin wrote: > I did as you suggest and I get a rather generic response: > > Sorry, Your Request Could Not Be Executed: You have an error in your SQL > syntax. Check the manual that corresponds to your MySQL server version for > the right syntax to use near 'Littl

Re: [PHP] UPDATE...

Jason. Thanks for pointing out the obvious - I should have trapped errors. Thanks you. I did as you suggest and I get a rather generic response: Sorry, Your Request Could Not Be Executed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the

Re: [PHP] UPDATE...

On Sunday 11 July 2004 08:33, Harlequin wrote: > I'm hitting the submit button at the bottom of the page and getting > redirected OK to the next page with no errors but when I query the database > directly it isn't updating. Should you be getting errors if there is a problem? IOW *are* you puttin

Re: [PHP] UPDATE...

Sorry Jason. I'm hitting the submit button at the bottom of the page and getting redirected OK to the next page with no errors but when I query the database directly it isn't updating. -- - Michael Mason Arras People www.arraspeople.co.uk --

Re: [PHP] UPDATE...

On Sunday 11 July 2004 08:20, Harlequin wrote: > I have a page that successfully calls data from the database based on > userID & Password combo. No Problems there eh... I display the information > in a form, the user is supposed to be updating this information and then > hitting submit to update

Re: [PHP] update count

If your table has a primary key, or auto increment field works well and is quick. > What is the best way to only do an update if it going to update only one > row? > I want to protect my code so that it won't accidentally update more than > one row. > I can do a select first but there must be an e

Re: [PHP] update count

What is the best way to only do an update if it going to update only one row? You don't say what database you're using. The general way is to use a unique key in the WHERE clause. UPDATE tablename SET foo=1 WHERE id=123 MySQL also lets you use a LIMIT clause that will either limit the number o

Re: [PHP] update count

On Wed, 16 Jun 2004 09:40:52 -0400, Bob Lockie <[EMAIL PROTECTED]> wrote: > > What is the best way to only do an update if it going to update only one > row? You don't say what database you're using. The general way is to use a unique key in the WHERE clause. UPDATE tablename SET foo=1 WHERE

Re: [PHP] update count

Bob Lockie wrote: What is the best way to only do an update if it going to update only one row? I want to protect my code so that it won't accidentally update more than one row. I can do a select first but there must be an easier way. :-) UPDATE thisDB.thisTable SET thisTable.thisColumn = 'thisV

RE: [PHP] update count

[snip] What is the best way to only do an update if it going to update only one row? I want to protect my code so that it won't accidentally update more than one row. I can do a select first but there must be an easier way. :-) [/snip] Do the update with conditions (this is a SQL question) UPD

Re: [PHP] Update problem

To reply to the original post (sorry for the confusion): Maldiv wrote: Hello, I have a php update form which use $_POST and $_GET too. I call the update like this update.php?id=1 And after the user submit the form with new data I use command like this: UPDATE table SET id=$_POST['id'] WHERE $_GET['

Re: [PHP] Update problem

That will work, but the below is really supposed to work. I use it in my apps. Blake Schroeder wrote: Put a hidden field in your form named id. -Blake Mattias Thorslund wrote: Probably with Blake Schroeder wrote: The form that is being submitted can only be a POST or a GET not both example:

Re: [PHP] Update problem

Put a hidden field in your form named id. -Blake Blake Schroeder wrote: The form that is being submitted can only be a POST or a GET not both example: How can you do both? -Blake Maldiv wrote: Hello, I have a php update form which use $_POST and $_GET too. I call the update like this update.ph

Re: [PHP] Update problem

Blake Schroeder wrote: The form that is being submitted can only be a POST or a GET not both example: How can you do both? Hope that answers your question ;-) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Update problem

The form that is being submitted can only be a POST or a GET not both example: How can you do both? -Blake Maldiv wrote: Hello, I have a php update form which use $_POST and $_GET too. I call the update like this update.php?id=1 And after the user submit the form with new data I use command lik

Re: [PHP] update mysql using radio button

Right. (oops) > From: "Daniel Clark" <[EMAIL PROTECTED]> > >> if($row->club_member >> ='N'){echo 'CHECKED';}?>> > > =='N', you mean. :) > > ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] update mysql using radio button

From: "Daniel Clark" <[EMAIL PROTECTED]> > club_member > ='N'){echo 'CHECKED';}?>> =='N', you mean. :) ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] update mysql using radio button

al Message- From: Daniel Clark [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 1:14 PM To: Matt Newell Cc: [EMAIL PROTECTED] Subject: Re: [PHP] update mysql using radio button I think you need Values for the radio buttons. club_member ='N'){echo 'CHECKED';}?>&g

Re: [PHP] update mysql using radio button

I think you need Values for the radio buttons. club_member ='N'){echo 'CHECKED';}?>> > > hello all - > > i'm having a problem getting an UPDATE to work with radio buttons and > i'm not sure where it's gone wrong. the initial values are being grabbed > properly, but unfortunately they don't want

RE: [PHP] update mysql using radio button

[snip] i'm having a problem getting an UPDATE to work with radio buttons and i'm not sure where it's gone wrong. the initial values are being grabbed properly, but unfortunately they don't want to get updated. the regular text form values update just fine. would appreciate some help. the html:

Re: [PHP] Update Multiple Records From Form

On May 28, 2004, at 3:50 AM, Ford, Mike [LSS] wrote: On 28 May 2004 04:47, Albert Padley wrote: I feel I'm so close. I have a form with multiple database records with a checkbox to indicate which records to update set up like so: $name = "ed[" . $row['id'] . "]"; Each text input is set up like so:

RE: [PHP] Update Multiple Records From Form

On 28 May 2004 04:47, Albert Padley wrote: > I feel I'm so close. > > I have a form with multiple database records with a checkbox to > indicate which records to update set up like so: > > $name = "ed[" . $row['id'] . "]"; > > > > Each text input is set up like so: > > > > On the processin

Re: [PHP] update mysql from php web page

Something I like to do during troubleshooting is to have the page display the SQL statement I'm processing. Something like: print sql_query ; That was I can verify all the parameters are correct. Do you have autocommit ON? Or need to pass a commit statement? Daniel Clark > Of course, I d

Re: [PHP] update mysql from php web page

"Daniel Clark" <[EMAIL PROTECTED]> wrote on 04/07/2004 10:17:36 AM: > For the submit button to work it has to be in a form. > > > > > > Hope this helps. > > Daniel Clark Of course, I didn't notice I left that line out of my code, although I did remember to put in the closing form tag. B

Re: [PHP] update mysql from php web page

For the submit button to work it has to be in a form. Hope this helps. Daniel Clark > > ... more code ... > > endif; > ?> > > > - > > I don't see any reason for the submit button to not work at all. What > should I look for now? > Thank

Re: [PHP] update mysql from php web page

"Daniel Clark" <[EMAIL PROTECTED]> wrote on 04/06/2004 03:27:34 PM: > I think you need a WHERE clause for the UPDATE, otherwise it will update > ALL the records. > > e.g. WHERE OwnerName='$result' > > Then perhaps a redirect to another page. Thanks for the reminder. I set that, and found the p

Re: [PHP] update mysql from php web page

Chip Wiegand wrote: I have an existing web page that pulls some data and displays it in form input fields. I would like to add the ability to edit those fields and submit the changes to the server, but have been unsuccessful. What bit of code do I need to add to the existing code? This is the ex

Re: [PHP] update mysql from php web page

I think you need a WHERE clause for the UPDATE, otherwise it will update ALL the records. e.g. WHERE OwnerName='$result' Then perhaps a redirect to another page. > I probably need to use if(isset($submit)): and an update statement, but my > attempt just causes the web page to display completel

Re: [PHP] Update issue - more then likely simple problem

Thankyou i did not know that command existed! so simple cheers "Eugene Lee" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Thu, Dec 18, 2003 at 01:39:57PM +1100, Eric Holmstrom wrote: > > > > What im trying to do is read the information from a field in a table called > > PARTNO.

Re: [PHP] Update issue - more then likely simple problem

On Thu, Dec 18, 2003 at 01:39:57PM +1100, Eric Holmstrom wrote: > > What im trying to do is read the information from a field in a table called > PARTNO. Then add RU to the front of whatever is in the PARTNO field. > > So far i have this. > > //connect details rarara > //query > $query= "SELECT

Re: [PHP] update password cookie

--- John Kaspar <[EMAIL PROTECTED]> wrote: > I'm just storing its hash. Then comparing it to the database hash. > Is that bad? Yes, but the risk is not so much that the user's password is in danger of being acquired, but rather than this step is not necessary to impersonate the user. This hash of

RE: [PHP] update password cookie

John Kaspar on Thursday, September 18, 2003 4:05 PM said: > I'm just storing its hash. Then comparing it to the database hash. > Is that bad? Is there a good write-up somewhere discussing > authentication techniques that you could recommend? Oh I should respond to

RE: [PHP] update password cookie

John Kaspar on Thursday, September 18, 2003 4:05 PM said: > Yahoo makes you reenter your password every time you reopen your > browser. I'll check other sites though. Thanks for the advice. As it should. You don't want to store password information in a cookie, th

Re: [PHP] update password cookie

I'm just storing its hash. Then comparing it to the database hash. Is that bad? Is there a good write-up somewhere discussing authentication techniques that you could recommend? Yahoo makes you reenter your password every time you reopen your browser. I'll check other sites though. Thanks

Re: [PHP] update password cookie

--- John Kaspar <[EMAIL PROTECTED]> wrote: > My question is - how do I update the password cookie without having to > ask whether or not they want to remember it again? How can I find out > when the current cookie expires? First, I hope you're not storing a password in a cookie, since it sounds

Re: [PHP] "update" question [T20030602013J]

Whenever I sign up to a new news service/website or the like, I give them their own alias at my domain, so i can see how my email address is used ;o) Hence the [EMAIL PROTECTED] Hate spammers. No need. Bix. "Ernest E Vogelsinger" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > At

Re: [PHP] "update" question [T20030602013J]

At 21:41 02.06.2003, you said: [snip] >This is an automatic reply to acknowledge that your message has been >received. PLEASE DO NOT REPLY TO THIS MESSAGE. > >-- > >Dear [EMAIL PROTECTED

Re: [PHP] "update" question

At 21:12 02.06.2003, Matt Hedges said: [snip] >Hello, I am new to PHP and would greatly appreciate any help. > >I am building a webpage for my sister's sorority- http://olemissddd.com. I >have built a page that allows them to update the officers each year- >

Re: [PHP] Update to DB

Kalle Saarinen wrote: Hello, I was just wondering how to update data to database from html text field. I have a form that retrieves data from dbase and put's values into text field in a web page. I want to be able to modify data and then save it dbase by hitting save button (also form object). i

RE: [PHP] Update to DB

[snip] I was just wondering how to update data to database from html text field. Anyone know what is the proper way to do this? [/snip] The action for your form can contain an SQL UPDATE statement where the values in the database are updated with the values in the form. Fairly simple. Here is an

Re: [PHP] Update Status Question

Hi, Thursday, March 13, 2003, 6:10:29 AM, you wrote: MW> Hello: MW> I have this line: MW> $sql = "Update Members Set Active='Y' where Username = '$_GET[UN]' And MW> ActiveCode = '$_GET[ID]'"; MW> Is there a php function that will return true or false or something when MW> this is processed. I.E

Re: [PHP] Update MD5 Field

Run the following SQL query: update TABLE set code = md5(concat(name,email)) Dani Matielo wrote: Hello, everybody my problem is the following: I just imported a csv file to a MySQL database that contains name and email fields. It has about 9k lines on it and I need a new field that orinally didn'

Re: [PHP] update query not working

On Monday 24 February 2003 06:56, Peter Gumbrell wrote: > I wonder if anyone can see why the following code is not working. this is > taken from a larger functions, the rest of which seems to be working well: > > print ""; > print ""; > > print ""; > print ""; > if ($_POST['Update']) [snip] print

Re: [PHP] update query not working

print ""; print ""; if ($_POST['Update']) { print "updated!!"; } I do not see the statement "updated!!!" printed, but I cannot see anything wrong with my syntax. Any help would be appreciated. You are looking for a value, where the array is of the form $_POST['form_element_NAME'='form_element

Re: [PHP] update to table errors/strange things happen

re out why my update statement updates all records if someone retypes the same value in the form though - Original Message - From: "Guru Geek" <[EMAIL PROTECTED]> To: "Sunfire" <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 12:08 PM Subject: Re: [PHP]

RE: [PHP] Update row problems

> Sent: 27. tammikuuta 2003 15:32 > To: PHP General; Steve Jackson > Subject: Re: [PHP] Update row problems > > > what version of PHP? try $HTTP_POST_VARS instead. > > Tim Ward > http://www.chessish.com > mailto:[EMAIL PROTECTED] > - Original Message - > Fr

Re: [PHP] Update row problems

what version of PHP? try $HTTP_POST_VARS instead. Tim Ward http://www.chessish.com mailto:[EMAIL PROTECTED] - Original Message - From: Steve Jackson <[EMAIL PROTECTED]> To: PHP General <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 1:14 PM Subject: RE: [PHP] Update

RE: [PHP] Update row problems

e- > From: Tim Ward [mailto:[EMAIL PROTECTED]] > Sent: 27. tammikuuta 2003 14:57 > To: Steve Jackson > Subject: Re: [PHP] Update row problems > > > sounds like $_POST[""catorder"] isn't an array - if > you're posting to the same page you need

Re: [PHP] Update row problems

your query needs to be inside the foreach loop so that it runs for every item, at the moment it just runs after you've scanned through all the items so just does the last one. Tim Ward http://www.chessish.com mailto:[EMAIL PROTECTED] - Original Message - From: Steve Jackson <[EMAIL PRO

Re: [PHP] update more "same" fields at the same time

At 14:29 15-1-03, you wrote: > not with the same data > You can put your data and the primary keys in arrays and exec a loop but the data[0] must be the data for the id[0], data[1] must be the data for id[1] etc. The loop should be something like this: for (int $i=0; $i<=total_records_select_re

Re: [PHP] update more "same" fields at the same time

Simon wrote: >>with the same data or not? >> > > not with the same data > You can put your data and the primary keys in arrays and exec a loop but the data[0] must be the data for the id[0], data[1] must be the data for id[1] etc. The loop should be something like this: for (int $i=0; $i<=total_

Re: [PHP] update more "same" fields at the same time

> with the same data or not? > not with the same data -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] update more "same" fields at the same time

Simon wrote: If you want to update all the records that have subcat = $_GET[a] with the same values then you can do somethink like this: $subcat = $_POST['a']; $qsubcat = $_POST['subcat']; "update tables set field1=$_POST['textfield'],field2='$_POST['textfield1']' where subcat='$qsubcat'" I do

Re: [PHP] update more "same" fields at the same time

> If you want to update all the records that have subcat = $_GET[a] with > the same values then you can do somethink like this: > > $subcat = $_POST['a']; > $qsubcat = $_POST['subcat']; > > "update tables set > field1=$_POST['textfield'],field2='$_POST['textfield1']' where > subcat='$qsubcat'" > >

Re: [PHP] update more "same" fields at the same time

Simon wrote: >>What do you mean with "update more "same" fields at the same time"?Can >>you give us an example? >> >>Gvre >> > > > > > > $query1 = "SELECT * FROM table where subcat = $_GET[a]"; > > $result1 = mysql_query($query1); > > while($row = mysql_fetch_object($result1)) >

Re: [PHP] update more "same" fields at the same time

Simon wrote: >>What do you mean with "update more "same" fields at the same time"?Can >>you give us an example? >> >>Gvre >> > > > > > > $query1 = "SELECT * FROM table where subcat = $_GET[a]"; > > $result1 = mysql_query($query1); > > while($row = mysql_fetch_object($result1)) > > { > > ?> > > >

Re: [PHP] update more "same" fields at the same time

> What do you mean with "update more "same" fields at the same time"?Can > you give us an example? > > Gvre > now i want to change values of texfields and update them back to mysql. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.n

Re: [PHP] update more "same" fields at the same time

Simon wrote: Hi, I have table with six records in it. I can use "while" to display them all, but in form. Is there any way I can edit all six records, and update them all with one submit. TNX What do you mean with "update more "same" fields at the same time"?Can you give us an example? Gvre

Re: [PHP] update more "same" fields at the same time

"Chris Hayes" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > for [each $key, $value in $_POST] >{if (! strpos('field',$key)==false) >{ $key=explode('__',$key); > $ID=$key[1]; > mysql_query(UPDATE mytable SET WH

  1   2   >