This topic is locked
[SOLVED]

 Not seeing all fields from table

6/19/2019 11:47:46 AM
PHPRunner General questions
T
taddmencer author

I'm working on a project (time sensitive so this is frustrating!). I'm using a MySQL database running locally.
in the database area, where I add tables, I created a new table.
THen I added four fields. No problem.
I went in and added about 10 more, hit "modify table".
But nothing shows:

http://prntscr.com/o3yioy
But if I got back to modify, all my fields are there.

http://prntscr.com/o3yj1m
And when I got to phpmyadmin it shows all the fields there as well.

http://prntscr.com/o3yje7
I then looked in the "Fields" tab to see if they're there, but nothing there as well:

http://prntscr.com/o3yk2d
I even went to the editor to see if they're being added there, and nothing:

http://prntscr.com/o3ykyy
I've sync'ed the database several times to make sure it's good. I saved and restarted PHPRunner. Restarted my local MySQL system.
I have until Sept to get this system up and running. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=26501&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Any help would be really appreciated! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=26501&image=2&table=forumtopics' class='bbc_emoticon' alt=':)' />

J
John 6/19/2019

Did you select those fields on the Edit SQL Query page?

T
taddmencer author 6/19/2019



Did you select those fields on the Edit SQL Query page?


Not sure what that is ...
What I do is got the "table" option:

http://prntscr.com/o3yx3q
Then select "Create New Table":

http://prntscr.com/o3yxip
Then add my table fields in the following dialog:

http://prntscr.com/o3yxn4
NOW .. what I DID find is if I go to the left side where it shows all the database tables, I uncheck the table in question, and then check it again, all those fields are now there. And I can add more. It's like it's getting hung up someplace.
Am I missing something with this "Edit SQL Query" stuff?
oh ... wait ... I think I know what you're talking about and know what happened. When I was messing around I think I de-selected certain fields. And since I had edited that query, it hid anything new.
sigh
Noob problem solved. Thanks, jsd. Chalk that one up to buffoonery.