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. 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. 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! 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? 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 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. 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 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. 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
Archived
This topic is now archived and is closed to further replies.