[PHP] Update Query - Urgent
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 Ranganthan *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-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Update Query - Urgent
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 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 Ranganthan *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-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Update Query - Urgent
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, 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 Ranganthan *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-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Update Query - Urgent
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 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 Ranganthan *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-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Update Query - Urgent -- Yes, Full Rights!
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-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Update Query - Urgent
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! *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-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Update Query - Urgent
-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 happen. but when i echo the sql string and copy and paste it in my mysql client window, the update happens like it should! After the update fails, does an 'echo mysql_error()' tell you anything useful? --- Mark Roedel | Blessed is he who has learned to laugh Systems Programmer| at himself, for he shall never cease LeTourneau University | to be entertained. Longview, Texas, USA | -- John Powell -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Update Query - Urgent
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 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 happen. but when i echo the sql string and copy and paste it in my mysql client window, the update happens like it should! After the update fails, does an 'echo mysql_error()' tell you anything useful? --- Mark Roedel | Blessed is he who has learned to laugh Systems Programmer| at himself, for he shall never cease LeTourneau University | to be entertained. Longview, Texas, USA | -- John Powell -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Update Query - Urgent
Does the form you are using to update use checkboxes?? what kind of values are being passed? Mak [EMAIL PROTECTED] wrote in message 008001c15bc8$3c73e6a0$7e8f9cca@athlon700delta">news:008001c15bc8$3c73e6a0$7e8f9cca@athlon700delta... 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 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 happen. but when i echo the sql string and copy and paste it in my mysql client window, the update happens like it should! After the update fails, does an 'echo mysql_error()' tell you anything useful? --- Mark Roedel | Blessed is he who has learned to laugh Systems Programmer| at himself, for he shall never cease LeTourneau University | to be entertained. Longview, Texas, USA | -- John Powell -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Update Query - Urgent -- Yes, Full Rights!
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* Visit http://in.mobile.yahoo.com/smsmgr_signin.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Update Query - Urgent -- Succeeded!
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! 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-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]