Forum Index » PHP + MySQL » MySql Problem
| Posted on Wednesday 15th August 200 at 05:50 PM | |
gbt91 Junior Member |
The server am using for my website went down days ago and i lost all the scripts so i just finish recover everything but whn i try to register a new user or try to update an user profile it doesnt work..but everything in the scripts are ok |
| Posted on Wednesday 15th August 200 at 05:55 PM | |
| ilyas-shezad Junior Member |
Is ther server back up? Also can u provide a link? |
| Posted on Wednesday 15th August 200 at 06:00 PM | |
| gbt91 Junior Member |
everything is ok... but i mean i cant update profiles through the user system... when i tried to register, i wont insert the details into 'members' but it will insert it in others |
| Posted on Wednesday 15th August 200 at 06:23 PM | |
| ilyas-shezad Junior Member |
hmm can i see the inertion code for the members tables and also the table structure? |
| Posted on Wednesday 15th August 200 at 06:50 PM | |
| gbt91 Junior Member |
[CODE] CREATE TABLE `members` ( `id` int(11) NOT NULL auto_increment, `username` varchar(30) NOT NULL default '', `password` varchar(255) NOT NULL default '', `date` varchar(55) NOT NULL default '', `email` varchar(55) NOT NULL default '', `location` varchar(40) NOT NULL default 'N/A', `userlevel` int(3) NOT NULL default '1', `age` int(3) NOT NULL, `sex` varchar(40) NOT NULL default 'N/A', PRIMARY KEY (`id`) ) TYPE=MyISAM; [/CODE] i think the problem is with this table |
| Posted on Wednesday 15th August 200 at 06:55 PM | |
| gbt91 Junior Member |
ok i've found out by mine.. the problem was the members table... |
| Posted on Wednesday 15th August 200 at 06:56 PM | |
| ilyas-shezad Junior Member |
kk can u also give the insertiong code which in the registration table for inserting a row into the table? |