garydt Posted July 17, 2007 Share Posted July 17, 2007 Do you know how to set/change the permissions in PHPYADMIN to allow my pages to delete records in tables? I've looked, theres nothing that i can see. Is there a php script that does it? Link to comment https://forums.phpfreaks.com/topic/60392-table-permissions/ Share on other sites More sharing options...
fenway Posted July 17, 2007 Share Posted July 17, 2007 Your pages? What do you mean. Link to comment https://forums.phpfreaks.com/topic/60392-table-permissions/#findComment-300430 Share on other sites More sharing options...
garydt Posted July 17, 2007 Author Share Posted July 17, 2007 I've got a guestbook on my site and it lets users deletes guestbook messages. On my local server it deletes the records in the table fine but on the remote server it doesn't. I'm guessing its to do with table permissions. How do i change the permission? Link to comment https://forums.phpfreaks.com/topic/60392-table-permissions/#findComment-300463 Share on other sites More sharing options...
fenway Posted July 17, 2007 Share Posted July 17, 2007 I've got a guestbook on my site and it lets users deletes guestbook messages. On my local server it deletes the records in the table fine but on the remote server it doesn't. I'm guessing its to do with table permissions. How do i change the permission? You should check to see what permissions your user has -- are you connecting "remotely"? Link to comment https://forums.phpfreaks.com/topic/60392-table-permissions/#findComment-300539 Share on other sites More sharing options...
garydt Posted July 18, 2007 Author Share Posted July 18, 2007 I've got a guestbook on my site and it lets users deletes guestbook messages. On my local server it deletes the records in the table fine but on the remote server it doesn't. I'm guessing its to do with table permissions. How do i change the permission? You should check to see what permissions your user has -- are you connecting "remotely"? I mean my website is on a server run by 1&1. When the user clicks 'delete guestbook message' it activates this script- mysql_query("DELETE FROM guestbook WHERE id = '$recnum"); but it doesn't delete record,. i get no error either. It works on my computer though. Link to comment https://forums.phpfreaks.com/topic/60392-table-permissions/#findComment-301092 Share on other sites More sharing options...
fenway Posted July 18, 2007 Share Posted July 18, 2007 So they're both local... check mysql_error(). Link to comment https://forums.phpfreaks.com/topic/60392-table-permissions/#findComment-301217 Share on other sites More sharing options...
garydt Posted July 19, 2007 Author Share Posted July 19, 2007 thanks I'm trying to work out how to use mysql-error to see why it won't delete records. What do i need to put? Link to comment https://forums.phpfreaks.com/topic/60392-table-permissions/#findComment-302414 Share on other sites More sharing options...
fenway Posted July 20, 2007 Share Posted July 20, 2007 thanks I'm trying to work out how to use mysql-error to see why it won't delete records. What do i need to put? mysql_query() or mysql_error()... check the manuals. Link to comment https://forums.phpfreaks.com/topic/60392-table-permissions/#findComment-303325 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.