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

[PHP] update query not working

2003-02-23 Thread Peter Gumbrell
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']) { print "updated!!"; $rank = $HTTP_POST_VARS['rank']; $title_new = $HTTP_POST_VARS['ti

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
Tim Ward http://www.chessish.com mailto:[EMAIL PROTECTED] - Original Message - From: Steve Jackson <[EMAIL PROTECTED]> To: PHP General <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 9:00 AM Subject: [PHP] Update query > How do you update MySQL in the following way?

[PHP] Update query

2002-12-12 Thread Steve Jackson
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 field how do I update it? In other words how do I use PHP to upda

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

[PHP] update query based on array

2002-12-09 Thread Jason Dulberg
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 array". The problem is that when I read that array to pass to

Re: [PHP] UPDATE Query

2002-09-01 Thread Tony Harrison
inal 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 databases with one query? > > Please look at this example

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

[PHP] UPDATE Query

2002-08-31 Thread Sascha Braun
I want to know if its possible to update two databases with one query? Please look at this example: UPDATE news_db, newsreferenz_db SET news_db.head = 'DFB Pokalasfasf', news_db.text = 'alkfhaslk fl akshf lakshf lkahs lfk aslf yxvyxvyxvyxv', newsreferenz_db.kat_id = '3' WHERE news_db.id = '6'

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

2001-12-06 Thread Andrew Hill
ata Access & Data Integration Technology Providers > -Original Message- > From: mweb [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 06, 2001 7:30 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP] UPDATE Query works in odbc/Mysql, but fails in odbc/MS >

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

2001-12-06 Thread mweb
Hello, I have one MS Access DB on the server, and an exact (theoretically) copy of it in MySQL on my machine, so I can test PHP pages on Linux and install them on an NT server (using odbc of course). I can insert and select just fine, thankl to all your help. The problem is that this UPDATE que

[PHP] Update Query - Urgent -- Succeeded!

2001-10-23 Thread Srinivasan Ranganathan
Hi all Thanks for all the help. told u my mistake was stupid! looks like mysql dosent like ';' at the end of the query! who would've guessed that! thanks all (for being so patient) Srinivasan Ranganathan *NEW* Connect to Yahoo! Mess

[PHP] Update Query - Urgent -- Yes, Full Rights!

2001-10-23 Thread Srinivasan Ranganathan
Hi when i use, mysql_error() i get a call to undefined function error. same with mysql_errno(). and all data is simply text no checkboxes, nothing! Help! *NEW* Connect to Yahoo! Messenger through your mobile phone *NEW* Vi

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 que

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 >

[PHP] Update Query - Urgent -- Yes, Full Rights!

2001-10-23 Thread Srinivasan Ranganathan
Hi Yes, I do have full rights! *NEW* Connect to Yahoo! Messenger through your mobile phone *NEW* Visit http://in.mobile.yahoo.com/smsmgr_signin.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mai

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

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 p

[PHP] Update Query - Urgent

2001-10-23 Thread Srinivasan Ranganathan
Hi I have a php script generate a sql update statement. when i query the database, the update dosent happen. but when i echo the sql string and copy and paste it in my mysql client window, the update happens like it should! what am i missing/doing wrong here? Thanks in advance Srinivasan Rangan