Databases
StackOverflow2013
Usersdbo
USvinaya
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USvinaya
    primarykey
    data
    text
    plurals
    1. POUnexpected entry in a <select> field! How did this happen?
      singulars
      1. PTQuestion
    2. POIndex/key on three fields or concat() fields into another column
      singulars
      1. PTQuestion
    3. POPHP form validation on same page - is this logic correct?
      singulars
      1. PTQuestion
    1. PO
      singulars
      1. PTAnswer
    2. POwhere should session_destroy() code be placed?
      singulars
      1. PTQuestion
    3. POMysqli prepared statement for insert not working
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. COSure! I understand the reason behind the comment - and I won't take it wrong! I have seen for myself some of the questions that are asked - you can google with the exact question asked and get the perfect answer!....And of course - guilty as charged - no experience and jumped right in and offered to develop this website!...Only realizing now that I bit off what I have no hope of chewing :D. SO has been a lifesaver - even the caustic responses have pointed me in the right direction. There is just so much to learn and implement that sometimes it becomes overwhelming. Thanks!!!
      singulars
      1. POIf MULTIPLE is enabled for <SELECT>, how is searching based on that field affected?
      1. USvinaya
    2. COWell! Starting from scratch 2 months ago, learned every line of code for HTML/PHP/MySqli by spending 2-3 hours everyday on SO, PHP.net and several others. Ditto for my two questions today. Does that count as research? I now have a live website with static and dynamic content, a mysql database with some 18 tables, user registration with hashed password, account approval, password reset, user segmentation and provisioning, etc. Most sites tell you how to do things. But none other than SO that answered specific questions/doubts when unexpected things happen - hence my questions here!
      singulars
      1. POIf MULTIPLE is enabled for <SELECT>, how is searching based on that field affected?
      1. USvinaya
    3. CO@hakre - I like the way you said it - the part about "offer both in the strong hope" and "the idiot checks". However, I am a novice at this - very new to all the scripts and languages involved. As for idiot check - LOL I feel like the idiot here for not realizing that there could be situations where users might NEED to select more than one option! ...But you live and you learn! ....And of course, multiple selects leads me to new questions like how they will behave in SELECT queries!
      singulars
      1. POUnexpected entry in a <select> field! How did this happen?
      1. USvinaya
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload