Same tables

[alirezaok]

hi

i am looking for easy way to get difrence beween 2 tables and force to be same table2 from table1 (table2 has more than fileds from table1)

is there any way or script for do it?

[bogu]

Can u be more specific?

alirezaok wrote:

force to be same table2 from table1 (table2 has more than fileds from table1)

What are u trying to say with this?
U want to see witch field have table2 and dont have table1? or witch records have table2 and dont have table1? or what?

[alirezaok]

sorry for language
I want to see witch field have table2 and dont have table1. then i want to make same table2 as same as table1 for it's fileds.

also if there is possibile i want to this job for datatype of fields too

example:
table1
name (text)

table2
name(int)

if there isnot possible only diffrence between some of fileds is enough.

[bogu]

Look for mysql_field_*** functions from php manual.

[laserlight]

Could you provide the database schema? I suspect that you need to normalise your database.