indexing/mysql

[Anon]

Hi,

My problem is that i have a table [All] that is being indexed by the primary key on a table [category] and I need to know how to insert data into both tables and take care of everything at the same time.

Also. What's the select statement for getting the correct info from [All] without the key values of [category] showing up?

Thanks,

Anthony

[Anon]

Select fieldname1, fieldname2, fieldname3, etc from tablename

Try reviewing the SQL tutorials on devshed.com and webmonkey.com