erme Posted February 3, 2010 Share Posted February 3, 2010 Hi, for some reason when I go to add another field in PHPMyAdmin, the whole database doesn't work. Is this standard or am I doing something wrong? I currently have 10 fields and am trying to add 2 more. Quote Link to comment https://forums.phpfreaks.com/topic/190827-more-then-10-fields-in-a-table/ Share on other sites More sharing options...
roopurt18 Posted February 3, 2010 Share Posted February 3, 2010 You can have many more than 10 fields in a table. he whole database doesn't work. Be more specific; most of us are men which means we're not mind readers. Quote Link to comment https://forums.phpfreaks.com/topic/190827-more-then-10-fields-in-a-table/#findComment-1006321 Share on other sites More sharing options...
erme Posted February 3, 2010 Author Share Posted February 3, 2010 When I add another field, the database output on my website disappears! Quote Link to comment https://forums.phpfreaks.com/topic/190827-more-then-10-fields-in-a-table/#findComment-1006322 Share on other sites More sharing options...
roopurt18 Posted February 3, 2010 Share Posted February 3, 2010 Does phpMyAdmin successfully add the column to the table? Quote Link to comment https://forums.phpfreaks.com/topic/190827-more-then-10-fields-in-a-table/#findComment-1006327 Share on other sites More sharing options...
erme Posted February 3, 2010 Author Share Posted February 3, 2010 Yeah it gets added. Its just the output on the website Quote Link to comment https://forums.phpfreaks.com/topic/190827-more-then-10-fields-in-a-table/#findComment-1006330 Share on other sites More sharing options...
roopurt18 Posted February 3, 2010 Share Posted February 3, 2010 Then your PHP code that selects and displays the data is not resilient to modifications in the database design. MySQL and phpMyAdmin are working fine. Your PHP code is broken. How about pasting your CREATE TABLE statement and the associated PHP code that is no longer working. Quote Link to comment https://forums.phpfreaks.com/topic/190827-more-then-10-fields-in-a-table/#findComment-1006335 Share on other sites More sharing options...
erme Posted February 3, 2010 Author Share Posted February 3, 2010 I've worked it out. I was selecting 2 tables with UNION but was only adding a field to one table for testing. Added the same field to the other table and it works. Thanks roopurt18 Quote Link to comment https://forums.phpfreaks.com/topic/190827-more-then-10-fields-in-a-table/#findComment-1006338 Share on other sites More sharing options...
roopurt18 Posted February 3, 2010 Share Posted February 3, 2010 No problem. Quote Link to comment https://forums.phpfreaks.com/topic/190827-more-then-10-fields-in-a-table/#findComment-1006341 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.