MySQL Linked tables Query help
Posted: Thu Feb 06, 2003 3:27 pm
Currently working with
PHP 4.2.3
MySQL 3.23.54
phpMyAdmin 2.3.3pl1
Im using two mysql tables example below.
Im trying to find out howto link fields within them.
How would i go about linking table request, field Department to table departments, field Department
If this is possable with linked tables would it also be possable to have mysql store this query
So requests.Department outputs the linked table data, when used by php.
Rather than php passing querys all time?
(requests)
ID
Request
Request_Date
Requset_Status
Department +
(departments)
ID
Department +
Please help me PHPDN kenobi you are my only hope.
PHP 4.2.3
MySQL 3.23.54
phpMyAdmin 2.3.3pl1
Im using two mysql tables example below.
Im trying to find out howto link fields within them.
How would i go about linking table request, field Department to table departments, field Department
If this is possable with linked tables would it also be possable to have mysql store this query
So requests.Department outputs the linked table data, when used by php.
Rather than php passing querys all time?
(requests)
ID
Request
Request_Date
Requset_Status
Department +
(departments)
ID
Department +
Please help me PHPDN kenobi you are my only hope.