[PHP-DB] Huw do I perform update? I missed the accual code bit.. sorry
Sorry,: This is my query: $query = UPDATE dvd.news_categories SET newscategory='$newscategory', newscat_status='$newscat_status' WHERE newscat_id='$newsid'; but it doesn't seem to work. help anyone? //Tommy
RE: [PHP-DB] Huw do I perform update? I missed the accual code bit.. sorry
What does table look like? What does preceding code look like? What error message are you getting? Try printing the value of $query. What does it look like? Copy/paste that into mysql directly; what error do you get? -Original Message- From: Tommy Nilsson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 11:14 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Huw do I perform update? I missed the accual code bit.. sorry Sorry,: This is my query: $query = UPDATE dvd.news_categories SET newscategory='$newscategory', newscat_status='$newscat_status' WHERE newscat_id='$newsid'; but it doesn't seem to work. help anyone? //Tommy -- PHP Database 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-DB] Huw do I perform update? I missed the accual code bit.. sorry
Id news_id an integer? $query = UPDATE dvd.news_categories SET newscategory='$newscategory', newscat_status='$newscat_status' WHERE newscat_id='$newsid'; ^ if this is an integer in the datebase then it wont update proproly. Should look like this $query = UPDATE dvd.news_categories SET newscategory='$newscategory', newscat_status='$newscat_status' WHERE newscat_id = $newsid; Hope this helps Thank You Brian Paulson Sr. Web Developer The Pueblo Chieftain Online [EMAIL PROTECTED] http://www.chieftain.com -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 10:59 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Huw do I perform update? I missed the accual code bit.. sorry What does table look like? What does preceding code look like? What error message are you getting? Try printing the value of $query. What does it look like? Copy/paste that into mysql directly; what error do you get? -Original Message- From: Tommy Nilsson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 11:14 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Huw do I perform update? I missed the accual code bit.. sorry Sorry,: This is my query: $query = UPDATE dvd.news_categories SET newscategory='$newscategory', newscat_status='$newscat_status' WHERE newscat_id='$newsid'; but it doesn't seem to work. help anyone? //Tommy -- PHP Database 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 Database 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-DB] Huw do I perform update? I missed the accual code bit.. sorry
I have no problem updating integer and float fields when putting them in '' if you update an integer with a blank value, it makes the value in the db =0. always on unix and mysql, though. Ricky -Original Message- From: Brian Paulson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 11:41 AM To: 'Rick Emery'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Huw do I perform update? I missed the accual code bit.. sorry Id news_id an integer? $query = UPDATE dvd.news_categories SET newscategory='$newscategory', newscat_status='$newscat_status' WHERE newscat_id='$newsid'; ^ if this is an integer in the datebase then it wont update proproly. Should look like this $query = UPDATE dvd.news_categories SET newscategory='$newscategory', newscat_status='$newscat_status' WHERE newscat_id = $newsid; Hope this helps Thank You Brian Paulson Sr. Web Developer The Pueblo Chieftain Online [EMAIL PROTECTED] http://www.chieftain.com -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 10:59 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Huw do I perform update? I missed the accual code bit.. sorry What does table look like? What does preceding code look like? What error message are you getting? Try printing the value of $query. What does it look like? Copy/paste that into mysql directly; what error do you get? -Original Message- From: Tommy Nilsson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 11:14 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Huw do I perform update? I missed the accual code bit.. sorry Sorry,: This is my query: $query = UPDATE dvd.news_categories SET newscategory='$newscategory', newscat_status='$newscat_status' WHERE newscat_id='$newsid'; but it doesn't seem to work. help anyone? //Tommy -- PHP Database 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 Database 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 Database 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]