Replacing ID key with column Name

I have looked at the help on this forum concerning the INNER JOIN but I am still a little confused how to execute this MYSQL statement manually.

I have table1 (courses) and reference table2 (course_category).

I have a foriegn key in courses called subject_cat_id. This is the primary key in refernce table 2 (course_category).

After using dataassist wizard, my insert record behaviour, sql statement on my results page looks like this:


SELECT course_id, subject_cat_id, course_title, course_code, course_price

FROM courses



I have tried to do an inner join;


SELECT courses.course_id, courses.subject_cat_id, courses.course_title, courses.course_code, courses.course_price, course_category.course_category_title,

FROM courses

INNER JOIN course_category

ON courses.subject_cat_id = course_category.course_cat_id



I keep coming up with mysql errors. I really need to replace subject_cat_id with subject_category_title, from (table2) course_category on my rsults page.

The 1st thing I see is the extra comma that needs to be removed...

course_category.course_category_title, <<<< delete that comma and try again.

Good catch Tom, the extra comma will cause an Error.


If you still get an error after removing the coma, please post the text of the error. the error may hold some additional clues to the cause.

Hi Tom and Jason,

That extra comma was the problem, Thank you so much.

The only problem now is I am not sure what to do to my results page to effect the change to the mysql statement. Even though the sql statement executed successfully on the "test button", when i exit the recordset window my results page remains exactly the same.

Sorry to ask so many questions, but i have a grave fear of messing up my php code and destroying the whole page.

Do I perhaps have to create another column in my results table and echo the data, and how do I remove/ replace the id column for the name column on the results table safely(without damaging the server behaviours and the php code)?

1st thing. Make Backups often!

Next. Just add a couple of extra <td></td> tags to your result output and then add some columns and see what happens.

With the backups, you can experiment without fear.

:)

I will strongly suggest to do what Tom said as I have learned that lesson the "hard way" way too many times before. :rolleyes:

Thank's Guys,

I will give that a go today, and let you know how I get on

Thank's Guy's

I managed to work out how to get it to display.

Thanks for all your help and time.