fil2550 Posted February 7, 2013 Share Posted February 7, 2013 Hi all. I have a wonderfully well-working MYSQL database accessed by PHP, but for some reason newly added table rows won't display information from one particular field. I checked for strange/hidden characters, ran some generic test entries, but nothing seems to work. All previous entries still work just fine. Am wondering if I have hit some sort of limit. PHP Version 5.3.10-1ubuntu3.5 MySQL client version: 5.5.29 Quote Link to comment Share on other sites More sharing options...
Barand Posted February 7, 2013 Share Posted February 7, 2013 Am wondering if I have hit some sort of limit. Have you got over 4,000,000,000 rows in the table? Quote Link to comment Share on other sites More sharing options...
DaveyK Posted February 7, 2013 Share Posted February 7, 2013 haha. have you tried echoing (var_dump()) all the correct variables from your form before you actually send them in the sql? Quote Link to comment Share on other sites More sharing options...
fil2550 Posted February 7, 2013 Author Share Posted February 7, 2013 Only have a few hundred rows in my table. I ran the same SQL query via PHPMyAdmin and had it return the results flawlessly. Why would ~150 rows worth of data work perfectly, and then newly added ones dump the output of one particular field. Pounding my head into a wall over this one. All new entries are doing the same. Thanks for the help people. Quote Link to comment Share on other sites More sharing options...
Barand Posted February 7, 2013 Share Posted February 7, 2013 I'd take a close look at the code that is currently adding records to that table Quote Link to comment Share on other sites More sharing options...
fil2550 Posted February 8, 2013 Author Share Posted February 8, 2013 Thanks Barand, but I input all my data by hand using phpmyadmin, and haven't changed anything recently. Quote Link to comment Share on other sites More sharing options...
Jessica Posted February 8, 2013 Share Posted February 8, 2013 If the data shows up in PHPMyAdmin, then the problem is the PHP code that displays the data on your webpage. We can't help without seeing the data and the code. Quote Link to comment Share on other sites More sharing options...
fil2550 Posted February 8, 2013 Author Share Posted February 8, 2013 Thanks Jessica. Much appreciated. But again, every last entry has no issues with the php code. I have several other tables interlinked in the database to make things work, and I've checked all that as well. I've ran test runs in other tables just to make sure, and there are no problems. Just this one here. It makes absolutely no sense. Why would 150+ examples work flawlessly and now new additions don't? Again, I checked, made sure I didn't have any hidden characters in my new data that would muck up the code. I'll post my php code if y'all think it'd be helpfull, but I'm thinking that this is a problem with MYSQL and am not sure what to do. Ugh. Thanks for your help everyone. Quote Link to comment Share on other sites More sharing options...
Jessica Posted February 8, 2013 Share Posted February 8, 2013 When you say the new rows don't display information that doesn't make sense. Rows are stored info. Either you're using PHP or the mysql interface to view them. WHAT is it that makes you think there is a problem?? Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted February 8, 2013 Share Posted February 8, 2013 phpmyadmin IS A PHP SCRIPT. If it displays the data correctly, that means that YOUR PHP CODE is where the problem lies. The quicker you post the code that reproduces the problem, the quicker someone can answer - Why would 150+ examples work flawlessly and now new additions don't? Quote Link to comment 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.