Searching in 2 tables.
Posted: Sat Jul 17, 2004 7:16 am
Hi,
I have 2 tables which are they students and users.
I have a form. That I am recording form details in students table.
student table includes
id - name - surname - email
When I approve students request, I copies from students table to users table.
users table includes same fields as students.
I can add add a field to students or users like status and giving them 0 or 1 data to checking it's approved or not. But I have a search page too, so I want to search it quickly, It would be lots of datas on students table.
Am I on right way?
My question is how can I make search on 2 tables in same time?
Thank you.
I have 2 tables which are they students and users.
I have a form. That I am recording form details in students table.
student table includes
id - name - surname - email
When I approve students request, I copies from students table to users table.
users table includes same fields as students.
I can add add a field to students or users like status and giving them 0 or 1 data to checking it's approved or not. But I have a search page too, so I want to search it quickly, It would be lots of datas on students table.
Am I on right way?
My question is how can I make search on 2 tables in same time?
Thank you.