SunQuest
 
           MySQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMySQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old January 19th, 2004, 05:45 AM
mescalito mescalito is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 2 mescalito User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Red face Mysql Update

hi there!! i´m new up here and new in PHP and MYSQL.

My problem it´s a rookie problem.

i´m having troubles using the UPDATE statement.

my table is the primeirapagina, and i´d like to modify the fields texto, titulo,tipo, mes.


UPDATE primeirapagina SET texto='$texto',titulo='$titulo',tipo='$tipo',mes=' $mes' WHERE tipo='e'


Whats the problem with this script???

Thankx

Reply With Quote
  #2  
Old January 19th, 2004, 07:19 AM
dhouston's Avatar
dhouston dhouston is offline
Contributing User
Dev Articles Beginner (1000 - 1499 posts)
 
Join Date: May 2003
Location: Tennessee
Posts: 1,355 dhouston User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via ICQ to dhouston
What kind of error message are you getting?

Reply With Quote
  #3  
Old January 20th, 2004, 06:01 PM
mescalito mescalito is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 2 mescalito User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally posted by dhouston
What kind of error message are you getting?


The problem its that the database its not updated. It stays the same.

The register is not updated.

Any sugestion???

Reply With Quote
  #4  
Old June 22nd, 2004, 11:12 AM
The Angry Mick The Angry Mick is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Location: Atlanta, Georgia
Posts: 1 The Angry Mick User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Hey Mascalito,

Did you ever get a response or a solution to your problem. I having the same issue, although my query code is embedded in a web form. The form processes fine, the result page shows the data as being changed, but in the DB nothing is changed.

Here's my query code:
PHP Code:
if (!(result mysql_query("UPDATE details SET notes='$notes' WHERE id='$id'"), $connection))) 

Reply With Quote
  #5  
Old July 29th, 2004, 11:06 AM
Emskumar Emskumar is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 1 Emskumar User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Update

Hi! friend

pliz try this.


UPDATE primeirapagina SET texto='$texto',titulo='$titulo',tipo='$tipo',mes=' $mes' WHERE tipo='e'


try to print tipo variable and confirm whether it has a value or not.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMySQL Development > Mysql Update


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway