This topic is locked

Check for a record in another table

6/22/2020 7:51:54 AM
PHPRunner General questions
P
peleflores author

Hi
In my project, I have two tables admission and student. In my admission table there is an appid field the primary key of the table.

In the student table, there is a studentid is the primary key of the table. What I want to do, before adding new record to the student

table, it should check and verify that a value in the appno field is present if yes, proceed with the adding of new record to the student

table. If none, a message should prompt to the user.
Pardon my knowledge in PHP, Im a newbie. Hope you can provide me a clear example.
Best regards

PELE