2. PHPRunner General questions
  3. [SOLVED]  New Records Not Showing Up
This topic is locked
[SOLVED]

 New Records Not Showing Up

 		1/3/2013 10:35:35 PM
PHPRunner General questions
M
 Mexicomike author

I have an Add page set up to Add new records to a database. It has 3 dropboxes, dependent on each other. Box one is 'Region' which narrows down the choices in Box 2 'Mx States' to show the choices in a specific state 'Mx Cities.' It works great - until I added new records to the 'Cities' database. The new additons do not show up, although the linking fields are properly populated.
On the menu with my database choices is a choice for the underlying Cities database. I check it, and the new additions show up. I have added the new cities through the same PHPRunner form and directly from PhpMyAdmin. Neither makes a difference.
Tried uploading ALL files. No joy. Cleared my cache. No diff. Used another computer. Same story.Used different browsers (FF and Safari). No change.
Thank you. Appreciate the value of this program and normally am not stumped.
C
 		cgphp 1/4/2013

Post the screenshots of the dropdowns settings and the cities table schema.
Sergey Kornilov admin 1/4/2013

If your SQL query uses WHERE clause - make sure new records are not being filtered out by this WHERE clause. For example if your query is similar to

select ... from ... where active=1



while new records are added with active=0 no new records will be visible.
If you need more help with this post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
M
 		Mexicomike author 1/4/2013



Post the screenshots of the dropdowns settings and the cities table schema.



Thank you for the quick response. I figured out a solution, though not the problem. I deleted all files in the directory and re-uploaded all files. Did not affect it. Then deleted the directory and remade the directory (same name) and re-uploaded everything (all files). Now it works. Thanks.
M
 		Mexicomike author 1/4/2013



Thank you for the quick response. I figured out a solution, though not the problem. I deleted all files in the directory and re-uploaded all files. Did not affect it. Then deleted the directory and remade the directory (same name) and re-uploaded everything (all files). Now it works. Thanks.



Thanks for the idea. I scoured the code for that situation and it did not exist. But as I replied above, deleting the whole project from my site and re-uploading everything has fixed it. Thank you again.