help with phpmyadmin please

jlee2301 · #1 July 20th, 2004, 01:42 PM

Hi I am creating a website and linking it to a database using php and mysql. I need to create the databses in phpmyadmin and have decided on the structure of the tables in the database. However, as expected, there are foreign keys in some of the tables - does anyone know how to link the foreign key of one table into another table within phpmyadmin so the database works properly and can be queried using sql? Is it a case of using an sql command to alter the table? I would really appreciate help with this.
Thanks,
James

**degsy** · #2 July 20th, 2004, 05:23 PM

Welcome

There is a SQL/Query window in phpmyadmin where you can directly enter the SQL code.

jlee2301 · #3 July 21st, 2004, 12:05 PM

Thanks - any ideas on the SQL to use?

**degsy** · #4 July 21st, 2004, 04:32 PM

I'm not great on SQL.

Could you give an example of your table names and what you want to achieve?

Steven.Bentley · #5 July 21st, 2004, 08:08 PM

I've never specified relationships explicitly in MySQL/PHPMyAdmin, I do that when I come to query the database by making sure that the two are equal in the where clause.

So for a db with a table called people with primary key id and a table answers where people.id is a foreign key I might do

select p.firstname, p.lastname, a.q1answer from people p, answers a where p.id=a.id;