Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › I used WebAssist double optin system and so was advised to make sure I included the row"student_id in the fm_reg_tbl and WebAssist_reg_id in the enrol_tbl.also my reg_tbl name is fm_reg_tbl not WebAssist_reg_tbl! Where does the table know it needs t

I used WebAssist double optin system and so was advised to make sure I included the row"student_id in the fm_reg_tbl and WebAssist_reg_id in the enrol_tbl.also my reg_tbl name is fm_reg_tbl not WebAssist_reg_tbl! Where does the table know it needs t

Thread begun 7/21/2013 1:59 pm by dee | Last modified 7/22/2013 7:15 am by Jason Byrnes | 847 views | 1 replies |

7/21/2013 1:59 pm | #1 dee

I used WebAssist double optin system and so was advised to make sure I included the row"student_id in the fm_reg_tbl and WebAssist_reg_id in the enrol_tbl.also my reg_tbl name is fm_reg_tbl not WebAssist_reg_tbl! Where does the table know it needs to be c

You see I created a student_tbl to join the WebAssist_reg_id with the student_id and called it student_tbl. But how do I tell the database that the student_tbl helps it marry fm_reg_tbl.WebAssist_reg_id = enrol_tbl.student_id together?

7/22/2013 7:15 am | #2 Jason ByrnesWebAssist

This is done when creating your recordsets, you create the recordsets to use join queries:

http://www.w3schools.com/sql/sql_join.asp

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.