•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,549 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,544 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 2428 | Replies: 3
 |
•
•
Join Date: Jan 2006
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
help!! update mysql problem whats wrong with this code?
i'm really confused!
when i use INSERT code insted of UPDATE in my file, every thing is ok. but when i use UPDATE,it doesn't
work!!
UPDATE:
INSERT:
HTML Code:
i'm really confused!
when i use INSERT code insted of UPDATE in my file, every thing is ok. but when i use UPDATE,it doesn't
work!!
UPDATE:
$query = "UPDATE $tblname SET title='$title', desc='$desc', body='$body', time='$time', faday='$faday', famonth='$famonth', fayear='$fayear', fu_show='$fu_show', fu_day='$fu_day', fu_month='$fu_month', fu_year='$fu_year', wshow='$wshow', dshow='$dshow' WHERE id=$id";
INSERT:
HTML Code:
$query = "INSERT into $tblname values '0', '$title', '$desc', '$body', '$time', '$faday', '$famonth', '$fayear', '$fu_show', '$fu_day', '$fu_month', '$fu_year', '$wshow', '$dshow')" or die(mysql_error());
•
•
Join Date: Mar 2004
Posts: 1,514
Reputation:
Rep Power: 10
Solved Threads: 48
Hello,
Check your grant tables to see if you have the update permission.
http://dev.mysql.com/doc/refman/5.0/...ing-users.html
This could be the source of your problem... you might not have the UPDATE permission.
Christian
Check your grant tables to see if you have the update permission.
http://dev.mysql.com/doc/refman/5.0/...ing-users.html
This could be the source of your problem... you might not have the UPDATE permission.
Christian
•
•
Join Date: Jan 2006
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by kc0arf
Hello,
Check your grant tables to see if you have the update permission.
Christian
thanks for your hint
i use EasyPHP 1.6.0.0
i did it
i checked grant tables
i activated it for All actions, all DBs
but still have problem!
یادباد آنکه درونت نظری با ما بود
رقم مــهر تو بر چهره*ی ما پیدا بود-----------------------------------------------------------------
O' what the good days were those, when you was in love with me.
and because of that, my face was full of happiness.Hafiz
رقم مــهر تو بر چهره*ی ما پیدا بود-----------------------------------------------------------------
O' what the good days were those, when you was in love with me.
and because of that, my face was full of happiness.Hafiz
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
Similar Threads
- about VC+MySQL problem:) (C)
- server notify client to update MySQL table (C)
- php mysql problem (PHP)
- how to update data in mysql table using data from an excel table (MySQL)
- update problem (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: ERROR 2002: Can't connect to local MySQL server
- Next Thread: update problem
