Re: Inputing data to a relational database

Not that I am aware of, because all the referential integrity relating to mysql, is in whatever code you write to access it. So you are going to have to use C,Perl,PHP,Python, or something to access your data, and control integrity. Play with mysql queries in php. As long as you only do selects, you can't damage the table. When you understand how to send the query from php -> mysql, then you can build your insert queries and such, and not worry too much. Php really is easy in this respect, and every PHP book that I have looked at gets you to the point of using mysql really quickly. There are also plenty of tutorials on the net. See the php links page on php.net On 4/8/01 5:11 PM, "Nathan Roberts" <Nathan@fpandts.com> wrote: > I am a nebie to Mysql/php and am currently working on an urgent project, a > on-line catalogue. I have been using phpmyadmin, to create the tables in > MySQL. However I now want to add data into the tables. I am reluctant to > program a php page to do this, as I do not (yet) have sufficient php > knowledge. As far as I can see phpMyadmin doesn't do all I need it to, which > is:- > > The tables reference each other, for example > > The categories are stored in a categories table > The products table includes a field category > > to ensure referential integrity, when adding a product to the products > table, I want to have a combo box that will let me select one of the > categories from the categories table. > > Is there anything like phpmyadmin that will let me do this without me having > to write code. > > Any advice much appreciated > > Nathan Roberts > >