dongsu4345 2014-10-18 23:33
浏览 25

2个不同的表。 用户和成员显示有关一个的信息

I have these two tables in mySQL, patient and users. In users I have 10 different columns

(
1   id  
2   username    
3   password    
4   salt    
5   email   
6   price   
7   firstname   
8   lastname    
9   univers varchar(255)    
10  studentid    
11  mobphone        
12  treatment 
) 

and in patient I have 12 columns.

Upon logging in with a user account I want to be able to see what's in the patient table. And if I log in with a patient account I want to be able to see what's inside the user table.

How do I connect them?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
    • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
    • ¥500 火焰左右视图、视差(基于双目相机)