I'm using Golive 6 on Mac OS X to play with dynamic content. I'm
using PHPmyADMIN to administer the MySQL database.
I've figured that much out, now- I'm trying to get some relational
databases in there, and ma having trouble: I successfully created the
pma relation table, and I can create the relations I need, BUT when I
go to insert a row into the MASTER table, PHPmyADMIN draws the page,
UP TO the field that should be linked and stops. At the top of the
page is:
You have an error in your SQL syntax near 'WHERE db_name =
'ApologetiX_test' AND table_name = 'RadioStations'' at line 1
And I can't get past that.
Other issues:
It keeps warning me that I'm set up as root with no password, but if I
change that, I can't seem to get it to work.
Also, I don't have all the relational bells and whistles set up, but I
THINK I have the ones I NEED set up. When I click for details I get
this:
Database ApologetiX_test running on localhost
PMA Database ...
OK
relation Table ...
OK
General relation features: Enabled
table_info ...
not OK [ Documentation ]
Display Features: Disabled
table_coords ...
not OK [ Documentation ]
pdf_pages ...
not OK [ Documentation ]
Creation of PDFs: Disabled
column_comments ...
not OK [ Documentation ]
Displaying Column Comments: Disabled
But that shouldn't matter. But what do I know- I can't get it to work.
I need a friend.
One other thing: According to the docs, when I set up the relation, I can go to the foreign table and choose which fields to show. I've never seen that option. I think that's the problem.
Please email me if you can help. My email is my first name at
apologetix dot com. (if you can't figure that out, you probably won't
be able to help with the real problem ;)
Karl
Welcome to WebmasterWorld
Try the following, it might give you a little insight intp phpmyadmin.
ht*tp://faq.oneandone.co.uk/perl/php/5.html
Next you will need to get to grip with relational databases if you dont already know that. If you dont "database design for mere mortals" is a good start, or online (first decent one I found)
phpbuilder.com/columns/barry20000731.php3
Cheers
I think you're out of luck if you try to set up a relational Database in phpMyAdmin if you are thinking of a similar way of doing it as e.g. in MA Access. There you just drag ang and drop your relations and specify the according actions. I think phpMyAdmin's features in this department are just cosmetic and only let you view some relations (at least I couldn't get it to work in any other way)
If you want to use FOREIGN KEY CONSTRAINTS in MySQL you are likely to set them up manually and you have to use InnoDB table type.
Here's another hint: You can also set up your database in MS Access and then make a MySQl dump using a free tool from a company called intranet2internet. You can easily design your relations and display them. The downside is that the dump doesn't give you the relations and actions (you still have to add them manually) Here's the URL for the tool: www.intranet2internet.com
Good luck, hope it helped
Stefan
