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 ""; > print ""; > > print ""; > print ""; > if ($_POST['Update']) [snip] print

Re: [PHP] update query not working

2003-02-23 Thread Chris Hayes
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 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, t

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 pag

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 t

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 $ItemCo

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 ht

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 >

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: > > > > > > Doesn't that create 2 additional arrays though? Yes -- but how else are you going to get multiple values for each name from your form to

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 "updat

RE: [PHP] update query based on array

2002-12-09 Thread Jason Dulberg
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] update query based on array > > > not real sure of the setup of the form but if you have mutiple grou

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 displ

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:[

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 d

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 Beeman
y? 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

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 Su

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 does

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 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 upd

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 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