Re: [PHP] update query not working

2003-02-23 Thread Chris Hayes
print INPUT TYPE=\Submit\ NAME=\Submit\ Value=\Update\/td; print /form; 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

Re: [PHP] update query not working

2003-02-23 Thread Jason Wong
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 INPUT TYPE=\Submit\ NAME=\Submit\ Value=\Update\/td; print td/tdtd/td/tr; print

Re: [PHP] Update query

2002-12-12 Thread Tim Ward
The best way would be to design the table so that it had an item_id field that was an auto-incremented integer and not updateable. It shouldn't be too late to add such a field, then it can be passed from the form as a hidden field (as I assume you're currently doing with $oldItemCode). Tim Ward

Re: [PHP] Update query

2002-12-12 Thread Jason Wong
On Thursday 12 December 2002 17:00, Steve Jackson wrote: How do you update MySQL in the following way? I have designed a form which has all the fields in the database available to edit based on a user query. The query is a field called $ItemCode. If the user wants to change that $ItemCode

RE: [PHP] Update query

2002-12-12 Thread Steve Jackson
It doesn't work in that it doesn't update the database. I have a form which when loaded takes a variable ItemCode from the previous page (which gets the Itemcode from the DB) and puts it into a hidden field which I call oldItemCode, then when I try to update the $ItemCode row in the database with

Re: [PHP] Update query

2002-12-12 Thread Bastian Vogt
Hi, did you echo $query; and put the output into phpmyadmin? Perhaps there's an error message that may help you HTH, Bastian Steve Jackson schrieb: It doesn't work in that it doesn't update the database. I have a form which when loaded takes a variable ItemCode from the previous page

Re: [PHP] Update query

2002-12-12 Thread Jason Wong
On Thursday 12 December 2002 18:48, Steve Jackson wrote: It doesn't work in that it doesn't update the database. I have a form which when loaded takes a variable ItemCode from the previous page (which gets the Itemcode from the DB) and puts it into a hidden field which I call oldItemCode, then

RE: [PHP] update query based on array

2002-12-10 Thread Ford, Mike [LSS]
-Original Message- From: Jason Dulberg [mailto:[EMAIL PROTECTED]] Sent: 09 December 2002 23:52 So you mean do something like: input type=text name=category[15] value=Prep School input type=text name=rank[15] value=30 size=4 input type=checkbox name=rankid[15] value=166

RE: [PHP] update query based on array

2002-12-10 Thread Jason Dulberg
Thanks Mike, that fixed the problem that I had! Jason -Original Message- From: Ford, Mike [LSS] [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 6:21 AM To: 'Jason Dulberg' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] update query based on array -Original Message

Re: [PHP] update query based on array

2002-12-09 Thread Jimmy Brake
not real sure of the setup of the form but if you have mutiple groups of items to be updated then you should make the rank an array -- rank[pid#] you should make all the items -- that are related part of the same group -- by using [] On Mon, 2002-12-09 at 15:06, Jason Dulberg wrote: I am

RE: [PHP] update query based on array

2002-12-09 Thread Jason Dulberg
row has a different ID of course. The update query should only update fields with checked checkboxes. Thanks for your input! Jason -Original Message- From: Jimmy Brake [mailto:[EMAIL PROTECTED]] Sent: December 9, 2002 6:29 PM To: Jason Dulberg Cc: [EMAIL PROTECTED] Subject: Re: [PHP

Re: [PHP] update query based on array

2002-12-09 Thread Jason Wong
On Tuesday 10 December 2002 07:06, Jason Dulberg wrote: I am displaying a list of data (from an sql query) and some of the fields in that list are editable through a form. If the user chooses to edit one or more of the rows of data, they must click on a checkbox to add that row to an update

Re: [PHP] UPDATE Query

2002-09-01 Thread Tony Harrison
What about multiple tables? Can that be done? Mark Charette [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... No, only one db at a time may be updated. The where clauses can contain multiple db. -Original Message- From: Sascha Braun [mailto:[EMAIL

RE: [PHP] UPDATE Query

2002-08-31 Thread Mark Charette
No, only one db at a time may be updated. The where clauses can contain multiple db. -Original Message- From: Sascha Braun [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 31, 2002 7:04 PM To: PHP Mailingliste Subject: [PHP] UPDATE Query I want to know if its possible to update two

RE: [PHP] UPDATE Query works in odbc/Mysql, but fails in odbc/MS Access

2001-12-06 Thread Andrew Hill
mweb, MS points to a datetime issue: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246570 As far as a reference - I'm guessing somewhere on MS's site? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data

Re: [PHP] Update Query - Urgent

2001-10-23 Thread Valentin V. Petruchek
Send your codes to mailing list. If they are not very secret :) - Original Message - From: Srinivasan Ranganathan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 23, 2001 3:21 PM Subject: [PHP] Update Query - Urgent Hi I have a php script generate a sql update

RE: [PHP] Update Query - Urgent

2001-10-23 Thread Niklas Lampén
How about some code to see? Niklas -Original Message- From: Srinivasan Ranganathan [mailto:[EMAIL PROTECTED]] Sent: 23. lokakuuta 2001 15:22 To: [EMAIL PROTECTED] Subject: [PHP] Update Query - Urgent Hi I have a php script generate a sql update statement. when i query the database,

RE: [PHP] Update Query - Urgent

2001-10-23 Thread Nicolas Guilhot
Do you login to the database with a write access or a read only account ?? -Message d'origine- De : Srinivasan Ranganathan [mailto:[EMAIL PROTECTED]] Envoyé : mardi 23 octobre 2001 14:22 À : [EMAIL PROTECTED] Objet : [PHP] Update Query - Urgent Hi I have a php script generate a sql

Re: [PHP] Update Query - Urgent

2001-10-23 Thread Valentin V. Petruchek
What if use mysql_select_db()? - Original Message - From: Srinivasan Ranganathan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 23, 2001 4:22 PM Subject: [PHP] Update Query - Urgent -- Yes, Full Rights! Hi Yes, I do have full rights!

RE: [PHP] Update Query - Urgent

2001-10-23 Thread Mark Roedel
-Original Message- From: Srinivasan Ranganathan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 7:22 AM To: [EMAIL PROTECTED] Subject: [PHP] Update Query - Urgent I have a php script generate a sql update statement. when i query the database, the update doesn't

Re: [PHP] Update Query - Urgent

2001-10-23 Thread Mak
What does the error message say? What sort of error is it? - ycmak - Original Message - From: Mark Roedel [EMAIL PROTECTED] To: Srinivasan Ranganathan [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 23, 2001 9:35 PM Subject: RE: [PHP] Update Query - Urgent -Original

Re: [PHP] Update Query - Urgent

2001-10-23 Thread Beeman
of error is it? - ycmak - Original Message - From: Mark Roedel [EMAIL PROTECTED] To: Srinivasan Ranganathan [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 23, 2001 9:35 PM Subject: RE: [PHP] Update Query - Urgent -Original Message- From: Srinivasan Ranganathan [mailt